MDW Table Spec: fact_vendor_cost_adwords_geosplit_conversion_type

fact_vendor_cost_adwords_geosplit_conversion_type

Why is it important? Learn about the spend details from the Combining the geosplit table with the geosplit conversions table, we are able to acquire spend data from the fact_vendor_cost_adwords_geosplit.

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)

conversion_type

Conversion name

String(1000)

conversions

Conversions

String(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

Number

region_criteria_id

Region

Number

batch_id

Batch ID

String(1000)

metro_criteria_id

Metro area

Number

advertising_channel_type

Advertising Channel

String(1000)

advertising_channel_sub_type

Adv. Channel Sub Type

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