Skip to main content
Skip table of contents

Column Migration Guide

This document is currently in progress

Overview

Rebuild your legacy queries from utilizing ADL 1.0 to 2.0 with this column-level migration guide. The following sections contain tables that map columns found in an ADL 1.0 report (e.g., search_ad) to its equivalent in an ADL 2.0 report (e.g., ad_performance, googleads__ad_performance, etc.).

These tables only include columns that were either renamed or deprecated in ADL 2.0 (denoted by n/a). Columns that are named the same between ADL 1.0 to 2.0 are NOT included in this guide.


search_ad → ad_performance*

Click to expand table

*Columns may be applicable to aggregated versions of report (search_adgroup, search_campaign, search_account)

ADL 1 Table

ADL 1 Column

ADL 2 Table

ADL 2 Column

search_ad

absolute_top_impression_percentage

ad_performance

n/a

search_ad

active_view_impressions

ad_performance

n/a

search_ad

active_view_measurability

ad_performance

n/a

search_ad

active_view_measurable_cost

ad_performance

n/a

search_ad

active_view_measurable_impressions

ad_performance

n/a

search_ad

active_view_viewability

ad_performance

n/a

search_ad

ad_network_sub_type

ad_performance

n/a

search_ad

ad_network_type

ad_performance

publisher_platform

search_ad

ad_resource_name

ad_performance

n/a

search_ad

ad_strength

ad_performance

n/a

search_ad

adgroup_resource_name

ad_performance

n/a

search_ad

app_ad_description1

ad_performance

n/a

search_ad

app_ad_headline1

ad_performance

n/a

search_ad

app_ad_html5_media_bundles

ad_performance

n/a

search_ad

app_ad_images

ad_performance

n/a

search_ad

app_ad_mandatory_ad_text

ad_performance

n/a

search_ad

assists

ad_performance

n/a

search_ad

automated

ad_performance

n/a

search_ad

average_position

ad_performance

n/a

search_ad

business_name

ad_performance

n/a

search_ad

campaign_resource_name

ad_performance

n/a

search_ad

cross_device_conversions

ad_performance

n/a

search_ad

currency

ad_performance

n/a

search_ad

currency_code

ad_performance

n/a

search_ad

current_model_attributed_conversions

ad_performance

n/a

search_ad

current_model_attributed_revenue

ad_performance

n/a

search_ad

customer_resource_name

ad_performance

n/a

search_ad

destination_url

ad_performance

n/a

search_ad

device

ad_performance

n/a

search_ad

device_preference

ad_performance

n/a

search_ad

display_url

ad_performance

n/a

search_ad

engagements

ad_performance

n/a

search_ad

expanded_dynamic_search_ad_description1

ad_performance

n/a

search_ad

expanded_dynamic_search_ad_description2

ad_performance

n/a

search_ad

expanded_dynamic_search_ad_headline1

ad_performance

n/a

search_ad

expanded_dynamic_search_ad_path1

ad_performance

n/a

search_ad

expanded_dynamic_search_ad_path2

ad_performance

n/a

search_ad

expanded_text_ad_description1

ad_performance

n/a

search_ad

expanded_text_ad_description2

ad_performance

n/a

search_ad

expanded_text_ad_headline1

ad_performance

n/a

search_ad

expanded_text_ad_headline2

ad_performance

n/a

search_ad

expanded_text_ad_headline3

ad_performance

n/a

search_ad

expanded_text_ad_path1

ad_performance

n/a

search_ad

expanded_text_ad_path2

ad_performance

n/a

search_ad

final_app_url

ad_performance

n/a

search_ad

final_mobile_url

ad_performance

n/a

search_ad

final_url

ad_performance

n/a

search_ad

final_url_suffix

ad_performance

n/a

search_ad

gmail_forwards

ad_performance

n/a

search_ad

gmail_saves

ad_performance

n/a

search_ad

gmail_secondary_clicks

ad_performance

n/a

search_ad

interaction_types

ad_performance

n/a

search_ad

interactions

ad_performance

n/a

search_ad

is_managed

ad_performance

n/a

search_ad

label_ids

ad_performance

n/a

search_ad

labels

ad_performance

n/a

search_ad

language

ad_performance

n/a

search_ad

policy_summary_approval_status

ad_performance

n/a

search_ad

policy_summary_review_status

ad_performance

n/a

search_ad

responsive_search_ad_description1

ad_performance

n/a

search_ad

responsive_search_ad_headline1

ad_performance

n/a

search_ad

responsive_search_ad_path1

ad_performance

n/a

search_ad

responsive_search_ad_path2

ad_performance

n/a

search_ad

revenue

ad_performance

conversions_value

search_ad

sub_channel

ad_performance

n/a

search_ad

text_ad_description1

ad_performance

n/a

search_ad

