MDW Table Spec: fact_vendor_cost_adwords_geosplit

fact_vendor_cost_adwords_geosplit

Why is it important? Learn about the city, region, country, and metro terms.

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(1000)

clicks

Clicks

Amount(1000)

cost

Cost

Amount(1000)

conversions

Conversions

Amount(1000)

conversion_values

Total conv. value

Amount(1000)

cross_device_conversions

Cross-device conv.

Amount(1000)

view_through_conversions

View-through conv.

Amount(1000)

all_conversions

All conv.

Amount(1000)

all_conversion_value

All conv. value

Amount(1000)

account_descriptive_name

Account

String(1000)

external_customer_id

Customer ID

String(1000)

country_criteria_id

Country / Territory

Number

city_criteria_id

City

Amount(1000)

region_criteria_id

Region

Number

batch_id

Batch ID

String(1000)

metro_criteria_id

Metro area

Number

advertising_channel_type

Advertising Channel

Amount(1000)

advertising_channel_sub_type

Adv. Channel Sub Type

String(1000)

cost_converted

cost_converted

Amount(1000)

all_conversion_value_converted

all_conversion_value_converted

Amount(1000)

conversion_value_converted

conversion_value_converted

Amount(1000)


How did we do?


Powered by HelpDocs (opens in a new tab)