MDW Bing Table Spec: fact_vendor_cost_bing
fact_vendor_cost_bing
Why is it important? The table holds the vendor reported feed from bing.
Term | Definition | Datatype |
date | TimePeriod | Date |
account_name | AccountName | String(1000) |
campaign_name | CampaignName | String(1000) |
ad_distribution | AdDistribution | String(1000) |
quality_score | QualityScore | Number |
impressions | Impressions | Number |
clicks | Clicks | Number |
ctr | Ctr | Amount |
avg_cpc | AverageCpc | Amount |
spend | Spend | Amount |
avg_position | AveragePosition | Amount |
conversions | Conversions | Number |
conversion_rate | ConversionRate | Amount |
cpa | CostPerAssist | Amount |
revenue | Revenue | Amount |
campaign_status | CampaignStatus | String(1000) |
campaign_id | CampaignID | String(1000) |
campaign_labels | CampaignLabels | String(1000) |
campaign_type | CampaignType | String(1000) |
batch_id | ${this.batchID} | String(1000) |