text_ad_description2

ad_performance

n/a

search_ad

text_ad_headline1

ad_performance

n/a

search_ad

time_zone

ad_performance

n/a

search_ad

top_impression_percentage

ad_performance

n/a

search_ad

total_revenue

ad_performance

total_conversions_value

search_ad

tracking_url_template

ad_performance

n/a

search_ad

url_collections

ad_performance

n/a

search_ad

url_custom_parameters

ad_performance

n/a

search_ad

video_quartile_p25_rate

ad_performance

video_p25_watched

search_ad

video_quartile_p50_rate

ad_performance

video_p50_watched

search_ad

video_quartile_p75_rate

ad_performance

video_p75_watched

search_ad

video_quartile_p100_rate

ad_performance

video_p100_watched

search_ad

ad_network_sub_type

googleads__ad_performance

n/a

search_ad

assists

googleads__ad_performance

n/a

search_ad

audience_strategy

googleads__ad_performance

n/a

search_ad

average_position

googleads__ad_performance

n/a

search_ad

business_name

googleads__ad_performance

n/a

search_ad

channel

googleads__ad_performance

n/a

search_ad

currency

googleads__ad_performance

currency_code

search_ad

current_model_attributed_revenue

googleads__ad_performance

current_model_attributed_conversions_value

search_ad

destination_url

googleads__ad_performance

n/a

search_ad

expanded_dynamic_search_ad_headline1

googleads__ad_performance

n/a

search_ad

expanded_dynamic_search_ad_path1

googleads__ad_performance

n/a

search_ad

expanded_dynamic_search_ad_path2

googleads__ad_performance

n/a

search_ad

geo

googleads__ad_performance

n/a

search_ad

is_managed

googleads__ad_performance

n/a

search_ad

language

googleads__ad_performance

n/a

search_ad

platform

googleads__ad_performance

n/a

search_ad

publisher_platform

googleads__ad_performance

ad_network_type

search_ad

query_type

googleads__ad_performance

n/a

search_ad

revenue

googleads__ad_performance

conversions_value

search_ad

total_revenue

googleads__ad_performance

total_conversions_value

search_ad

absolute_top_impression_percentage

microsoftads__ad_performance

n/a

search_ad

active_view_impressions

microsoftads__ad_performance

n/a

search_ad

active_view_measurability

microsoftads__ad_performance

n/a

search_ad

active_view_measurable_cost

microsoftads__ad_performance

n/a

search_ad

active_view_measurable_impressions

microsoftads__ad_performance

n/a

search_ad

active_view_viewability

microsoftads__ad_performance

n/a

search_ad

ad_resource_name

microsoftads__ad_performance

n/a

search_ad

ad_status

microsoftads__ad_performance

n/a

search_ad

ad_strength

microsoftads__ad_performance

n/a

search_ad

adgroup_resource_name

microsoftads__ad_performance

n/a

search_ad

adgroup_type

microsoftads__ad_performance

n/a

search_ad

app_ad_description1

microsoftads__ad_performance

n/a

search_ad

app_ad_headline1

microsoftads__ad_performance

n/a

search_ad

app_ad_html5_media_bundles

microsoftads__ad_performance

n/a

search_ad

app_ad_images

microsoftads__ad_performance

n/a

search_ad

app_ad_mandatory_ad_text

microsoftads__ad_performance

n/a

search_ad

audience_strategy

microsoftads__ad_performance

n/a

search_ad

automated

microsoftads__ad_performance

n/a

search_ad

campaign_end_date

microsoftads__ad_performance

n/a

search_ad

campaign_resource_name

microsoftads__ad_performance

n/a

search_ad

campaign_start_date

microsoftads__ad_performance

n/a

search_ad

channel

microsoftads__ad_performance

n/a

search_ad

cross_device_conversions

microsoftads__ad_performance

n/a

search_ad

currency_code

microsoftads__ad_performance

currency

search_ad

current_model_attributed_conversions

microsoftads__ad_performance

n/a

search_ad

current_model_attributed_revenue

microsoftads__ad_performance

n/a

search_ad

customer_resource_name

microsoftads__ad_performance

n/a

search_ad

device_preference

microsoftads__ad_performance

n/a

search_ad

engagements

microsoftads__ad_performance

n/a

search_ad

final_url_suffix

microsoftads__ad_performance

n/a

search_ad

geo

microsoftads__ad_performance

n/a

search_ad

gmail_forwards

microsoftads__ad_performance

n/a

search_ad

gmail_saves

microsoftads__ad_performance

n/a

search_ad

gmail_secondary_clicks

microsoftads__ad_performance

n/a

search_ad

interaction_types

microsoftads__ad_performance

n/a

search_ad

interactions

microsoftads__ad_performance

n/a

search_ad

is_managed

microsoftads__ad_performance

