54 lines
1.9 KiB
Go
54 lines
1.9 KiB
Go
package report
|
||
|
||
import (
|
||
"github.com/gogf/gf/v2/os/gtime"
|
||
|
||
"gitea.redpowerfuture.com/red-future/common/beans"
|
||
)
|
||
|
||
// DailyReport 日报表实体（统一消耗/效果汇总：外投拉平台报表，DSP聚合auction_log）
|
||
type DailyReport struct {
|
||
beans.SQLBaseDO `orm:",inherit"`
|
||
// 业务字段
|
||
ReportDate *gtime.Time `orm:"report_date" json:"reportDate" description:"报表日期"`
|
||
Channel string `orm:"channel" json:"channel" description:"投放通道 external外投/self_dsp自有"`
|
||
AdAccountID int64 `orm:"ad_account_id" json:"adAccountId" description:"广告账户ID"`
|
||
CampaignID int64 `orm:"campaign_id" json:"campaignId" description:"本地计划ID"`
|
||
Platform string `orm:"platform" json:"platform" description:"广告平台 douyin/xiaohongshu/kuaishou"`
|
||
Impressions int64 `orm:"impressions" json:"impressions" description:"展示数"`
|
||
Clicks int64 `orm:"clicks" json:"clicks" description:"点击数"`
|
||
Cost int64 `orm:"cost" json:"cost" description:"消耗(分)"`
|
||
Conversions int64 `orm:"conversions" json:"conversions" description:"转化数"`
|
||
Extra string `orm:"extra" json:"extra" description:"平台报表原始快照(JSON)，对账用"`
|
||
}
|
||
|
||
// DailyReportCol 日报表字段定义
|
||
type DailyReportCol struct {
|
||
beans.SQLBaseCol
|
||
ReportDate string
|
||
Channel string
|
||
AdAccountID string
|
||
CampaignID string
|
||
Platform string
|
||
Impressions string
|
||
Clicks string
|
||
Cost string
|
||
Conversions string
|
||
Extra string
|
||
}
|
||
|
||
// DailyReportCols 日报表字段常量
|
||
var DailyReportCols = DailyReportCol{
|
||
SQLBaseCol: beans.DefSQLBaseCol,
|
||
ReportDate: "report_date",
|
||
Channel: "channel",
|
||
AdAccountID: "ad_account_id",
|
||
CampaignID: "campaign_id",
|
||
Platform: "platform",
|
||
Impressions: "impressions",
|
||
Clicks: "clicks",
|
||
Cost: "cost",
|
||
Conversions: "conversions",
|
||
Extra: "extra",
|
||
}
|