MDW Adwords Table Spec: fact_vendor_cost_adwords_conversion_type
fact_vendor_cost_adwords_conversion_type
Why is it important? Adwords data pulled from adwords api at adset level with conversion type information.
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 | Amount |
clicks | Clicks | Amount |
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. | Amount |
all_conversions | All conv. | Amount |
all_conversion_value | All conv. value | Amount |
batch_id | Batch ID | String(1000) |
ad_account_name | Account | String(1000) |
ad_account_id | Customer ID | String(1000) |
channel_type | AdvertisingChannelType | String(1000) |
conversions_type | Conversion name | String(1000) |
labels | Labels | String(1000) |
advertising_channel_type | Advertising Channel | String(1000) |
advertising_channel_sub_type | Adv. Channel Sub Type | String(1000) |