n/a

search_ad

label_ids

microsoftads__ad_performance

n/a

search_ad

platform

microsoftads__ad_performance

n/a

search_ad

policy_summary_approval_status

microsoftads__ad_performance

n/a

search_ad

policy_summary_review_status

microsoftads__ad_performance

n/a

search_ad

publisher_platform

microsoftads__ad_performance

ad_network_type

search_ad

query_type

microsoftads__ad_performance

n/a

search_ad

responsive_search_ad_description1

microsoftads__ad_performance

n/a

search_ad

responsive_search_ad_headline1

microsoftads__ad_performance

n/a

search_ad

sub_channel

microsoftads__ad_performance

n/a

search_ad

text_ad_description1

microsoftads__ad_performance

n/a

search_ad

text_ad_description2

microsoftads__ad_performance

n/a

search_ad

text_ad_headline1

microsoftads__ad_performance

n/a

search_ad

time_zone

microsoftads__ad_performance

n/a

search_ad

top_impression_percentage

microsoftads__ad_performance

n/a

search_ad

url_collections

microsoftads__ad_performance

n/a

search_ad

video_p25_watched

microsoftads__ad_performance

n/a

search_ad

video_p50_watched

microsoftads__ad_performance

n/a

search_ad

video_p75_watched

microsoftads__ad_performance

n/a

search_ad

video_p100_watched

microsoftads__ad_performance

n/a

search_ad

video_quartile_p25_rate

microsoftads__ad_performance

n/a

search_ad

video_quartile_p50_rate

microsoftads__ad_performance

n/a

search_ad

video_quartile_p75_rate

microsoftads__ad_performance

n/a

search_ad

video_quartile_p100_rate

microsoftads__ad_performance

n/a

search_ad

video_views

microsoftads__ad_performance

n/a

search_ad

view_through_conversions

microsoftads__ad_performance

n/a


search_keyword → keyword_performance

In progress

Click to expand table


Display

display_ad → ad_performance*

Click to expand table

*Columns may be applicable to aggregated versions of report, e.g., display_adgroup → adgroup_performance | display_campaign → campaign_performance | display_account → account_performance

ADL 1 Table

ADL 1 Column

ADL 2 Table

ADL 2 Column

display_ad

billable_dsp_cost

ad_performance

n/a

display_ad

bounces

ad_performance

n/a

display_ad

browser

ad_performance

n/a

display_ad

click_through_revenue

ad_performance

click_through_conversions_value

display_ad

cpc_bid

ad_performance

n/a

display_ad

creative_id

ad_performance

ad_id

display_ad

creative_name

ad_performance

ad_name

display_ad

creative_size

ad_performance

n/a

display_ad

creative_url

ad_performance

n/a

display_ad

deal_type

ad_performance

n/a

display_ad

device

ad_performance

n/a

display_ad

engagement_score

ad_performance

n/a

display_ad

environment

ad_performance

n/a

display_ad

gmail_forwards

ad_performance

n/a

display_ad

gmail_saves

ad_performance

n/a

display_ad

gmail_secondary_clicks

ad_performance

n/a

display_ad

goal_type

ad_performance

n/a

display_ad

image_url

ad_performance

n/a

display_ad

insertion_order_id

ad_performance

campaign_id

display_ad

insertion_order_name

ad_performance

campaign_name

display_ad

is_managed

ad_performance

n/a

display_ad

long_text

ad_performance

n/a

display_ad

media_cost

ad_performance

n/a

display_ad

media_fee1

ad_performance

n/a

display_ad

media_fee2

ad_performance

n/a

display_ad

media_fee3

ad_performance

n/a

display_ad

media_fee4

ad_performance

n/a

display_ad

media_fee5

ad_performance

n/a

display_ad

page_view

ad_performance

n/a

display_ad

profit

ad_performance

n/a

display_ad

sessions

ad_performance

n/a

display_ad

short_text

ad_performance

n/a

display_ad

thumbnail_url

ad_performance

n/a

display_ad

time_on_site

ad_performance

n/a

display_ad

total_revenue

ad_performance

total_conversions_value

display_ad

view_through_revenue

ad_performance

view_through_conversions_value

display_ad

account_id

amazondsp__ad_performance

advertiser_id

display_ad

account_name

amazondsp__ad_performance

advertiser_name

display_ad

ad_format

amazondsp__ad_performance

creative_type

display_ad

adgroup_id

amazondsp__ad_performance

line_item_id

display_ad

adgroup_name

amazondsp__ad_performance

line_item_name

display_ad

audience_strategy

amazondsp__ad_performance

n/a

display_ad

audience_type

amazondsp__ad_performance

n/a

display_ad

billable_dsp_cost

amazondsp__ad_performance

n/a

display_ad

bounces

amazondsp__ad_performance

