All Categories > Developer Docs > MDW Adwords Table Spec: fact_vendor_cost_adwords_campaign

MDW Adwords Table Spec: fact_vendor_cost_adwords_campaign

Why is it important? Adwords data pulled from adwords api at the campaign level.

Term	Definition	Datatype
date	date	Date
campaign_id	Campaign ID	String(1000)
campaign_name	Campaign	String(1000)
impressions	Impressions	String(1000)
clicks	Clicks	Number
cost	Cost	Number
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
account_descriptive_name	Account	String(1000)
external_customer_id	Customer ID	String(1000)
advertising_channel_type	Advertising Channel	String(1000)
batch_id	Batch ID	String(1000)
labels	Labels	String(1000)
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_is_budget	Search lost 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_lost_top_is_rank	Search lost top IS (rank)	Amount
search_impr_share	Search Impr. share	Amount
advertising_channel_sub_type	Adv. Channel Sub Type	String(1000)
cost_converted	cost_converted	Amount
all_conversion_value_converted	all_conversion_value_converted	Amount
conversion_value_converted	conversion_value_converted	String(1000)
shared_campaign_budget	Shared Campaign Budget	String(100)