MDW Adwords Table Spec: fact_vendor_cost_adwords_adgroup
fact_vendor_cost_adwords_adgroup
Why is it important? Adwords data pulled from the adwords api at the adset level.
Term | Definition | Datatype |
date | Date | Date |
campaign_id | Campaign ID | String(1000) |
campaign_name | Campaign | String(1000) |
ad_group_id | Ad group ID | String(1000) |
ad_group_name | Ad Group | String(1000) |
impressions | Impressions | Number |
clicks | Clicks | Number |
cost | Cost | Amount |
conversions | Conversions | Amount |
conversion_value | Total conv. value | Amount |
cross_device_conversions | Cross-device conv. | Amount |
view_through_conversions | View-through conv. | Number |
all_conversions | All conv. | Amount |
all_conversion_value | All conv. value | Amount |
ad_account_name | Account | String(1000) |
ad_account_id | Customer ID | String(1000) |
ad_group_type | Ad group type | String(1000) |
conversion_typ | Conversion type | String(1000) |
labels | Labels | String(1000) |
advertising_channel_type | Advertising Channel | String(1000) |
advertising_channel_sub_type | Adv. Channel Sub Type | String(1000) |
batch_id | Batch ID | String(300) |