n/a

display_ad

browser

amazondsp__ad_performance

n/a

display_ad

campaign_end_date

amazondsp__ad_performance

n/a

display_ad

campaign_id

amazondsp__ad_performance

insertion_order_id

display_ad

campaign_name

amazondsp__ad_performance

insertion_order_name

display_ad

campaign_start_date

amazondsp__ad_performance

n/a

display_ad

channel

amazondsp__ad_performance

n/a

display_ad

click_through_conversions

amazondsp__ad_performance

n/a

display_ad

click_through_revenue

amazondsp__ad_performance

n/a

display_ad

clicks

amazondsp__ad_performance

click_throughs

display_ad

cost

amazondsp__ad_performance

total_cost

display_ad

cpc_bid

amazondsp__ad_performance

n/a

display_ad

creative_id

amazondsp__ad_performance

creative_ad_id

display_ad

creative_url

amazondsp__ad_performance

n/a

display_ad

deal_type

amazondsp__ad_performance

n/a

display_ad

device

amazondsp__ad_performance

n/a

display_ad

engagement_score

amazondsp__ad_performance

n/a

display_ad

environment

amazondsp__ad_performance

n/a

display_ad

geo

amazondsp__ad_performance

n/a

display_ad

gmail_forwards

amazondsp__ad_performance

n/a

display_ad

gmail_saves

amazondsp__ad_performance

n/a

display_ad

gmail_secondary_clicks

amazondsp__ad_performance

n/a

display_ad

goal_type

amazondsp__ad_performance

n/a

display_ad

image_url

amazondsp__ad_performance

n/a

display_ad

is_managed

amazondsp__ad_performance

n/a

display_ad

long_text

amazondsp__ad_performance

n/a

display_ad

marketing_objective

amazondsp__ad_performance

n/a

display_ad

media_cost

amazondsp__ad_performance

n/a

display_ad

media_fee1

amazondsp__ad_performance

n/a

display_ad

media_fee2

amazondsp__ad_performance

n/a

display_ad

media_fee3

amazondsp__ad_performance

n/a

display_ad

media_fee4

amazondsp__ad_performance

n/a

display_ad

media_fee5

amazondsp__ad_performance

n/a

display_ad

page_view

amazondsp__ad_performance

n/a

display_ad

platform

amazondsp__ad_performance

n/a

display_ad

profit

amazondsp__ad_performance

n/a

display_ad

publisher_platform

amazondsp__ad_performance

n/a

display_ad

sessions

amazondsp__ad_performance

n/a

display_ad

short_text

amazondsp__ad_performance

n/a

display_ad

thumbnail_url

amazondsp__ad_performance

n/a

display_ad

time_on_site

amazondsp__ad_performance

n/a

display_ad

total_conversions

amazondsp__ad_performance

n/a

display_ad

total_revenue

amazondsp__ad_performance

n/a

display_ad

video_p25_watched

amazondsp__ad_performance

n/a

display_ad

video_p50_watched

amazondsp__ad_performance

n/a

display_ad

video_p75_watched

amazondsp__ad_performance

n/a

display_ad

video_p100_watched

amazondsp__ad_performance

n/a

display_ad

video_views

amazondsp__ad_performance

n/a

display_ad

view_through_conversions

amazondsp__ad_performance

n/a

display_ad

view_through_revenue

amazondsp__ad_performance

n/a

display_ad

ad_format

bidtellect__ad_performance

n/a

display_ad

audience_strategy

bidtellect__ad_performance

n/a

display_ad

audience_type

bidtellect__ad_performance

n/a

display_ad

billable_dsp_cost

bidtellect__ad_performance

cost

display_ad

browser

bidtellect__ad_performance

n/a

display_ad

channel

bidtellect__ad_performance

n/a

display_ad

click_through_revenue

bidtellect__ad_performance

n/a

display_ad

cost

bidtellect__ad_performance

spend

display_ad

cpc_bid

bidtellect__ad_performance

n/a

display_ad

deal_type

bidtellect__ad_performance

n/a

display_ad

device

bidtellect__ad_performance

device_type

display_ad

environment

bidtellect__ad_performance

n/a

display_ad

geo

bidtellect__ad_performance

n/a

display_ad

gmail_forwards

bidtellect__ad_performance

n/a

display_ad

gmail_saves

bidtellect__ad_performance

n/a

display_ad

gmail_secondary_clicks

bidtellect__ad_performance

n/a

display_ad

goal_type

bidtellect__ad_performance

n/a

display_ad

image_url

bidtellect__ad_performance

thumbnail_url

display_ad

is_managed

bidtellect__ad_performance

n/a

display_ad

marketing_objective

bidtellect__ad_performance

n/a

display_ad

media_cost

bidtellect__ad_performance

n/a

display_ad

media_fee1

