688 lines
40 KiB
Go
688 lines
40 KiB
Go
package copydata
|
||
|
||
import "gitea.com/red-future/common/beans"
|
||
|
||
// CreativeReportSum 广告效果指标表实体
|
||
type CreativeReportSum struct {
|
||
beans.SQLBaseDO `orm:",inherit"`
|
||
|
||
// 订单金额相关字段
|
||
T0OrderPaymentAmt *float64 `orm:"t0_order_payment_amt" json:"t0OrderPaymentAmt" description:"当日总成交订单金额"`
|
||
|
||
// 素材类型字段
|
||
CreativeMaterialType string `orm:"creative_material_type" json:"creativeMaterialType" description:"视频素材类型（视频：HORIZONTAL_SCREEN, VERTICAL_SCREEN, UNKNOWN_TYPE；图集：ATLAS；长图：ATLAS_VERTICAL）"`
|
||
|
||
// 直播相关字段
|
||
LiveName string `orm:"live_name" json:"liveName" description:"直播间名称"`
|
||
AuthorId string `orm:"author_id" json:"authorId" description:"直播用户快手 Id"`
|
||
|
||
// 图片相关字段
|
||
PicUrl string `orm:"pic_url" json:"picUrl" description:"图片 URL"`
|
||
PicName string `orm:"pic_name" json:"picName" description:"图片名称"`
|
||
PicId string `orm:"pic_id" json:"picId" description:"图片 Id"`
|
||
|
||
// 封面相关字段
|
||
CoverUrl string `orm:"cover_url" json:"coverUrl" description:"封面 URL"`
|
||
CoverId *int64 `orm:"cover_id" json:"coverId" description:"封面 Id"`
|
||
|
||
// 转化率相关字段
|
||
ItemOrderConversionRatio *float64 `orm:"item_order_conversion_ratio" json:"itemOrderConversionRatio" description:"转化率"`
|
||
ItemCardClickRatio *float64 `orm:"item_card_click_ratio" json:"itemCardClickRatio" description:"点击率"`
|
||
ItemCardClkCnt *int64 `orm:"item_card_clk_cnt" json:"itemCardClkCnt" description:"商品卡点击数"`
|
||
|
||
// 成本相关字段
|
||
LivePlayCntCost *float64 `orm:"live_play_cnt_cost" json:"livePlayCntCost" description:"直播间观看成本"`
|
||
AdMerchantFollowCost *float64 `orm:"ad_merchant_follow_cost" json:"adMerchantFollowCost" description:"涨粉成本"`
|
||
AdMerchantFollow *int64 `orm:"ad_merchant_follow" json:"adMerchantFollow" description:"涨粉数"`
|
||
|
||
// 净成交相关字段
|
||
NetT0OrderCnt *int64 `orm:"net_t0_order_cnt" json:"netT0OrderCnt" description:"当日累计净成交订单数"`
|
||
NetT0Roi *float64 `orm:"net_t0_roi" json:"netT0Roi" description:"净成交 ROI"`
|
||
NetT0Gmv *float64 `orm:"net_t0_gmv" json:"netT0Gmv" description:"净成交 GMV"`
|
||
|
||
// 视频相关字段
|
||
PhotoName string `orm:"photo_name" json:"photoName" description:"视频名称"`
|
||
PhotoIdStr string `orm:"photo_id_str" json:"photoIdStr" description:"视频 id"`
|
||
PhotoId string `orm:"photo_id" json:"photoId" description:"视频 id"`
|
||
|
||
// 用户属性相关字段
|
||
ModPriceSegment string `orm:"mod_price_segment" json:"modPriceSegment" description:"设备价格区间"`
|
||
AgeSegment string `orm:"age_segment" json:"ageSegment" description:"年龄段"`
|
||
Province string `orm:"province" json:"province" description:"省份名称"`
|
||
Gender string `orm:"gender" json:"gender" description:"性别"`
|
||
|
||
// 播放率相关字段
|
||
AdPhotoPlayedFiveRatio *float64 `orm:"ad_photo_played_five_ratio" json:"adPhotoPlayedFiveRatio" description:"作品 5 秒播放率"`
|
||
AdPhotoPlayedThreeRatio *float64 `orm:"ad_photo_played_three_ratio" json:"adPhotoPlayedThreeRatio" description:"作品 3 秒播放率"`
|
||
|
||
// 订单提交相关字段
|
||
OrderSubmitRoi *float64 `orm:"order_submit_roi" json:"orderSubmitRoi" description:"订单提交 ROI"`
|
||
OrderSubmitAmt *int64 `orm:"order_submit_amt" json:"orderSubmitAmt" description:"外部订单金额"`
|
||
EventOrderSubmitCost *float64 `orm:"event_order_submit_cost" json:"eventOrderSubmitCost" description:"订单提交成本"`
|
||
EventOrderSubmit *int64 `orm:"event_order_submit" json:"eventOrderSubmit" description:"订单提交数"`
|
||
EventOrderPaidRoi *float64 `orm:"event_order_paid_roi" json:"eventOrderPaidRoi" description:"订单支付率"`
|
||
|
||
// 用户行为相关字段
|
||
EventAppInvoked *int64 `orm:"event_app_invoked" json:"eventAppInvoked" description:"唤起应用数"`
|
||
EventAddShoppingCart *int64 `orm:"event_add_shopping_cart" json:"eventAddShoppingCart" description:"添加购物车次数"`
|
||
|
||
// 转化成本相关字段
|
||
ConversionNumCost *float64 `orm:"conversion_num_cost" json:"conversionNumCost" description:"转化成本（回传时间）"`
|
||
AdEffectivePlayNum *int64 `orm:"ad_effective_play_num" json:"adEffectivePlayNum" description:"有效播放数"`
|
||
AdItemClick *int64 `orm:"ad_item_click" json:"adItemClick" description:"行为数"`
|
||
|
||
// 商品相关字段
|
||
MerchantProductId string `orm:"merchant_product_id" json:"merchantProductId" description:"商品 ID"`
|
||
|
||
// 花费相关字段
|
||
CostTotal *float64 `orm:"cost_total" json:"costTotal" description:"花费"`
|
||
|
||
// 曝光相关字段
|
||
AdShow *int64 `orm:"ad_show" json:"adShow" description:"曝光数"`
|
||
AdShow1kCost *float64 `orm:"ad_show1k_cost" json:"adShow1kCost" description:"平均千次广告曝光花费"`
|
||
Impression *int64 `orm:"impression" json:"impression" description:"封面曝光数"`
|
||
PhotoClick *int64 `orm:"photo_click" json:"photoClick" description:"封面点击数"`
|
||
PhotoClickRatio *float64 `orm:"photo_click_ratio" json:"photoClickRatio" description:"封面点击率"`
|
||
Click *int64 `orm:"click" json:"click" description:"素材曝光数"`
|
||
|
||
// 行为相关字段
|
||
ActionbarClick *int64 `orm:"actionbar_click" json:"actionbarClick" description:"行为数"`
|
||
ActionbarClickCost *float64 `orm:"actionbar_click_cost" json:"actionbarClickCost" description:"行为成本"`
|
||
EspClickRatio *float64 `orm:"esp_click_ratio" json:"espClickRatio" description:"行为率"`
|
||
ActionRatio *float64 `orm:"action_ratio" json:"actionRatio" description:"素材点击率"`
|
||
AdItemClickCount *int64 `orm:"ad_item_click_count" json:"adItemClickCount" description:"预约组件点击数"`
|
||
|
||
// 直播时长相关字段
|
||
EspLivePlayedSeconds *int64 `orm:"esp_live_played_seconds" json:"espLivePlayedSeconds" description:"直播平均观看时长"`
|
||
|
||
// 作品播放相关字段
|
||
PlayedThreeSeconds *int64 `orm:"played_three_seconds" json:"playedThreeSeconds" description:"作品 3 秒播放数"`
|
||
Play3sRatio *float64 `orm:"play3s_ratio" json:"play3sRatio" description:"作品 3 秒播放率"`
|
||
PlayedFiveSeconds *int64 `orm:"played_five_seconds" json:"playedFiveSeconds" description:"作品 5 秒播放数"`
|
||
Play5sRatio *float64 `orm:"play5s_ratio" json:"play5sRatio" description:"作品 5 秒播放率"`
|
||
PlayedEnd *int64 `orm:"played_end" json:"playedEnd" description:"作品完播数"`
|
||
PlayEndRatio *float64 `orm:"play_end_ratio" json:"playEndRatio" description:"作品完播率"`
|
||
|
||
// 作品互动相关字段
|
||
Share *int64 `orm:"share" json:"share" description:"作品分享数"`
|
||
Comment *int64 `orm:"comment" json:"comment" description:"作品评论数"`
|
||
Likes *int64 `orm:"likes" json:"likes" description:"作品点赞数"`
|
||
Report *int64 `orm:"report" json:"report" description:"作品举报数"`
|
||
Block *int64 `orm:"block" json:"block" description:"作品拉黑数"`
|
||
ItemNegative *int64 `orm:"item_negative" json:"itemNegative" description:"详情页减少此类作品数"`
|
||
|
||
// 直播互动相关字段
|
||
LiveShare *int64 `orm:"live_share" json:"liveShare" description:"直播送礼数"`
|
||
LiveComment *int64 `orm:"live_comment" json:"liveComment" description:"直播评论数"`
|
||
LiveReward *int64 `orm:"live_reward" json:"liveReward" description:"直播送礼数"`
|
||
|
||
// 有效播放相关字段
|
||
EffectivePlayCount *int64 `orm:"effective_play_count" json:"effectivePlayCount" description:"有效播放数"`
|
||
EffectivePlayRatio *float64 `orm:"effective_play_ratio" json:"effectivePlayRatio" description:"有效播放率"`
|
||
|
||
// 转化相关字段
|
||
ConversionNum *int64 `orm:"conversion_num" json:"conversionNum" description:"转化数"`
|
||
ConversionCostEsp *float64 `orm:"conversion_cost_esp" json:"conversionCostEsp" description:"转化成本"`
|
||
Roi *float64 `orm:"roi" json:"roi" description:"直接 ROI"`
|
||
Gmv *float64 `orm:"gmv" json:"gmv" description:"直接 GMV"`
|
||
|
||
// 累计 GMV 相关字段
|
||
T0Gmv *float64 `orm:"t0_gmv" json:"t0Gmv" description:"当日累计 GMV"`
|
||
T1Gmv *float64 `orm:"t1_gmv" json:"t1Gmv" description:"次日累计 GMV"`
|
||
T7Gmv *float64 `orm:"t7_gmv" json:"t7Gmv" description:"7 日累计 GMV"`
|
||
T15Gmv *float64 `orm:"t15_gmv" json:"t15Gmv" description:"15 日累计 GMV"`
|
||
T30Gmv *float64 `orm:"t30_gmv" json:"t30Gmv" description:"30 日累计 GMV"`
|
||
|
||
// 累计 ROI 相关字段
|
||
T0Roi *float64 `orm:"t0_roi" json:"t0Roi" description:"当日累计 ROI"`
|
||
T1Roi *float64 `orm:"t1_roi" json:"t1Roi" description:"次日累计 ROI"`
|
||
T7Roi *float64 `orm:"t7_roi" json:"t7Roi" description:"7 日累计 ROI"`
|
||
T15Roi *float64 `orm:"t15_roi" json:"t15Roi" description:"15 日累计 ROI"`
|
||
T30Roi *float64 `orm:"t30_roi" json:"t30Roi" description:"30 日累计 ROI"`
|
||
|
||
// 订单相关字段
|
||
PaiedOrder *int64 `orm:"paied_order" json:"paiedOrder" description:"直接订单数"`
|
||
OrderRatio *float64 `orm:"order_ratio" json:"orderRatio" description:"直接下单率"`
|
||
T0OrderCnt *int64 `orm:"t0_order_cnt" json:"t0OrderCnt" description:"当日累计订单数"`
|
||
T0OrderCntCost *float64 `orm:"t0_order_cnt_cost" json:"t0OrderCntCost" description:"当日累计订单成本"`
|
||
T0OrderCntRatio *float64 `orm:"t0_order_cnt_ratio" json:"t0OrderCntRatio" description:"累计订单下单率"`
|
||
T1OrderCnt *int64 `orm:"t1_order_cnt" json:"t1OrderCnt" description:"次日累计订单数"`
|
||
T7OrderCnt *int64 `orm:"t7_order_cnt" json:"t7OrderCnt" description:"7 日累计订单数"`
|
||
T15OrderCnt *int64 `orm:"t15_order_cnt" json:"t15OrderCnt" description:"15 日累计订单数"`
|
||
T30OrderCnt *int64 `orm:"t30_order_cnt" json:"t30OrderCnt" description:"30 日累计订单数"`
|
||
|
||
// 涨粉相关字段
|
||
MerchantRecoFans *int64 `orm:"merchant_reco_fans" json:"merchantRecoFans" description:"涨粉数"`
|
||
T1Retention *float64 `orm:"t1_retention" json:"t1Retention" description:"次日涨粉留存数"`
|
||
T7Retention *float64 `orm:"t7_retention" json:"t7Retention" description:"7 日涨粉留存数"`
|
||
T15Retention *float64 `orm:"t15_retention" json:"t15Retention" description:"15 日涨粉留存数"`
|
||
T30Retention *float64 `orm:"t30_retention" json:"t30Retention" description:"30 日涨粉留存数"`
|
||
T1RetentionRatio *float64 `orm:"t1_retention_ratio" json:"t1RetentionRatio" description:"次日涨粉留存率"`
|
||
T7RetentionRatio *float64 `orm:"t7_retention_ratio" json:"t7RetentionRatio" description:"7 日涨粉留存率"`
|
||
T15RetentionRatio *float64 `orm:"t15_retention_ratio" json:"t15RetentionRatio" description:"15 日涨粉留存率"`
|
||
T30RetentionRatio *float64 `orm:"t30_retention_ratio" json:"t30RetentionRatio" description:"30 日涨粉留存率"`
|
||
|
||
// 直播预约相关字段
|
||
ReservationSuccess *int64 `orm:"reservation_success" json:"reservationSuccess" description:"直播预约成功数"`
|
||
ReservationCost *float64 `orm:"reservation_cost" json:"reservationCost" description:"直播预约成功成本"`
|
||
|
||
// 直播观看相关字段
|
||
StandardLivePlayedStarted *int64 `orm:"standard_live_played_started" json:"standardLivePlayedStarted" description:"直播观看数"`
|
||
AdLivePlayCnt *int64 `orm:"ad_live_play_cnt" json:"adLivePlayCnt" description:"直播间人气数"`
|
||
AdLivePlayCntCost *float64 `orm:"ad_live_play_cnt_cost" json:"adLivePlayCntCost" description:"直播间人气成本"`
|
||
LiveAudienceCost *float64 `orm:"live_audience_cost" json:"liveAudienceCost" description:"直播观看成本"`
|
||
|
||
// 直播间商品相关字段
|
||
LiveEventGoodsView *int64 `orm:"live_event_goods_view" json:"liveEventGoodsView" description:"直播间商品点击数"`
|
||
GoodsClickRatio *float64 `orm:"goods_click_ratio" json:"goodsClickRatio" description:"直播间商品点击率"`
|
||
|
||
// 新客相关字段
|
||
DirectAttrPlatNewBuyerCnt *int64 `orm:"direct_attr_plat_new_buyer_cnt" json:"directAttrPlatNewBuyerCnt" description:"直接平台新客"`
|
||
T30AttrPlatTotalBuyerCnt *int64 `orm:"t30_attr_plat_total_buyer_cnt" json:"t30AttrPlatTotalBuyerCnt" description:"30 日累计平台新客"`
|
||
DirectAttrSellerNewBuyerCnt *int64 `orm:"direct_attr_seller_new_buyer_cnt" json:"directAttrSellerNewBuyerCnt" description:"直接店铺新客"`
|
||
T30AttrSellerTotalBuyerCnt *int64 `orm:"t30_attr_seller_total_buyer_cnt" json:"t30AttrSellerTotalBuyerCnt" description:"30 日累计店铺新客"`
|
||
|
||
// 3 日累计相关字段
|
||
T3Gmv *float64 `orm:"t3_gmv" json:"t3Gmv" description:"3 日累计 GMV"`
|
||
T3OrderCnt *int64 `orm:"t3_order_cnt" json:"t3OrderCnt" description:"3 日累计订单数"`
|
||
T3Roi *float64 `orm:"t3_roi" json:"t3Roi" description:"3 日累计 ROI"`
|
||
|
||
// 7 日间接订单相关字段
|
||
T7IndirectOrderAmt *float64 `orm:"t7_indirect_order_amt" json:"t7IndirectOrderAmt" description:"7 日间接订单金额"`
|
||
T7IndirectOrderCnt *int64 `orm:"t7_indirect_order_cnt" json:"t7IndirectOrderCnt" description:"7 日间接订单数"`
|
||
|
||
// 粉丝人均销售额相关字段
|
||
FansT0GmvPerFans *float64 `orm:"fans_t0_gmv_per_fans" json:"fansT0GmvPerFans" description:"新增粉丝人均销售额"`
|
||
FansT3GmvPerFans *float64 `orm:"fans_t3_gmv_per_fans" json:"fansT3GmvPerFans" description:"3 日新增粉丝人均销售额"`
|
||
FansT7GmvPerFans *float64 `orm:"fans_t7_gmv_per_fans" json:"fansT7GmvPerFans" description:"7 日新增粉丝人均销售额"`
|
||
FansT15GmvPerFans *float64 `orm:"fans_t15_gmv_per_fans" json:"fansT15GmvPerFans" description:"15 日新增粉丝人均销售额"`
|
||
FansT30GmvPerFans *float64 `orm:"fans_t30_gmv_per_fans" json:"fansT30GmvPerFans" description:"30 日新增粉丝人均销售额"`
|
||
|
||
// 涨粉成本相关字段
|
||
RecoFansCost *float64 `orm:"reco_fans_cost" json:"recoFansCost" description:"涨粉成本"`
|
||
|
||
// 智能优惠券相关字段
|
||
QcpxWhiteboxDirectOrderPaymentAmt *float64 `orm:"qcpx_whitebox_direct_order_payment_amt" json:"qcpxWhiteboxDirectOrderPaymentAmt" description:"智能优惠券订单 GMV"`
|
||
QcpxWhiteboxDirectOrderCnt *int64 `orm:"qcpx_whitebox_direct_order_cnt" json:"qcpxWhiteboxDirectOrderCnt" description:"智能优惠券订单数"`
|
||
|
||
// 粉丝 GMV 相关字段
|
||
FansT0Gmv *float64 `orm:"fans_t0_gmv" json:"fansT0Gmv" description:"涨粉当日 GMV"`
|
||
FansT1Gmv *float64 `orm:"fans_t1_gmv" json:"fansT1Gmv" description:"涨粉次日 GMV"`
|
||
FansT7Gmv *float64 `orm:"fans_t7_gmv" json:"fansT7Gmv" description:"涨粉 7 日 GMV"`
|
||
FansT15Gmv *float64 `orm:"fans_t15_gmv" json:"fansT15Gmv" description:"涨粉 15 日 GMV"`
|
||
FansT30Gmv *float64 `orm:"fans_t30_gmv" json:"fansT30Gmv" description:"涨粉 30 日 GMV"`
|
||
|
||
// 粉丝 ROI 相关字段
|
||
FansT0Roi *float64 `orm:"fans_t0_roi" json:"fansT0Roi" description:"涨粉当日 ROI"`
|
||
FansT1Roi *float64 `orm:"fans_t1_roi" json:"fansT1Roi" description:"涨粉次日 ROI"`
|
||
FansT7Roi *float64 `orm:"fans_t7_roi" json:"fansT7Roi" description:"涨粉 7 日 ROI"`
|
||
FansT15Roi *float64 `orm:"fans_t15_roi" json:"fansT15Roi" description:"涨粉 15 日 ROI"`
|
||
FansT30Roi *float64 `orm:"fans_t30_roi" json:"fansT30Roi" description:"涨粉 30 日 ROI"`
|
||
|
||
// 新客 GMV 相关字段
|
||
T0ShopNewBuyerOrderPaymentAmt *float64 `orm:"t0_shop_new_buyer_order_payment_amt" json:"t0ShopNewBuyerOrderPaymentAmt" description:"当日新客 GMV"`
|
||
T1ShopNewBuyerOrderPaymentAmt *float64 `orm:"t1_shop_new_buyer_order_payment_amt" json:"t1ShopNewBuyerOrderPaymentAmt" description:"投后 1 日新客 GMV"`
|
||
T3ShopNewBuyerOrderPaymentAmt *float64 `orm:"t3_shop_new_buyer_order_payment_amt" json:"t3ShopNewBuyerOrderPaymentAmt" description:"投后 3 日新客 GMV"`
|
||
T7ShopNewBuyerOrderPaymentAmt *float64 `orm:"t7_shop_new_buyer_order_payment_amt" json:"t7ShopNewBuyerOrderPaymentAmt" description:"投后 7 日新客 GMV"`
|
||
T15ShopNewBuyerOrderPaymentAmt *float64 `orm:"t15_shop_new_buyer_order_payment_amt" json:"t15ShopNewBuyerOrderPaymentAmt" description:"投后 15 日新客 GMV"`
|
||
T30ShopNewBuyerOrderPaymentAmt *float64 `orm:"t30_shop_new_buyer_order_payment_amt" json:"t30ShopNewBuyerOrderPaymentAmt" description:"投后 30 日新客 GMV"`
|
||
|
||
// 新客订单数相关字段
|
||
T0ShopNewBuyerOrderCnt *int64 `orm:"t0_shop_new_buyer_order_cnt" json:"t0ShopNewBuyerOrderCnt" description:"当日新客成交订单量"`
|
||
T1ShopNewBuyerOrderCnt *int64 `orm:"t1_shop_new_buyer_order_cnt" json:"t1ShopNewBuyerOrderCnt" description:"投后 1 日新客成交订单量"`
|
||
T3ShopNewBuyerOrderCnt *int64 `orm:"t3_shop_new_buyer_order_cnt" json:"t3ShopNewBuyerOrderCnt" description:"投后 3 日新客成交订单量"`
|
||
T7ShopNewBuyerOrderCnt *int64 `orm:"t7_shop_new_buyer_order_cnt" json:"t7ShopNewBuyerOrderCnt" description:"投后 7 日新客成交订单量"`
|
||
T15ShopNewBuyerOrderCnt *int64 `orm:"t15_shop_new_buyer_order_cnt" json:"t15ShopNewBuyerOrderCnt" description:"投后 15 日新客成交订单量"`
|
||
T30ShopNewBuyerOrderCnt *int64 `orm:"t30_shop_new_buyer_order_cnt" json:"t30ShopNewBuyerOrderCnt" description:"投后 30 日新客成交订单量"`
|
||
|
||
// 新客复购率相关字段
|
||
T1NewBuyerRepurchaseRatio *float64 `orm:"t1_new_buyer_repurchase_ratio" json:"t1NewBuyerRepurchaseRatio" description:"投后 1 日新客复购率"`
|
||
T3NewBuyerRepurchaseRatio *float64 `orm:"t3_new_buyer_repurchase_ratio" json:"t3NewBuyerRepurchaseRatio" description:"投后 3 日新客复购率"`
|
||
T7NewBuyerRepurchaseRatio *float64 `orm:"t7_new_buyer_repurchase_ratio" json:"t7NewBuyerRepurchaseRatio" description:"投后 7 日新客复购率"`
|
||
T15NewBuyerRepurchaseRatio *float64 `orm:"t15_new_buyer_repurchase_ratio" json:"t15NewBuyerRepurchaseRatio" description:"投后 15 日新客复购率"`
|
||
T30NewBuyerRepurchaseRatio *float64 `orm:"t30_new_buyer_repurchase_ratio" json:"t30NewBuyerRepurchaseRatio" description:"投后 30 日新客复购率"`
|
||
|
||
// 新客 ROI 相关字段
|
||
T0ShopNewBuyerRoi *float64 `orm:"t0_shop_new_buyer_roi" json:"t0ShopNewBuyerRoi" description:"投后当日新客 ROI"`
|
||
T1ShopNewBuyerRoi *float64 `orm:"t1_shop_new_buyer_roi" json:"t1ShopNewBuyerRoi" description:"投后 1 日新客 ROI"`
|
||
T3ShopNewBuyerRoi *float64 `orm:"t3_shop_new_buyer_roi" json:"t3ShopNewBuyerRoi" description:"投后 3 日新客 ROI"`
|
||
T7ShopNewBuyerRoi *float64 `orm:"t7_shop_new_buyer_roi" json:"t7ShopNewBuyerRoi" description:"投后 7 日新客 ROI"`
|
||
T15ShopNewBuyerRoi *float64 `orm:"t15_shop_new_buyer_roi" json:"t15ShopNewBuyerRoi" description:"投后 15 日新客 ROI"`
|
||
T30ShopNewBuyerRoi *float64 `orm:"t30_shop_new_buyer_roi" json:"t30ShopNewBuyerRoi" description:"投后 30 日新客 ROI"`
|
||
|
||
// 制卡订单相关字段
|
||
CreateCardOrderCnt *int64 `orm:"create_card_order_cnt" json:"createCardOrderCnt" description:"有效制卡订单数（回传时间）"`
|
||
ForwardTsCreateCardOrderCnt *int64 `orm:"forward_ts_create_card_order_cnt" json:"forwardTsCreateCardOrderCnt" description:"有效制卡订单数（计费时间）"`
|
||
CreateCardOrderCost *float64 `orm:"create_card_order_cost" json:"createCardOrderCost" description:"有效制卡订单成本（回传时间）"`
|
||
ForwardTsCreateCardOrderCost *float64 `orm:"forward_ts_create_card_order_cost" json:"forwardTsCreateCardOrderCost" description:"有效制卡订单成本（计费时间）"`
|
||
|
||
// 电话卡激活相关字段
|
||
ActivateCardOrderCnt *int64 `orm:"activate_card_order_cnt" json:"activateCardOrderCnt" description:"电话卡激活订单数（回传时间）"`
|
||
ForwardTsActivateCardOrderCnt *int64 `orm:"forward_ts_activate_card_order_cnt" json:"forwardTsActivateCardOrderCnt" description:"电话卡激活订单数（计费时间）"`
|
||
ActivateCardOrderCost *float64 `orm:"activate_card_order_cost" json:"activateCardOrderCost" description:"电话卡激活订单成本（回传时间）"`
|
||
ForwardTsActivateCardOrderCost *float64 `orm:"forward_ts_activate_card_order_cost" json:"forwardTsActivateCardOrderCost" description:"电话卡激活订单成本（计费时间）"`
|
||
|
||
// 制卡订单率相关字段
|
||
CreateCardOrderRatio *float64 `orm:"create_card_order_ratio" json:"createCardOrderRatio" description:"有效制卡订单率（回传时间）"`
|
||
ForwardTsCreateCardOrderRatio *float64 `orm:"forward_ts_create_card_order_ratio" json:"forwardTsCreateCardOrderRatio" description:"有效制卡订单率（计费时间）"`
|
||
|
||
// 电话卡激活率相关字段
|
||
ActivateCardOrderCntRatio *float64 `orm:"activate_card_order_cnt_ratio" json:"activateCardOrderCntRatio" description:"电话卡激活率（回传时间）"`
|
||
ForwardTsActivateCardOrderRatio *float64 `orm:"forward_ts_activate_card_order_ratio" json:"forwardTsActivateCardOrderRatio" description:"电话卡激活率（计费时间）"`
|
||
|
||
// 直播观看相关字段
|
||
LivePlayCnt *int64 `orm:"live_play_cnt" json:"livePlayCnt" description:"全站直播观看数"`
|
||
ItemEntranceClkCnt *int64 `orm:"item_entrance_clk_cnt" json:"itemEntranceClkCnt" description:"小黄车点击数"`
|
||
ShowCnt *int64 `orm:"show_cnt" json:"showCnt" description:"全站曝光"`
|
||
|
||
// 报告日期字段
|
||
ReportDateStr string `orm:"report_date_str" json:"reportDateStr" description:"时间"`
|
||
|
||
// 广告计划相关字段
|
||
CampaignId *int64 `orm:"campaign_id" json:"campaignId" description:"计划 ID"`
|
||
CampaignName string `orm:"campaign_name" json:"campaignName" description:"计划名称"`
|
||
|
||
// 广告单元相关字段
|
||
UnitId *int64 `orm:"unit_id" json:"unitId" description:"单元 ID"`
|
||
UnitName string `orm:"unit_name" json:"unitName" description:"单元名称"`
|
||
|
||
// 广告创意相关字段
|
||
CreativeId *int64 `orm:"creative_id" json:"creativeId" description:"创意 ID"`
|
||
CreativeName string `orm:"creative_name" json:"creativeName" description:"创意名称"`
|
||
|
||
// 新增字段
|
||
CidActualRoiAfterSubsidy *float64 `orm:"cid_actual_roi_after_subsidy" json:"cidActualRoiAfterSubsidy" description:"补贴后实际 ROI"`
|
||
CidCouponAmount *int64 `orm:"cid_coupon_amount" json:"cidCouponAmount" description:"核销券金额"`
|
||
CidCouponCallbackPaidRefundAmount *int64 `orm:"cid_coupon_callback_paid_refund_amount" json:"cidCouponCallbackPaidRefundAmount" description:"退单有回传_核销券金额"`
|
||
CidVoucherCost *float64 `orm:"cid_voucher_cost" json:"cidVoucherCost" description:"券成本"`
|
||
}
|
||
|
||
// CreativeReportSumCol 广告效果指标表字段定义
|
||
type CreativeReportSumCol struct {
|
||
beans.SQLBaseCol
|
||
T0OrderPaymentAmt string
|
||
CreativeMaterialType string
|
||
LiveName string
|
||
AuthorId string
|
||
PicUrl string
|
||
PicName string
|
||
PicId string
|
||
CoverUrl string
|
||
CoverId string
|
||
ItemOrderConversionRatio string
|
||
ItemCardClickRatio string
|
||
ItemCardClkCnt string
|
||
LivePlayCntCost string
|
||
AdMerchantFollowCost string
|
||
AdMerchantFollow string
|
||
NetT0OrderCnt string
|
||
NetT0Roi string
|
||
NetT0Gmv string
|
||
PhotoName string
|
||
PhotoIdStr string
|
||
PhotoId string
|
||
ModPriceSegment string
|
||
AgeSegment string
|
||
Province string
|
||
Gender string
|
||
AdPhotoPlayedFiveRatio string
|
||
AdPhotoPlayedThreeRatio string
|
||
OrderSubmitRoi string
|
||
OrderSubmitAmt string
|
||
EventOrderSubmitCost string
|
||
EventOrderSubmit string
|
||
EventOrderPaidRoi string
|
||
EventAppInvoked string
|
||
EventAddShoppingCart string
|
||
ConversionNumCost string
|
||
AdEffectivePlayNum string
|
||
AdItemClick string
|
||
MerchantProductId string
|
||
CostTotal string
|
||
AdShow string
|
||
AdShow1kCost string
|
||
Impression string
|
||
PhotoClick string
|
||
PhotoClickRatio string
|
||
Click string
|
||
ActionbarClick string
|
||
ActionbarClickCost string
|
||
EspClickRatio string
|
||
ActionRatio string
|
||
AdItemClickCount string
|
||
EspLivePlayedSeconds string
|
||
PlayedThreeSeconds string
|
||
Play3sRatio string
|
||
PlayedFiveSeconds string
|
||
Play5sRatio string
|
||
PlayedEnd string
|
||
PlayEndRatio string
|
||
Share string
|
||
Comment string
|
||
Likes string
|
||
Report string
|
||
Block string
|
||
ItemNegative string
|
||
LiveShare string
|
||
LiveComment string
|
||
LiveReward string
|
||
EffectivePlayCount string
|
||
EffectivePlayRatio string
|
||
ConversionNum string
|
||
ConversionCostEsp string
|
||
Roi string
|
||
Gmv string
|
||
T0Gmv string
|
||
T1Gmv string
|
||
T7Gmv string
|
||
T15Gmv string
|
||
T30Gmv string
|
||
T0Roi string
|
||
T1Roi string
|
||
T7Roi string
|
||
T15Roi string
|
||
T30Roi string
|
||
PaiedOrder string
|
||
OrderRatio string
|
||
T0OrderCnt string
|
||
T0OrderCntCost string
|
||
T0OrderCntRatio string
|
||
T1OrderCnt string
|
||
T7OrderCnt string
|
||
T15OrderCnt string
|
||
T30OrderCnt string
|
||
MerchantRecoFans string
|
||
T1Retention string
|
||
T7Retention string
|
||
T15Retention string
|
||
T30Retention string
|
||
T1RetentionRatio string
|
||
T7RetentionRatio string
|
||
T15RetentionRatio string
|
||
T30RetentionRatio string
|
||
ReservationSuccess string
|
||
ReservationCost string
|
||
StandardLivePlayedStarted string
|
||
AdLivePlayCnt string
|
||
AdLivePlayCntCost string
|
||
LiveAudienceCost string
|
||
LiveEventGoodsView string
|
||
GoodsClickRatio string
|
||
DirectAttrPlatNewBuyerCnt string
|
||
T30AttrPlatTotalBuyerCnt string
|
||
DirectAttrSellerNewBuyerCnt string
|
||
T30AttrSellerTotalBuyerCnt string
|
||
T3Gmv string
|
||
T3OrderCnt string
|
||
T3Roi string
|
||
T7IndirectOrderAmt string
|
||
T7IndirectOrderCnt string
|
||
FansT0GmvPerFans string
|
||
FansT3GmvPerFans string
|
||
FansT7GmvPerFans string
|
||
FansT15GmvPerFans string
|
||
FansT30GmvPerFans string
|
||
RecoFansCost string
|
||
QcpxWhiteboxDirectOrderPaymentAmt string
|
||
QcpxWhiteboxDirectOrderCnt string
|
||
FansT0Gmv string
|
||
FansT1Gmv string
|
||
FansT7Gmv string
|
||
FansT15Gmv string
|
||
FansT30Gmv string
|
||
FansT0Roi string
|
||
FansT1Roi string
|
||
FansT7Roi string
|
||
FansT15Roi string
|
||
FansT30Roi string
|
||
T0ShopNewBuyerOrderPaymentAmt string
|
||
T1ShopNewBuyerOrderPaymentAmt string
|
||
T3ShopNewBuyerOrderPaymentAmt string
|
||
T7ShopNewBuyerOrderPaymentAmt string
|
||
T15ShopNewBuyerOrderPaymentAmt string
|
||
T30ShopNewBuyerOrderPaymentAmt string
|
||
T0ShopNewBuyerOrderCnt string
|
||
T1ShopNewBuyerOrderCnt string
|
||
T3ShopNewBuyerOrderCnt string
|
||
T7ShopNewBuyerOrderCnt string
|
||
T15ShopNewBuyerOrderCnt string
|
||
T30ShopNewBuyerOrderCnt string
|
||
T1NewBuyerRepurchaseRatio string
|
||
T3NewBuyerRepurchaseRatio string
|
||
T7NewBuyerRepurchaseRatio string
|
||
T15NewBuyerRepurchaseRatio string
|
||
T30NewBuyerRepurchaseRatio string
|
||
T0ShopNewBuyerRoi string
|
||
T1ShopNewBuyerRoi string
|
||
T3ShopNewBuyerRoi string
|
||
T7ShopNewBuyerRoi string
|
||
T15ShopNewBuyerRoi string
|
||
T30ShopNewBuyerRoi string
|
||
CreateCardOrderCnt string
|
||
ForwardTsCreateCardOrderCnt string
|
||
CreateCardOrderCost string
|
||
ForwardTsCreateCardOrderCost string
|
||
ActivateCardOrderCnt string
|
||
ForwardTsActivateCardOrderCnt string
|
||
ActivateCardOrderCost string
|
||
ForwardTsActivateCardOrderCost string
|
||
CreateCardOrderRatio string
|
||
ForwardTsCreateCardOrderRatio string
|
||
ActivateCardOrderCntRatio string
|
||
ForwardTsActivateCardOrderRatio string
|
||
LivePlayCnt string
|
||
ItemEntranceClkCnt string
|
||
ShowCnt string
|
||
ReportDateStr string
|
||
CampaignId string
|
||
CampaignName string
|
||
UnitId string
|
||
UnitName string
|
||
CreativeId string
|
||
CreativeName string
|
||
CidActualRoiAfterSubsidy string
|
||
CidCouponAmount string
|
||
CidCouponCallbackPaidRefundAmount string
|
||
CidVoucherCost string
|
||
}
|
||
|
||
// TableName 返回表名
|
||
func (e *CreativeReportSum) TableName() string {
|
||
return "creative_report_sum"
|
||
}
|
||
|
||
// GetCols 获取所有字段名
|
||
func (e *CreativeReportSum) GetCols() *CreativeReportSumCol {
|
||
return &CreativeReportSumCol{
|
||
SQLBaseCol: beans.SQLBaseCol{
|
||
Id: "id",
|
||
CreatedAt: "created_at",
|
||
UpdatedAt: "updated_at",
|
||
},
|
||
T0OrderPaymentAmt: "t0_order_payment_amt",
|
||
CreativeMaterialType: "creative_material_type",
|
||
LiveName: "live_name",
|
||
AuthorId: "author_id",
|
||
PicUrl: "pic_url",
|
||
PicName: "pic_name",
|
||
PicId: "pic_id",
|
||
CoverUrl: "cover_url",
|
||
CoverId: "cover_id",
|
||
ItemOrderConversionRatio: "item_order_conversion_ratio",
|
||
ItemCardClickRatio: "item_card_click_ratio",
|
||
ItemCardClkCnt: "item_card_clk_cnt",
|
||
LivePlayCntCost: "live_play_cnt_cost",
|
||
AdMerchantFollowCost: "ad_merchant_follow_cost",
|
||
AdMerchantFollow: "ad_merchant_follow",
|
||
NetT0OrderCnt: "net_t0_order_cnt",
|
||
NetT0Roi: "net_t0_roi",
|
||
NetT0Gmv: "net_t0_gmv",
|
||
PhotoName: "photo_name",
|
||
PhotoIdStr: "photo_id_str",
|
||
PhotoId: "photo_id",
|
||
ModPriceSegment: "mod_price_segment",
|
||
AgeSegment: "age_segment",
|
||
Province: "province",
|
||
Gender: "gender",
|
||
AdPhotoPlayedFiveRatio: "ad_photo_played_five_ratio",
|
||
AdPhotoPlayedThreeRatio: "ad_photo_played_three_ratio",
|
||
OrderSubmitRoi: "order_submit_roi",
|
||
OrderSubmitAmt: "order_submit_amt",
|
||
EventOrderSubmitCost: "event_order_submit_cost",
|
||
EventOrderSubmit: "event_order_submit",
|
||
EventOrderPaidRoi: "event_order_paid_roi",
|
||
EventAppInvoked: "event_app_invoked",
|
||
EventAddShoppingCart: "event_add_shopping_cart",
|
||
ConversionNumCost: "conversion_num_cost",
|
||
AdEffectivePlayNum: "ad_effective_play_num",
|
||
AdItemClick: "ad_item_click",
|
||
MerchantProductId: "merchant_product_id",
|
||
CostTotal: "cost_total",
|
||
AdShow: "ad_show",
|
||
AdShow1kCost: "ad_show1k_cost",
|
||
Impression: "impression",
|
||
PhotoClick: "photo_click",
|
||
PhotoClickRatio: "photo_click_ratio",
|
||
Click: "click",
|
||
ActionbarClick: "actionbar_click",
|
||
ActionbarClickCost: "actionbar_click_cost",
|
||
EspClickRatio: "esp_click_ratio",
|
||
ActionRatio: "action_ratio",
|
||
AdItemClickCount: "ad_item_click_count",
|
||
EspLivePlayedSeconds: "esp_live_played_seconds",
|
||
PlayedThreeSeconds: "played_three_seconds",
|
||
Play3sRatio: "play3s_ratio",
|
||
PlayedFiveSeconds: "played_five_seconds",
|
||
Play5sRatio: "play5s_ratio",
|
||
PlayedEnd: "played_end",
|
||
PlayEndRatio: "play_end_ratio",
|
||
Share: "share",
|
||
Comment: "comment",
|
||
Likes: "likes",
|
||
Report: "report",
|
||
Block: "block",
|
||
ItemNegative: "item_negative",
|
||
LiveShare: "live_share",
|
||
LiveComment: "live_comment",
|
||
LiveReward: "live_reward",
|
||
EffectivePlayCount: "effective_play_count",
|
||
EffectivePlayRatio: "effective_play_ratio",
|
||
ConversionNum: "conversion_num",
|
||
ConversionCostEsp: "conversion_cost_esp",
|
||
Roi: "roi",
|
||
Gmv: "gmv",
|
||
T0Gmv: "t0_gmv",
|
||
T1Gmv: "t1_gmv",
|
||
T7Gmv: "t7_gmv",
|
||
T15Gmv: "t15_gmv",
|
||
T30Gmv: "t30_gmv",
|
||
T0Roi: "t0_roi",
|
||
T1Roi: "t1_roi",
|
||
T7Roi: "t7_roi",
|
||
T15Roi: "t15_roi",
|
||
T30Roi: "t30_roi",
|
||
PaiedOrder: "paied_order",
|
||
OrderRatio: "order_ratio",
|
||
T0OrderCnt: "t0_order_cnt",
|
||
T0OrderCntCost: "t0_order_cnt_cost",
|
||
T0OrderCntRatio: "t0_order_cnt_ratio",
|
||
T1OrderCnt: "t1_order_cnt",
|
||
T7OrderCnt: "t7_order_cnt",
|
||
T15OrderCnt: "t15_order_cnt",
|
||
T30OrderCnt: "t30_order_cnt",
|
||
MerchantRecoFans: "merchant_reco_fans",
|
||
T1Retention: "t1_retention",
|
||
T7Retention: "t7_retention",
|
||
T15Retention: "t15_retention",
|
||
T30Retention: "t30_retention",
|
||
T1RetentionRatio: "t1_retention_ratio",
|
||
T7RetentionRatio: "t7_retention_ratio",
|
||
T15RetentionRatio: "t15_retention_ratio",
|
||
T30RetentionRatio: "t30_retention_ratio",
|
||
ReservationSuccess: "reservation_success",
|
||
ReservationCost: "reservation_cost",
|
||
StandardLivePlayedStarted: "standard_live_played_started",
|
||
AdLivePlayCnt: "ad_live_play_cnt",
|
||
AdLivePlayCntCost: "ad_live_play_cnt_cost",
|
||
LiveAudienceCost: "live_audience_cost",
|
||
LiveEventGoodsView: "live_event_goods_view",
|
||
GoodsClickRatio: "goods_click_ratio",
|
||
DirectAttrPlatNewBuyerCnt: "direct_attr_plat_new_buyer_cnt",
|
||
T30AttrPlatTotalBuyerCnt: "t30_attr_plat_total_buyer_cnt",
|
||
DirectAttrSellerNewBuyerCnt: "direct_attr_seller_new_buyer_cnt",
|
||
T30AttrSellerTotalBuyerCnt: "t30_attr_seller_total_buyer_cnt",
|
||
T3Gmv: "t3_gmv",
|
||
T3OrderCnt: "t3_order_cnt",
|
||
T3Roi: "t3_roi",
|
||
T7IndirectOrderAmt: "t7_indirect_order_amt",
|
||
T7IndirectOrderCnt: "t7_indirect_order_cnt",
|
||
FansT0GmvPerFans: "fans_t0_gmv_per_fans",
|
||
FansT3GmvPerFans: "fans_t3_gmv_per_fans",
|
||
FansT7GmvPerFans: "fans_t7_gmv_per_fans",
|
||
FansT15GmvPerFans: "fans_t15_gmv_per_fans",
|
||
FansT30GmvPerFans: "fans_t30_gmv_per_fans",
|
||
RecoFansCost: "reco_fans_cost",
|
||
QcpxWhiteboxDirectOrderPaymentAmt: "qcpx_whitebox_direct_order_payment_amt",
|
||
QcpxWhiteboxDirectOrderCnt: "qcpx_whitebox_direct_order_cnt",
|
||
FansT0Gmv: "fans_t0_gmv",
|
||
FansT1Gmv: "fans_t1_gmv",
|
||
FansT7Gmv: "fans_t7_gmv",
|
||
FansT15Gmv: "fans_t15_gmv",
|
||
FansT30Gmv: "fans_t30_gmv",
|
||
FansT0Roi: "fans_t0_roi",
|
||
FansT1Roi: "fans_t1_roi",
|
||
FansT7Roi: "fans_t7_roi",
|
||
FansT15Roi: "fans_t15_roi",
|
||
FansT30Roi: "fans_t30_roi",
|
||
T0ShopNewBuyerOrderPaymentAmt: "t0_shop_new_buyer_order_payment_amt",
|
||
T1ShopNewBuyerOrderPaymentAmt: "t1_shop_new_buyer_order_payment_amt",
|
||
T3ShopNewBuyerOrderPaymentAmt: "t3_shop_new_buyer_order_payment_amt",
|
||
T7ShopNewBuyerOrderPaymentAmt: "t7_shop_new_buyer_order_payment_amt",
|
||
T15ShopNewBuyerOrderPaymentAmt: "t15_shop_new_buyer_order_payment_amt",
|
||
T30ShopNewBuyerOrderPaymentAmt: "t30_shop_new_buyer_order_payment_amt",
|
||
T0ShopNewBuyerOrderCnt: "t0_shop_new_buyer_order_cnt",
|
||
T1ShopNewBuyerOrderCnt: "t1_shop_new_buyer_order_cnt",
|
||
T3ShopNewBuyerOrderCnt: "t3_shop_new_buyer_order_cnt",
|
||
T7ShopNewBuyerOrderCnt: "t7_shop_new_buyer_order_cnt",
|
||
T15ShopNewBuyerOrderCnt: "t15_shop_new_buyer_order_cnt",
|
||
T30ShopNewBuyerOrderCnt: "t30_shop_new_buyer_order_cnt",
|
||
T1NewBuyerRepurchaseRatio: "t1_new_buyer_repurchase_ratio",
|
||
T3NewBuyerRepurchaseRatio: "t3_new_buyer_repurchase_ratio",
|
||
T7NewBuyerRepurchaseRatio: "t7_new_buyer_repurchase_ratio",
|
||
T15NewBuyerRepurchaseRatio: "t15_new_buyer_repurchase_ratio",
|
||
T30NewBuyerRepurchaseRatio: "t30_new_buyer_repurchase_ratio",
|
||
T0ShopNewBuyerRoi: "t0_shop_new_buyer_roi",
|
||
T1ShopNewBuyerRoi: "t1_shop_new_buyer_roi",
|
||
T3ShopNewBuyerRoi: "t3_shop_new_buyer_roi",
|
||
T7ShopNewBuyerRoi: "t7_shop_new_buyer_roi",
|
||
T15ShopNewBuyerRoi: "t15_shop_new_buyer_roi",
|
||
T30ShopNewBuyerRoi: "t30_shop_new_buyer_roi",
|
||
CreateCardOrderCnt: "create_card_order_cnt",
|
||
ForwardTsCreateCardOrderCnt: "forward_ts_create_card_order_cnt",
|
||
CreateCardOrderCost: "create_card_order_cost",
|
||
ForwardTsCreateCardOrderCost: "forward_ts_create_card_order_cost",
|
||
ActivateCardOrderCnt: "activate_card_order_cnt",
|
||
ForwardTsActivateCardOrderCnt: "forward_ts_activate_card_order_cnt",
|
||
ActivateCardOrderCost: "activate_card_order_cost",
|
||
ForwardTsActivateCardOrderCost: "forward_ts_activate_card_order_cost",
|
||
CreateCardOrderRatio: "create_card_order_ratio",
|
||
ForwardTsCreateCardOrderRatio: "forward_ts_create_card_order_ratio",
|
||
ActivateCardOrderCntRatio: "activate_card_order_cnt_ratio",
|
||
ForwardTsActivateCardOrderRatio: "forward_ts_activate_card_order_ratio",
|
||
LivePlayCnt: "live_play_cnt",
|
||
ItemEntranceClkCnt: "item_entrance_clk_cnt",
|
||
ShowCnt: "show_cnt",
|
||
ReportDateStr: "report_date_str",
|
||
CampaignId: "campaign_id",
|
||
CampaignName: "campaign_name",
|
||
UnitId: "unit_id",
|
||
UnitName: "unit_name",
|
||
CreativeId: "creative_id",
|
||
CreativeName: "creative_name",
|
||
CidActualRoiAfterSubsidy: "cid_actual_roi_after_subsidy",
|
||
CidCouponAmount: "cid_coupon_amount",
|
||
CidCouponCallbackPaidRefundAmount: "cid_coupon_callback_paid_refund_amount",
|
||
CidVoucherCost: "cid_voucher_cost",
|
||
}
|
||
}
|