MDW Adwords Table Spec: fact_vendor_cost_adwords
fact_vendor_cost_adwords
Term | Definition | Datatype |
date | Date | Date |
Campaign ID | Campaign ID | String |
Campaign | Consist the campaign name | String |
Impressions | Total impressions on daily at campaign level | Amount |
Clicks | Total clicks on daily at campaign level | Amount |
Cost | Total cost on daily at campaign level | Amount |
Conversions | Conversions | Amount |
conversion_value | Total conv. value | Amount |
cross_device_conversions | Cross-device conv. | Amount |
view_through_conversions | View-through conv. | Amount |
All conv. | total conversions at campaign level | Amount |
all_conv_values | All conversion values | Amount |
Account | Account | String |
Customer ID | It contains the account ID details | String |
Advertising Channel | Contains the channel | String |
$(this.batchID) | Batch ID for logs | String |
Labels | Labels | String |
Content Impr. share | Content Impr. Share | Amount |
content_lost_is_budget | Content Lost IS (budget) | Amount |
content_lost_is_rank | Content Lost IS (rank) | Amount |
search_lost_abs_top_is_budget | Search lost abs. top IS (budget) | Amount |
search_lost_abs_top_is_budget | Search lost abs. top IS (budget) | Amount |
search_lost_top_is_budget | Search lost top IS (budget) | Amount |
search_lost_abs_top_is_rank | Search lost abs. top IS (rank) | Amount |
search_lost_is_rank | Search Lost IS (rank) | Amount |
search_los_top_is_rank | Search lost top IS (rank) | Amount |
search_impr_share | Search Impr. share | Amount |
Adv. Channel Subtype | Contains the channel subtype | String |
shared_campaign_budget | Shared campaign budget | String |
cost_converted | The converted cost | Amount |
all_conversion_value_converted | all_conversion_value_converted | Amount |
conversion_value_converted | conversion_value_converted | Amount |