bidtellect__ad_performance

n/a

display_ad

media_fee2

bidtellect__ad_performance

n/a

display_ad

media_fee3

bidtellect__ad_performance

n/a

display_ad

media_fee4

bidtellect__ad_performance

n/a

display_ad

media_fee5

bidtellect__ad_performance

n/a

display_ad

page_view

bidtellect__ad_performance

page_views

display_ad

platform

bidtellect__ad_performance

n/a

display_ad

profit

bidtellect__ad_performance

agency_fee

display_ad

publisher_platform

bidtellect__ad_performance

n/a

display_ad

total_revenue

bidtellect__ad_performance

n/a

display_ad

video_p25_watched

bidtellect__ad_performance

video_first_quartiles

display_ad

video_p50_watched

bidtellect__ad_performance

video_mid_points

display_ad

video_p75_watched

bidtellect__ad_performance

video_third_quartiles

display_ad

video_p100_watched

bidtellect__ad_performance

video_completes

display_ad

video_views

bidtellect__ad_performance

video_starts

display_ad

view_through_revenue

bidtellect__ad_performance

n/a

display_ad

account_id

dv360__ad_performance

advertiser_id

display_ad

account_name

dv360__ad_performance

advertiser_name

display_ad

ad_format

dv360__ad_performance

creative_type

display_ad

adgroup_id

dv360__ad_performance

line_item_id

display_ad

adgroup_name

dv360__ad_performance

line_item_name

display_ad

audience_strategy

dv360__ad_performance

n/a

display_ad

audience_type

dv360__ad_performance

n/a

display_ad

billable_dsp_cost

dv360__ad_performance

total_media_cost

display_ad

bounces

dv360__ad_performance

n/a

display_ad

campaign_end_date

dv360__ad_performance

n/a

display_ad

campaign_id

dv360__ad_performance

insertion_order_id

display_ad

campaign_name

dv360__ad_performance

insertion_order_name

display_ad

campaign_start_date

dv360__ad_performance

n/a

display_ad

channel

dv360__ad_performance

n/a

display_ad

click_through_conversions

dv360__ad_performance

last_clicks

display_ad

click_through_revenue

dv360__ad_performance

cm_post_click_revenue

display_ad

cost

dv360__ad_performance

revenue

display_ad

cpc_bid

dv360__ad_performance

n/a

display_ad

creative_url

dv360__ad_performance

n/a

display_ad

deal_type

dv360__ad_performance

inventory_commitment_type

display_ad

device

dv360__ad_performance

device_type

display_ad

engagement_score

dv360__ad_performance

n/a

display_ad

environment

dv360__ad_performance

page_layout

display_ad

geo

dv360__ad_performance

n/a

display_ad

gmail_forwards

dv360__ad_performance

n/a

display_ad

gmail_saves

dv360__ad_performance

n/a

display_ad

gmail_secondary_clicks

dv360__ad_performance

n/a

display_ad

goal_type

dv360__ad_performance

n/a

display_ad

image_url

dv360__ad_performance

n/a

display_ad

is_managed

dv360__ad_performance

n/a

display_ad

long_text

dv360__ad_performance

n/a

display_ad

marketing_objective

dv360__ad_performance

n/a

display_ad

page_view

dv360__ad_performance

n/a

display_ad

platform

dv360__ad_performance

n/a

display_ad

sessions

dv360__ad_performance

n/a

display_ad

short_text

dv360__ad_performance

n/a

display_ad

thumbnail_url

dv360__ad_performance

n/a

display_ad

time_on_site

dv360__ad_performance

n/a

display_ad

total_conversions

dv360__ad_performance

n/a

display_ad

total_revenue

dv360__ad_performance

n/a

display_ad

video_p25_watched

dv360__ad_performance

video_first_quartile_completes

display_ad

video_p50_watched

dv360__ad_performance

video_midpoints

display_ad

video_p75_watched

dv360__ad_performance

video_third_quartile_completes

display_ad

video_p100_watched

dv360__ad_performance

video_completions

display_ad

video_views

dv360__ad_performance

trueview_views

display_ad

view_through_conversions

dv360__ad_performance

last_impressions

display_ad

view_through_revenue

dv360__ad_performance

cm_post_view_revenue

display_ad

ad_format

googleads__ad_performance

ad_type

display_ad

audience_strategy

googleads__ad_performance

n/a

display_ad

audience_type

googleads__ad_performance

n/a

display_ad

billable_dsp_cost

googleads__ad_performance

n/a

display_ad

bounces

googleads__ad_performance

n/a

display_ad

browser

googleads__ad_performance

n/a

display_ad

channel

googleads__ad_performance

n/a

display_ad

click_through_conversions

googleads__ad_performance

conversions

display_ad

click_through_revenue

googleads__ad_performance

