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)


How did we do?


Powered by HelpDocs (opens in a new tab)