click_through_conversions_value

display_ad

cpc_bid

googleads__ad_performance

n/a

display_ad

creative_id

googleads__ad_performance

ad_id

display_ad

creative_name

googleads__ad_performance

ad_name

display_ad

creative_size

googleads__ad_performance

n/a

display_ad

creative_url

googleads__ad_performance

final_url

display_ad

deal_type

googleads__ad_performance

n/a

display_ad

engagement_score

googleads__ad_performance

n/a

display_ad

environment

googleads__ad_performance

n/a

display_ad

geo

googleads__ad_performance

n/a

display_ad

goal_type

googleads__ad_performance

n/a

display_ad

image_url

googleads__ad_performance

n/a

display_ad

insertion_order_id

googleads__ad_performance

campaign_id

display_ad

insertion_order_name

googleads__ad_performance

campaign_name

display_ad

is_managed

googleads__ad_performance

n/a

display_ad

line_item_id

googleads__ad_performance

adgroup_id

display_ad

line_item_name

googleads__ad_performance

adgroup_name

display_ad

long_text

googleads__ad_performance

n/a

display_ad

marketing_objective

googleads__ad_performance

n/a

display_ad

media_cost

googleads__ad_performance

n/a

display_ad

media_fee1

googleads__ad_performance

n/a

display_ad

media_fee2

googleads__ad_performance

n/a

display_ad

media_fee3

googleads__ad_performance

n/a

display_ad

media_fee4

googleads__ad_performance

n/a

display_ad

media_fee5

googleads__ad_performance

n/a

display_ad

page_view

googleads__ad_performance

n/a

display_ad

platform

googleads__ad_performance

n/a

display_ad

profit

googleads__ad_performance

n/a

display_ad

publisher_platform

googleads__ad_performance

ad_network_type

display_ad

sessions

googleads__ad_performance

n/a

display_ad

short_text

googleads__ad_performance

n/a

display_ad

thumbnail_url

googleads__ad_performance

n/a

display_ad

time_on_site

googleads__ad_performance

n/a

display_ad

total_revenue

googleads__ad_performance

total_conversions_value

display_ad

view_through_revenue

googleads__ad_performance

view_through_conversions_value

display_ad

account_id

tradedesk__ad_performance

advertiser_id

display_ad

account_name

tradedesk__ad_performance

advertiser_name

display_ad

audience_strategy

tradedesk__ad_performance

n/a

display_ad

audience_type

tradedesk__ad_performance

n/a

display_ad

billable_dsp_cost

tradedesk__ad_performance

partner_cost

display_ad

bounces

tradedesk__ad_performance

n/a

display_ad

campaign_end_date

tradedesk__ad_performance

n/a

display_ad

campaign_start_date

tradedesk__ad_performance

n/a

display_ad

channel

tradedesk__ad_performance

n/a

display_ad

cm_placement_id

tradedesk__ad_performance

ad_server_creative_placement_id

display_ad

cost

tradedesk__ad_performance

advertiser_cost

display_ad

cpc_bid

tradedesk__ad_performance

n/a

display_ad

creative_size

tradedesk__ad_performance

ad_format

display_ad

creative_url

tradedesk__ad_performance

n/a

display_ad

deal_type

tradedesk__ad_performance

n/a

display_ad

device

tradedesk__ad_performance

device_type

display_ad

engagement_score

tradedesk__ad_performance

n/a

display_ad

geo

tradedesk__ad_performance

n/a

display_ad

gmail_forwards

tradedesk__ad_performance

n/a

display_ad

gmail_saves

tradedesk__ad_performance

n/a

display_ad

gmail_secondary_clicks

tradedesk__ad_performance

n/a

display_ad

goal_type

tradedesk__ad_performance

n/a

display_ad

image_url

tradedesk__ad_performance

n/a

display_ad

insertion_order_id

tradedesk__ad_performance

campaign_id

display_ad

insertion_order_name

tradedesk__ad_performance

campaign_name

display_ad

is_managed

tradedesk__ad_performance

n/a

display_ad

line_item_id

tradedesk__ad_performance

adgroup_id

display_ad

line_item_name

tradedesk__ad_performance

adgroup_name

display_ad

long_text

tradedesk__ad_performance

n/a

display_ad

marketing_objective

tradedesk__ad_performance

n/a

display_ad

media_cost

tradedesk__ad_performance

n/a

display_ad

media_fee1

tradedesk__ad_performance

n/a

display_ad

media_fee2

tradedesk__ad_performance

n/a

display_ad

media_fee3

tradedesk__ad_performance

n/a

display_ad

media_fee4

tradedesk__ad_performance

n/a

display_ad

media_fee5

tradedesk__ad_performance

n/a

display_ad

page_view

tradedesk__ad_performance

n/a

display_ad

platform

tradedesk__ad_performance

n/a

display_ad

publisher_platform

tradedesk__ad_performance

n/a

display_ad

sessions

tradedesk__ad_performance

n/a

display_ad

short_text

tradedesk__ad_performance

n/a

display_ad

thumbnail_url

tradedesk__ad_performance

n/a

display_ad

time_on_site

tradedesk__ad_performance

n/a

display_ad

video_p25_watched

tradedesk__ad_performance

n/a

display_ad

video_p50_watched

tradedesk__ad_performance

n/a

display_ad

video_p75_watched

tradedesk__ad_performance

n/a

display_ad

video_p100_watched

tradedesk__ad_performance

n/a

display_ad

video_views

tradedesk__ad_performance

n/a

display_ad

account_id

yahoodsp__ad_performance

advertiser_id

display_ad

account_name

yahoodsp__ad_performance

advertiser_name

display_ad

ad_format

yahoodsp__ad_performance

n/a

display_ad

adgroup_id

yahoodsp__ad_performance

line_item_id

display_ad

adgroup_name

yahoodsp__ad_performance

line_item_name

display_ad

audience_strategy

yahoodsp__ad_performance

n/a

display_ad

audience_type

yahoodsp__ad_performance

n/a

display_ad

bounces

yahoodsp__ad_performance

n/a

display_ad

browser

yahoodsp__ad_performance

browser_type

display_ad

campaign_end_date

yahoodsp__ad_performance

n/a

display_ad

campaign_start_date

yahoodsp__ad_performance

n/a

display_ad

channel

yahoodsp__ad_performance

n/a

display_ad

click_through_revenue

yahoodsp__ad_performance

click_through_conversions_value

display_ad

cpc_bid

yahoodsp__ad_performance

n/a

display_ad

creative_url

yahoodsp__ad_performance

n/a

display_ad

deal_type

yahoodsp__ad_performance

n/a

display_ad

device

yahoodsp__ad_performance

device_type

display_ad

engagement_score

yahoodsp__ad_performance

n/a

display_ad

environment

yahoodsp__ad_performance

inventory_type

display_ad

geo

yahoodsp__ad_performance

n/a

display_ad

gmail_forwards

yahoodsp__ad_performance

n/a

display_ad

gmail_saves

yahoodsp__ad_performance

n/a

display_ad

gmail_secondary_clicks

yahoodsp__ad_performance

n/a

display_ad

goal_type

yahoodsp__ad_performance

n/a

display_ad

image_url

yahoodsp__ad_performance

n/a

display_ad

insertion_order_id

yahoodsp__ad_performance

campaign_id

display_ad

insertion_order_name

yahoodsp__ad_performance

campaign_name

display_ad

is_managed

yahoodsp__ad_performance

n/a

display_ad

long_text

yahoodsp__ad_performance

n/a

display_ad

marketing_objective

yahoodsp__ad_performance

n/a

display_ad

media_cost

yahoodsp__ad_performance

n/a

display_ad

media_fee1

yahoodsp__ad_performance

n/a

display_ad

media_fee2

yahoodsp__ad_performance

n/a

display_ad

media_fee3

yahoodsp__ad_performance

n/a

display_ad

media_fee4

yahoodsp__ad_performance

n/a

display_ad

media_fee5

yahoodsp__ad_performance

n/a

display_ad

page_view

yahoodsp__ad_performance

n/a

display_ad

platform

yahoodsp__ad_performance

n/a

display_ad

profit

yahoodsp__ad_performance

n/a

display_ad

publisher_platform

yahoodsp__ad_performance

n/a

display_ad

sessions

yahoodsp__ad_performance

n/a

display_ad

short_text

yahoodsp__ad_performance

n/a

display_ad

thumbnail_url

yahoodsp__ad_performance

n/a

display_ad

time_on_site

yahoodsp__ad_performance

n/a

display_ad

total_revenue

yahoodsp__ad_performance

total_conversions_value

display_ad

video_p25_watched

yahoodsp__ad_performance

n/a

display_ad

video_p50_watched

yahoodsp__ad_performance

n/a

display_ad

video_p75_watched

yahoodsp__ad_performance

n/a

display_ad

video_p100_watched

yahoodsp__ad_performance

n/a

display_ad

video_views

yahoodsp__ad_performance

n/a

display_ad

view_through_revenue

yahoodsp__ad_performance

view_through_conversions_value


display_placement → ad_performance

Click to expand table

ADL 1 Table

ADL 1 Column

ADL 2 Table

ADL 2 Column

display_placement

billable_dsp_cost

ad_performance

n/a

display_placement

cm_click_through_revenue

ad_performance

cm_click_through_conversions_value

display_placement

cm_measurable_impressions

ad_performance

n/a

display_placement

cm_total_revenue

ad_performance

cm_total_conversions_value

display_placement

cm_video_completions

ad_performance

cm_video_p100_watched

display_placement

cm_video_plays

ad_performance

cm_video_starts

display_placement

cm_view_through_revenue

ad_performance

cm_view_through_conversions_value

display_placement

cm_viewable_impressions

ad_performance

n/a

display_placement

device

ad_performance

n/a

display_placement

dsp_account_id

ad_performance

account_id

display_placement

dsp_account_name

ad_performance

account_name

display_placement

dsp_campaign_id

ad_performance

campaign_id

display_placement

dsp_campaign_name

ad_performance

campaign_name

display_placement

dsp_click_through_conversions

ad_performance

click_through_conversions

display_placement

dsp_click_through_revenue

ad_performance

click_through_conversions_value

display_placement

dsp_clicks

ad_performance

clicks

display_placement

dsp_impressions

ad_performance

impressions

display_placement

dsp_total_conversions

ad_performance

total_conversions

display_placement

dsp_total_revenue

ad_performance

total_conversions_value

display_placement

dsp_view_through_conversions

ad_performance

view_through_conversions

display_placement

dsp_view_through_revenue

ad_performance

view_through_conversions_value

display_placement

effective_cpm

ad_performance

n/a

display_placement

is_managed

ad_performance

n/a

display_placement

placement_id

ad_performance

cm_placement_id

display_placement

placement_name

ad_performance

cm_placement_name

display_placement

profit

ad_performance

n/a

display_placement

site

ad_performance

cm_site

display_placement

site_id

ad_performance

cm_site_id

display_placement

site_key_name

ad_performance

cm_site_key_name


display_creative → creative_performance

Click to expand table

ADL 1 Table

ADL 1 Column

ADL 2 Table

ADL 2 Column

display_creative

billable_dsp_cost

creative_performance

n/a

display_creative

cm_account_id

creative_performance

account_id

display_creative

cm_account_name

creative_performance

account_name

display_creative

cm_campaign_end_date

creative_performance

campaign_end_date

display_creative

cm_campaign_id

creative_performance

campaign_id

display_creative

cm_campaign_name

creative_performance

campaign_name

display_creative

cm_campaign_start_date

creative_performance

campaign_start_date

display_creative

cm_click_through_revenue

creative_performance

cm_click_through_conversions_value

display_creative

cm_measurable_impressions

creative_performance

n/a

display_creative

cm_total_revenue

creative_performance

cm_total_conversions_value

display_creative

cm_video_completions

creative_performance

cm_video_p100_watched

display_creative

cm_video_plays

creative_performance

cm_video_starts

display_creative

cm_view_through_revenue

creative_performance

cm_view_through_conversions_value

display_creative

cm_viewable_impressions

creative_performance

n/a

display_creative

creative_type

creative_performance

n/a

display_creative

device

creative_performance

n/a

display_creative

dsp_account_id

creative_performance

account_id

display_creative

dsp_account_name

creative_performance

account_name

display_creative

dsp_campaign_id

creative_performance

campaign_id

display_creative

dsp_campaign_name

creative_performance

campaign_name

display_creative

dsp_click_through_conversions

creative_performance

click_through_conversions

display_creative

dsp_click_through_revenue

creative_performance

click_through_conversions_value

display_creative

dsp_clicks

creative_performance

clicks

display_creative

dsp_impressions

creative_performance

impressions

display_creative

dsp_total_conversions

creative_performance

total_conversions

display_creative

dsp_total_revenue

creative_performance

total_conversions_value

display_creative

dsp_view_through_conversions

creative_performance

view_through_conversions

display_creative

dsp_view_through_revenue

creative_performance

view_through_conversions_value

display_creative

effective_cpm

creative_performance

n/a

display_creative

is_managed

creative_performance

n/a

display_creative

profit

creative_performance

n/a

display_creative

site

creative_performance

cm_site_id

display_creative

site_id

creative_performance

cm_site_id


Social

social_ad → ad_performance*

In progress

Click to expand table

*Columns may be applicable to aggregated versions of report, e.g., social_adset → adgroup_performance | social_campaign → campaign_performance | social_account → account_performance


social_creative → creative_performance

Click to expand table

ADL 1 Table

ADL 1 Column

ADL 2 Table

ADL 2 Column

social_creative

adset_id

creative_performance

adgroup_id

social_creative

adset_name

creative_performance

adgroup_name

social_creative

preview_link

creative_performance

ad_preview_link

social_creative

ad_post_text

creative_performance

n/a

social_creative

actions

creative_performance

n/a

social_creative

revenue

creative_performance

conversions_value

social_creative

cpm

creative_performance

n/a

social_creative

ctr

creative_performance

n/a

social_creative

aov

creative_performance

n/a

social_creative

roas

creative_performance

n/a

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.