If you want to work directly with the data output in BigQuery, getting started is straightforward. Here’s an example of a query you can use to analyze performance metrics from your Creative insights report.
This query retrieves and summarizes data at the ad level, offering insights into impressions, clicks, ad spend, and the performance of different creative assets like images. It groups the data by campaign, ad, and creative asset to provide a detailed view of how each ad and its components are performing.
SELECT
main.campaign_name,
main.ad_name,
main.platform,
main.account_name,
SUM(main.ad_spend) AS total_ad_spend, -- ad_spend from the main table
SUM(main.clicks) AS total_clicks,
SUM(main.impressions) AS total_impressions, -- impressions from the main table
SUM(main.viewable_impressions) AS total_viewable_impressions,
SUM(main.video_views) AS total_video_views,
SUM(conversions.conversions) AS total_conversions,
images.image_name AS image_name,
images.image_url AS image_url,
SUM(images.ad_spend) AS total_image_ad_spend, -- ad_spend from the images nested field
SUM(images.impressions) AS total_image_impressions, -- impressions from the images nested field
images.creative_size AS image_creative_size,
images.creative_type AS image_creative_type,
MAX(main.clicks_1_to_14_days) AS max_clicks_1_to_14_days,
MAX(main.cost_1_to_14_days) AS max_cost_1_to_14_days,
MAX(main.impressions_1_to_14_days) AS max_impressions_1_to_14_days
FROM
`your_project.your_dataset.creative_insights_report_output_base_{table_suffix}` AS main, -- Alias the main table
UNNEST(main.images) AS images,
UNNEST(main.conversions) AS conversions
GROUP BY
main.campaign_name,
main.ad_name,
main.platform,
main.account_name,
image_name,
image_url,
image_creative_size,
image_creative_type
ORDER BY
main.campaign_name,
main.ad_name;
Table 1: creative_insights_report_output_base_{table_suffix}
Full name | Type | Description |
date | DATE | The date of the record. |
platform | STRING | The platform where the ad was run, such as Google Ads, Facebook Ads, etc. |
account_name | STRING | The name of the account associated with the ads. |
currency | STRING | The currency in which the financial metrics are recorded. |
source_currency | STRING | The original currency used in the source platform. |
account_id | STRING | The unique identifier for the account. |
market_name | STRING | The market or geographic region where the campaign is targeted. |
channel_grouping | STRING | The grouping of marketing channels used in the campaign, such as "Search," "Social," or "Display." |
audience_grouping | STRING | The audience segment targeted by the campaign, grouped by criteria like demographics, interests, or behavior. |
funnel_grouping | STRING | The stage in the marketing funnel targeted by the campaign, such as "Awareness," "Consideration," or "Conversion." |
custom_campaign_type | STRING | A custom classification of the campaign type, defined specifically for your analysis. |
ad_concept_grouping | STRING | The grouping of ad concepts used in the campaign, often used for creative testing. |
ad_format_grouping | STRING | The ad format grouping, such as "Video," "Image," "Carousel," etc. |
test_grouping | STRING | A custom grouping used for categorizing different tests or experiments within the campaign. |
custom_grouping_1 | STRING | An additional custom grouping for specific reporting needs. |
custom_grouping_2 | STRING | An additional custom grouping for specific reporting needs. |
custom_grouping_3 | STRING | An additional custom grouping for specific reporting needs. |
custom_grouping_4 | STRING | An additional custom grouping for specific reporting needs. |
campaign_name | STRING | The campaign_name field standardizes naming across platforms:
|
campaign_id | STRING | The unique identifier for the campaign. |
campaign_type | STRING | The type of campaign, such as "Search," "Display," "Video," etc. |
adset_name | STRING | The adset_name field standardizes naming across multiple ad platforms at the group level:
|
adset_id | STRING | The unique identifier for the ad set or ad group. |
ad_name | STRING | The name of the individual ad. |
cm360_placement_id | STRING | The unique identifier for the placement in Campaign Manager 360, if applicable. |
ad_id | STRING | The unique identifier for the ad. |
platform_placement | STRING | The placement of the ad on the platform, such as "Feed," "Story," or "Search Results." |
conversions | RECORD | A repeated field containing details about conversions attributed to the ad. |
images | RECORD | A repeated field containing details about images used in the ad. |
ad_final_urls | RECORD | A repeated field containing details about final URLs used in the ad. |
ad_contents | RECORD | A repeated field containing details about ad content such as headlines, descriptions, and call-to-actions. |
ad_type | STRING | The type of ad, such as "Image," "Video," or "Text." |
first_image_url | STRING | The URL of the first image used in the ad, if applicable. |
first_image_name | STRING | The name of the first image used in the ad. |
first_youtube_video_url | STRING | The URL of the first YouTube video used in the ad, if applicable. |
first_ad_final_url | STRING | The final URL that the first ad directs users to. |
first_headline | STRING | The first headline used in the ad. |
first_description | STRING | The first description used in the ad. |
first_body_asset | STRING | The first body asset (main text content) used in the ad. |
first_call_to_action | STRING | The first call-to-action (CTA) used in the ad. |
ad_active_timeline | STRING | The timeline during which the ad was active. |
date_started | STRING | The date when the ad first started running. |
date_ended | STRING | The date when the ad stopped running. |
days_active | INTEGER | The total number of days the ad was active. |
ad_live | BOOLEAN | Indicates whether the ad is currently live. |
custom_dimension_1 | STRING | A custom dimension for specific reporting needs. |
custom_dimension_2 | STRING | A custom dimension for specific reporting needs. |
custom_dimension_3 | STRING | A custom dimension for specific reporting needs. |
custom_dimension_4 | STRING | A custom dimension for specific reporting needs. |
custom_dimension_5 | STRING | A custom dimension for specific reporting needs. |
ad_spend | FLOAT | The total spend on the ad. |
clicks | FLOAT | The total number of clicks on the ad. |
impressions | FLOAT | The total number of impressions the ad received. |
viewable_impressions | FLOAT | The total number of viewable impressions according to industry standards (e.g., Active View). |
video_views | FLOAT | The total number of video views, if applicable. |
video_avg_time_watched_actions | FLOAT | The average time users spent watching the video. |
video_p25_watched_actions | FLOAT | The number of users who watched 25% of the video. |
video_p50_watched_actions | FLOAT | The number of users who watched 50% of the video. |
video_p75_watched_actions | FLOAT | The number of users who watched 75% of the video. |
video_p100_watched_actions | FLOAT | The number of users who watched 100% of the video. |
impressions_1_to_14_days | FLOAT | The number of impressions the ad received in the first 1 to 14 days of the campaign. |
impressions_15_to_28_days | FLOAT | The number of impressions the ad received between the 15th and 28th days of the campaign. |
impressions_29_to_42_days | FLOAT | The number of impressions the ad received between the 29th and 42nd days of the campaign. |
cost_1_to_14_days | FLOAT | The ad cost incurred in the first 1 to 14 days of the campaign. |
cost_15_to_28_days | FLOAT | The ad cost incurred between the 15th and 28th days of the campaign. |
cost_29_to_42_days | FLOAT | The ad cost incurred between the 29th and 42nd days of the campaign. |
clicks_1_to_14_days | FLOAT | The number of clicks the ad received in the first 1 to 14 days of the campaign. |
clicks_15_to_28_days | FLOAT | The number of clicks the ad received between the 15 |
clicks_1_to_14_days | FLOAT | The number of clicks the ad received in the first 1 to 14 days of the campaign. |
clicks_15_to_28_days | FLOAT | The number of clicks the ad received between the 15th and 28th days of the campaign. |
clicks_29_to_42_days | FLOAT | The number of clicks the ad received between the 29th and 42nd days of the campaign. |
video_views_1_to_14_days | FLOAT | The number of video views in the first 1 to 14 days of the campaign. |
video_views_15_to_28_days | FLOAT | The number of video views between the 15th and 28th days of the campaign. |
video_views_29_to_42_days | FLOAT | The number of video views between the 29th and 42nd days of the campaign. |
p100_watched_1_to_14_days | FLOAT | The number of users who watched 100% of the video in the first 1 to 14 days of the campaign. |
p100_watched_15_to_28_days | FLOAT | The number of users who watched 100% of the video between the 15th and 28th days of the campaign. |
p100_watched_29_to_42_days | FLOAT | The number of users who watched 100% of the video between the 29th and 42nd days of the campaign. |
benchmark_ctr | FLOAT | The benchmark click-through rate (CTR) for the ad, based on your other similar campaigns in your account. |
benchmark_cpm | FLOAT | The benchmark cost per thousand impressions (CPM) for the ad, based on your other similar campaigns in your account. |
benchmark_cpc | FLOAT | The benchmark cost per click (CPC) for the ad, based on your other similar campaigns in your account. |
benchmark_clicks | FLOAT | The benchmark number of clicks for the ad, based on your other similar campaigns in your account. |
benchmark_impressions | FLOAT | The benchmark number of impressions for the ad, based on your other similar campaigns in your account. |
benchmark_ad_spend | FLOAT | The benchmark ad spend for the ad, based on your other similar campaigns in your account. |
count_videos | INTEGER | The total number of videos used in the ad. |
count_images | INTEGER | The total number of images used in the ad. |
ad_has_video_and_image | BOOLEAN | Indicates whether the ad contains both video and image content. |
conversions.conversion_name | STRING | The name of the conversion event, such as "Purchase," "Sign-Up," etc. |
conversions.conversion_source | STRING | The source of the conversion, such as "Google Ads," "Facebook Ads," etc. |
conversions.conversion_group | STRING | The grouping or categorization of the conversion event, based on predefined categories like "Sales," "Leads," etc. |
conversions.source_conversion_name | STRING | The original name of the conversion as recorded in the source platform. |
conversions.conversion_value | FLOAT | The monetary value associated with the conversion event. |
conversions.conversions | FLOAT | The total number of conversions attributed to the ad. |
conversions.conversions_1_to_14_days | FLOAT | The number of conversions in the first 1 to 14 days of the campaign. |
conversions.conversions_15_to_28_days | FLOAT | The number of conversions between the 15th and 28th days of the campaign. |
conversions.conversions_29_to_42_days | FLOAT | The number of conversions between the 29th and 42nd days of the campaign. |
conversions.conversion_value_1_to_14_days | FLOAT | The conversion value in the first 1 to 14 days of the campaign. |
conversions.conversion_value_15_to_28_days | FLOAT | The conversion value between the 15th and 28th days of the campaign. |
conversions.conversion_value_29_to_42_days | FLOAT | The conversion value between the 29th and 42nd days of the campaign. |
conversions.benchmark_conversions | FLOAT | The benchmark number of conversions for the ad, based on your other similar campaigns in your account. |
conversions.benchmark_conversion_value | FLOAT | The benchmark conversion value for the ad, based on your other similar campaigns in your account. |
images.creative_no | INTEGER | The creative number or identifier used to distinguish different images used in the ad. |
images.creative_type | STRING | The type of creative, such as "Image," "Banner," etc. |
images.image_url | STRING | The URL of the image used in the ad. |
images.image_name | STRING | The name of the image file used in the ad. |
images.creative_size | STRING | The size of the image creative, typically specified in pixels (e.g., "300x250"). |
images.creative_height | STRING | The height of the image creative, specified in pixels. |
images.creative_width | STRING | The width of the image creative, specified in pixels. |
images.youtube_video_url | STRING | The URL of the associated YouTube video, if applicable. |
images.custom_image_dimension_1 | STRING | A custom dimension for specific image reporting needs. |
images.custom_image_dimension_2 | STRING | A custom dimension for specific image reporting needs. |
images.custom_image_dimension_3 | STRING | A custom dimension for specific image reporting needs. |
images.custom_image_dimension_4 | STRING | A custom dimension for specific image reporting needs. |
images.custom_image_dimension_5 | STRING | A custom dimension for specific image reporting needs. |
images.ad_spend | FLOAT | The total ad spend attributed to the image creative. |
images.impressions | FLOAT | The total number of impressions the image creative received. |
ad_final_urls.ad_final_urls | STRING | The final URLs that users are directed to after clicking on the ad. |
ad_final_urls.lifetime_impressions | FLOAT | The total number of impressions attributed to the final URL over the lifetime of the ad. |
ad_contents.descriptions | STRING | The descriptions used in the ad content. |
ad_contents.headlines | STRING | The headlines used in the ad content. |
ad_contents.call_to_actions | STRING | The calls to action (CTAs) used in the ad content. |
ad_contents.body_assets | STRING | The main body text or assets used in the ad content. |
ad_contents.lifetime_impressions | FLOAT | The total number of impressions attributed to the ad content over the lifetime of the ad. |
Table 2: creative_insights_report_output_dv360_{table_suffix}
Full name | Type | Description |
date | DATE | The date of the record. |
platform | STRING | The platform where the ad campaign is being run, specifically DV360 in this case. |
account_name | STRING | The name of the account associated with the DV360 campaigns. |
source_currency | STRING | The original currency used in the data source, such as USD, EUR. |
currency | STRING | The currency used for reporting and conversion of financial metrics. |
account_id | STRING | The unique identifier for the DV360 account. |
campaign_name | STRING | The name of the campaign within DV360. |
campaign_id | STRING | The unique identifier for the campaign. |
campaign_type | STRING | The type of campaign, such as "Display," "Video," or "TrueView." |
adset_name | STRING | The adset_name field standardizes naming across multiple ad platforms at the group level:
|
adset_id | STRING | The unique identifier for the ad set or ad group. |
ad_name | STRING | The name of the individual ad within the ad set. |
ad_id | STRING | The unique identifier for the ad. |
cm360_placement_id | STRING | The unique identifier for the placement in Campaign Manager 360, if applicable. |
platform_placement | STRING | The specific placement of the ad on the platform, such as "In-stream," "Banner," or "Native." |
channel_grouping | STRING | The grouping of channels used in the campaign, such as "Search," "Social," or "Display." |
market_name | STRING | The market or geographic region where the campaign is targeted. |
audience_grouping | STRING | The audience segment targeted by the campaign, grouped by criteria like demographics, interests, or behavior. |
funnel_grouping | STRING | The stage in the marketing funnel targeted by the campaign, such as "Awareness," "Consideration," or "Conversion." |
custom_campaign_type | STRING | A custom classification of the campaign type, defined specifically for your analysis. |
ad_concept_grouping | STRING | The grouping of ad concepts used in the campaign, often used for creative testing. |
ad_format_grouping | STRING | The ad format grouping, such as "Video," "Image," or "Rich Media." |
test_grouping | STRING | A custom grouping used for categorizing different tests or experiments within the campaign. |
custom_grouping_1 | STRING | An additional custom grouping for specific reporting needs. |
custom_grouping_2 | STRING | An additional custom grouping for specific reporting needs. |
custom_grouping_3 | STRING | An additional custom grouping for specific reporting needs. |
custom_grouping_4 | STRING | An additional custom grouping for specific reporting needs. |
filter_insertion_order_name | STRING | The name of the insertion order associated with the ad. |
filter_insertion_order | STRING | The unique identifier for the insertion order. |
filter_line_item_name | STRING | The name of the line item within the insertion order. |
filter_line_item | STRING | The unique identifier for the line item. |
filter_creative_type | STRING | The type of creative used in the ad, such as "Banner," "Video," or "HTML5." |
filter_position_in_content | STRING | The position of the ad within the content, such as "Pre-roll," "Mid-roll," or "Post-roll" for video ads. |
filter_trueview_ad_group | STRING | The TrueView ad group name, applicable if using TrueView ads on YouTube. |
filter_trueview_ad_group_id | STRING | The unique identifier for the TrueView ad group. |
filter_advertiser_currency | STRING | The currency used by the advertiser for the campaign. |
filter_youtube_ad_video_id | STRING | The unique identifier for the YouTube video ad, applicable if using YouTube ads. |
filter_youtube_ad_video | STRING | The name or title of the YouTube video ad. |
video_views | FLOAT | The number of video views recorded for the ad. |
ad_spend | FLOAT | The total spend on the ad. |
clicks | FLOAT | The total number of clicks on the ad. |
impressions | FLOAT | The total number of impressions the ad received. |
viewable_impressions | FLOAT | The total number of viewable impressions according to industry standards. |
video_avg_time_watched_actions | FLOAT | The average time users spent watching the video. |
video_p25_watched_actions | FLOAT | The number of users who watched 25% of the video. |
video_p50_watched_actions | FLOAT | The number of users who watched 50% of the video. |
video_p75_watched_actions | FLOAT | The number of users who watched 75% of the video. |
video_p100_watched_actions | FLOAT | The number of users who watched 100% of the video. |
metric_impressions | FLOAT | The metric used to track impressions, potentially adjusted for specific reporting needs. |
metric_clicks | FLOAT | The metric used to track clicks, potentially adjusted for specific reporting needs. |
metric_revenue_advertiser | FLOAT | The revenue attributed to the advertiser from the campaign. |
metric_active_view_viewable_impressions | FLOAT | The number of Active View viewable impressions, based on Google's Active View technology. |
metric_trueview_views | FLOAT | The number of views recorded for TrueView ads, specifically for YouTube campaigns. |
metric_rich_media_video_completions | FLOAT | The number of times a rich media video ad was viewed to completion. |
metric_rich_media_video_first_quartile_completes | FLOAT | The number of times a rich media video ad reached the first quartile. |
metric_rich_media_video_third_quartile_completes | FLOAT | The number of times a rich media video ad reached the third quartile. |
metric_rich_media_video_midpoints | FLOAT | The number of times a rich media video ad reached the midpoint. |
metric_watch_time | FLOAT | The total watch time recorded for the video ads. |
metric_trueview_earned_likes | FLOAT | The number of likes earned from TrueView ads. |
metric_trueview_earned_playlist_additions | FLOAT | The number of playlist additions earned from TrueView ads. |
metric_trueview_earned_shares | FLOAT | The number of shares earned from TrueView ads. |
metric_trueview_earned_subscribers | FLOAT | The number of subscribers earned from TrueView ads. |
metric_trueview_earned_views | FLOAT | The number of views earned from TrueView ads. |
metric_trueview_engagements | FLOAT | The number of engagements recorded from TrueView ads. |
metric_average_watch_time_per_impression | FLOAT | The average watch time per impression, calculated across all video impressions. |
metric_total_conversions | FLOAT | The total number of conversions recorded from the campaign. |
metric_last_clicks | FLOAT | The number of last-click interactions attributed to the campaign. |
metric_last_impressions | FLOAT | The number of last-impression interactions attributed to the campaign. |
metric_cm360_post_click_revenue | FLOAT | The post-click revenue attributed through Campaign Manager 360 from the campaign. |
metric_cm360_post_view_revenue | FLOAT | The post-view revenue attributed through Campaign Manager 360 from the campaign. |
custom_dimension_1 | STRING | A custom dimension for specific reporting needs. |
custom_dimension_2 | STRING | A custom dimension for specific reporting needs. |
custom_dimension_3 | STRING | A custom dimension for specific reporting needs. |
custom_dimension_4 | STRING | A custom dimension for specific reporting needs. |
custom_dimension_5 | STRING | A custom dimension for specific reporting needs. |
ad_active_timeline | STRING | The timeline during which the ad was active. |
date_started | STRING | The date when the ad first started running. |
date_ended | STRING | The date when the ad stopped running. |
days_active | INTEGER | The total number of days the ad was active. |
ad_live | BOOLEAN | Indicates whether the ad is currently live. |
images | RECORD | A repeated field containing details about images used in the ad. |
ad_final_urls | RECORD | A repeated field containing details about final URLs used in the ad. |
ad_contents | RECORD | A repeated field containing details about ad content such as headlines, descriptions, and call-to-actions. |
ad_type | STRING | The type of ad, such as "Image," "Video," or "Rich Media." |
conversions | RECORD | A repeated field containing details about conversions attributed to the ad. |
count_videos | INTEGER | The total number of videos used in the ad. |
count_images | INTEGER | The total number of images used in the ad. |
ad_has_video_and_image | BOOLEAN | Indicates whether the ad contains both video and image content. |
images.creative_no | INTEGER | The creative number or identifier used to distinguish different images used in the ad. |
images.creative_type | STRING | The type of creative, such as "Image," "Banner," etc. |
images.image_url | STRING | The URL of the image used in the ad. |
images.image_name | STRING | The name of the image file used in the ad. |
images.creative_size | STRING | The size of the image creative, typically specified in pixels (e.g., "300x250"). |
images.creative_height | STRING | The height of the image creative, specified in pixels. |
images.creative_width | STRING | The width of the image creative, specified in pixels. |
images.youtube_video_url | STRING | The URL of the associated YouTube video, if applicable. |
images.custom_image_dimension_1 | STRING | A custom dimension for specific image reporting needs. |
images.custom_image_dimension_2 | STRING | A custom dimension for specific image reporting needs. |
images.custom_image_dimension_3 | STRING | A custom dimension for specific image reporting needs. |
images.custom_image_dimension_4 | STRING | A custom dimension for specific image reporting needs. |
images.custom_image_dimension_5 | STRING | A custom dimension for specific image reporting needs. |
images.ad_spend | FLOAT | The total ad spend attributed to the image creative. |
images.impressions | FLOAT | The total number of impressions the image creative received. |
ad_final_urls.ad_final_urls | STRING | The final URLs that users are directed to after clicking on the ad. |
ad_contents.descriptions | STRING | The descriptions used in the ad content. |
ad_contents.headlines | STRING | The headlines used in the ad content. |
ad_contents.call_to_actions | STRING | The calls to action (CTAs) used in the ad content. |
ad_contents.body_assets | STRING | The main body text or assets used in the ad content. |
conversions.conversion_name | STRING | The name of the conversion event, such as "Purchase," "Sign-Up," etc. |
conversions.conversion_source | STRING | The source of the conversion, such as "DV360," "YouTube Ads," etc. |
conversions.conversion_group | STRING | The grouping or categorization of the conversion event, based on predefined categories like "Sales," "Leads," etc. |
conversions.source_conversion_name | STRING | The original name of the conversion as recorded in the source platform. |
conversions.conversion_value | FLOAT | The monetary value associated with the conversion event. |
conversions.conversions | FLOAT | The total number of conversions attributed to the ad. |
Table 3: creative_insights_report_output_meta_{table_suffix}
Full name | Type | Description |
date | DATE | The date of the record. |
platform | STRING | The platform where the ad campaign is being run, specifically Meta (Facebook) in this case. |
account_name | STRING | The name of the account associated with the Meta (Facebook) campaigns. |
source_currency | STRING | The original currency used in the data source, such as USD, EUR. |
currency | STRING | The currency used for reporting and conversion of financial metrics. |
account_id | STRING | The unique identifier for the Meta (Facebook) account. |
campaign_name | STRING | The name of the campaign within Meta (Facebook). |
campaign_id | STRING | The unique identifier for the campaign. |
campaign_type | STRING | The type of campaign, such as "Brand Awareness," "Conversions," or "Traffic." |
adset_name | STRING | The name of the ad set or ad group within the campaign. |
adset_id | STRING | The unique identifier for the ad set or ad group. |
ad_name | STRING | The name of the individual ad within the ad set. |
ad_id | STRING | The unique identifier for the ad. |
cm360_placement_id | STRING | The unique identifier for the placement in Campaign Manager 360, if applicable. |
platform_placement | STRING | The specific placement of the ad on the platform, such as "Feed," "Stories," or "Right Column." |
device_platform | STRING | The device platform where the ad was shown, such as "Mobile," "Desktop," or "Tablet." |
publisher_platform | STRING | The publisher platform where the ad was displayed, such as "Facebook," "Instagram," or "Audience Network." |
buying_type | STRING | The buying type for the ad, such as "Auction" or "Reach and Frequency." |
objective | STRING | The objective of the campaign, such as "Traffic," "Conversions," or "Brand Awareness." |
optimization_goal | STRING | The optimization goal for the ad set, such as "Landing Page Views," "Link Clicks," or "Impressions." |
channel_grouping | STRING | The grouping of channels used in the campaign, such as "Social," "Display," or "Video." |
market_name | STRING | The market or geographic region where the campaign is targeted. |
audience_grouping | STRING | The audience segment targeted by the campaign, grouped by criteria like demographics, interests, or behavior. |
funnel_grouping | STRING | The stage in the marketing funnel targeted by the campaign, such as "Awareness," "Consideration," or "Conversion." |
custom_campaign_type | STRING | A custom classification of the campaign type, defined specifically for your analysis. |
ad_concept_grouping | STRING | The grouping of ad concepts used in the campaign, often used for creative testing. |
ad_format_grouping | STRING | The ad format grouping, such as "Image," "Video," "Carousel," etc. |
test_grouping | STRING | A custom grouping used for categorizing different tests or experiments within the campaign. |
custom_grouping_1 | STRING | An additional custom grouping for specific reporting needs. |
custom_grouping_2 | STRING | An additional custom grouping for specific reporting needs. |
custom_grouping_3 | STRING | An additional custom grouping for specific reporting needs. |
custom_grouping_4 | STRING | An additional custom grouping for specific reporting needs. |
video_views | FLOAT | The number of video views recorded for the ad. |
ad_spend | FLOAT | The total spend on the ad. |
clicks | INTEGER | The total number of clicks on the ad. |
impressions | INTEGER | The total number of impressions the ad received. |
viewable_impressions | INTEGER | The total number of viewable impressions according to industry standards. |
video_avg_time_watched_actions | FLOAT | The average time users spent watching the video. |
video_p25_watched_actions | FLOAT | The number of users who watched 25% of the video. |
video_p50_watched_actions | FLOAT | The number of users who watched 50% of the video. |
video_p75_watched_actions | FLOAT | The number of users who watched 75% of the video. |
video_p100_watched_actions | FLOAT | The number of users who watched 100% of the video. |
unique_clicks | INTEGER | The number of unique clicks on the ad. |
social_spend | FLOAT | Social spend is the subset of that where the budget went towards stories due to people liking/commenting/sharing on the object |
estimated_ad_recallers | INTEGER | The estimated number of people who will remember seeing your ad if asked within two days. |
estimated_ad_recall_rate | FLOAT | The estimated percentage of people who will remember seeing your ad if asked within two days. |
cost_per_estimated_ad_recallers | FLOAT | The cost per estimated ad recaller, calculated as the total spend divided by the estimated number of people who will remember your ad. |
link_clicks | FLOAT | The number of clicks on links within the ad. |
custom_dimension_1 | STRING | A custom dimension for specific reporting needs. |
custom_dimension_2 | STRING | A custom dimension for specific reporting needs. |
custom_dimension_3 | STRING | A custom dimension for specific reporting needs. |
custom_dimension_4 | STRING | A custom dimension for specific reporting needs. |
custom_dimension_5 | STRING | A custom dimension for specific reporting needs. |
ad_active_timeline | STRING | The timeline during which the ad was active. |
date_started | STRING | The date when the ad first started running. |
date_ended | STRING | The date when the ad stopped running. |
days_active | INTEGER | The total number of days the ad was active. |
ad_live | BOOLEAN | Indicates whether the ad is currently live. |
images | RECORD | A repeated field containing details about images used in the ad. |
ad_final_urls | RECORD | A repeated field containing details about final URLs used in the ad. |
ad_contents | RECORD | A repeated field containing details about ad content such as headlines, descriptions, and call-to-actions. |
ad_type | STRING | The type of ad, such as "Image," "Video," or "Carousel." |
conversions | RECORD | A repeated field containing details about conversions attributed to the ad. |
count_videos | INTEGER | The total number of videos used in the ad. |
count_images | INTEGER | The total number of images used in the ad. |
ad_has_video_and_image | BOOLEAN | Indicates whether the ad contains both video and image content. |
images.creative_no | INTEGER | The creative number or identifier used to distinguish different images used in the ad. |
images.creative_type | STRING | The type of creative, such as "Image," "Banner," etc. |
images.image_url | STRING | The URL of the image used in the ad. |
images.image_name | STRING | The name of the image file used in the ad. |
images.creative_size | STRING | The size of the image creative, typically specified in pixels (e.g., "300x250"). |
images.creative_height | STRING | The height of the image creative, specified in pixels. |
images.creative_width | STRING | The width of the image creative, specified in pixels. |
images.youtube_video_url | STRING | The URL of the associated YouTube video, if applicable. |
images.custom_image_dimension_1 | STRING | A custom dimension for specific image reporting needs. |
images.custom_image_dimension_2 | STRING | A custom dimension for specific image reporting needs. |
images.custom_image_dimension_3 | STRING | A custom dimension for specific image reporting needs. |
images.custom_image_dimension_4 | STRING | A custom dimension for specific image reporting needs. |
images.custom_image_dimension_5 | STRING | A custom dimension for specific image reporting needs. |
images.ad_spend | FLOAT | The total ad spend attributed to the image creative. |
images.impressions | FLOAT | The total number of impressions the image creative received. |
ad_final_urls.ad_final_urls | STRING | The final URLs that users are directed to after clicking on the ad. |
ad_contents.descriptions | STRING | The descriptions used in the ad content. |
ad_contents.headlines | STRING | The headlines used in the ad content. |
ad_contents.call_to_actions | STRING | The calls to action (CTAs) used in the ad content. |
ad_contents.body_assets | STRING | The main body text or assets used in the ad content. |
conversions.conversion_name | STRING | The name of the conversion event, such as "Purchase," "Sign-Up," etc. |
conversions.conversion_source | STRING | The source of the conversion, such as "Meta (Facebook)," "Instagram," etc. |
conversions.conversion_group | STRING | The grouping or categorization of the conversion event, based on predefined categories like "Sales," "Leads," etc. |
conversions.source_conversion_name | STRING | The original name of the conversion as recorded in the source platform. |
conversions.conversion_value | FLOAT | The monetary value associated with the conversion event. |
conversions.conversions | FLOAT | The total number of conversions attributed to the ad. |
Table 4: creative_insights_report_output_gads_{table_suffix}
Full name | Type | Description |
date | DATE | The date of the record. |
platform | STRING | The platform where the ad campaign is being run, specifically Google Ads in this case. |
account_name | STRING | The name of the account associated with the Google Ads campaigns. |
source_currency | STRING | The original currency used in the data source, such as USD, EUR. |
currency | STRING | The currency used for reporting and conversion of financial metrics. |
account_id | STRING | The unique identifier for the Google Ads account. |
campaign_name | STRING | The name of the campaign within Google Ads. |
campaign_id | STRING | The unique identifier for the campaign. |
campaign_type | STRING | The type of campaign, such as "Search," "Display," or "Video." |
adset_name | STRING | The adset_name field standardizes naming across multiple ad platforms at the group level:
|
adset_id | STRING | The unique identifier for the ad set or ad group. |
ad_name | STRING | The name of the individual ad within the ad set. |
ad_id | STRING | The unique identifier for the ad. |
cm360_placement_id | STRING | The unique identifier for the placement in Campaign Manager 360, if applicable. |
platform_placement | STRING | The specific placement of the ad on the platform, such as "Search Results," "Display Network," or "YouTube." |
channel_grouping | STRING | The grouping of channels used in the campaign, such as "Search," "Display," or "Video." |
market_name | STRING | The market or geographic region where the campaign is targeted. |
audience_grouping | STRING | The audience segment targeted by the campaign, grouped by criteria like demographics, interests, or behavior. |
funnel_grouping | STRING | The stage in the marketing funnel targeted by the campaign, such as "Awareness," "Consideration," or "Conversion." |
custom_campaign_type | STRING | A custom classification of the campaign type, defined specifically for your analysis. |
ad_concept_grouping | STRING | The grouping of ad concepts used in the campaign, often used for creative testing. |
ad_format_grouping | STRING | The ad format grouping, such as "Text," "Image," "Video," etc. |
test_grouping | STRING | A custom grouping used for categorizing different tests or experiments within the campaign. |
custom_grouping_1 | STRING | An additional custom grouping for specific reporting needs. |
custom_grouping_2 | STRING | An additional custom grouping for specific reporting needs. |
custom_grouping_3 | STRING | An additional custom grouping for specific reporting needs. |
custom_grouping_4 | STRING | An additional custom grouping for specific reporting needs. |
campaign__advertising_channel_type | STRING | The primary channel type for the campaign, such as "Search," "Display," or "Shopping." |
campaign__advertising_channel_sub_type | STRING | The sub-type of the advertising channel, such as "Smart Shopping," "Video TrueView," or "Dynamic Search Ads." |
ad_group__id | STRING | The unique identifier for the ad group within the campaign. |
ad_group__name | STRING | The name of the ad group. |
ad_group__status | STRING | The status of the ad group, such as "Enabled," "Paused," or "Removed." |
ad_group_ad__ad_strength | STRING | The strength of the ad as determined by Google Ads, typically represented as "Poor," "Average," "Good," or "Excellent." |
ad_group_ad__ad__type | STRING | The type of ad, such as "Text Ad," "Responsive Search Ad," or "Responsive Display Ad." |
ad_group_ad__ad__added_by_google_ads | STRING | Indicates whether the ad was automatically created by Google Ads, typically for responsive ads. |
ad_group_ad__ad__final_mobile_urls | STRING | The final mobile URLs associated with the ad, directing users to specific pages when accessed via mobile devices. |
ad_group_ad__ad__final_urls | STRING | The final URLs associated with the ad, directing users to specific landing pages. |
ad_group_ad__ad__tracking_url_template | STRING | The tracking URL template used for tracking ad performance with third-party tools. |
ad_group_ad__ad__url_custom_parameters | STRING | Custom URL parameters used for tracking specific details about the ad performance. |
ad_group_ad__ad__device_preference | STRING | The preferred device for the ad, such as "Mobile" or "Desktop." |
ad_group_ad__ad__display_url | STRING | The display URL shown to users in the ad. |
ad_group_ad__ad__id | STRING | The unique identifier for the ad within the ad group. |
ad_group_ad__ad__name | STRING | The name of the ad. |
ad_group_ad__policy_summary__policy_topic_entries | STRING | The policy topic entries associated with the ad, indicating any potential policy issues. |
ad_group_ad__policy_summary__approval_status | STRING | The approval status of the ad, such as "Approved," "Disapproved," or "Under Review." |
ad_group_ad__status | STRING | The status of the ad within the ad group, such as "Enabled," "Paused," or "Removed." |
asset_group__name | STRING | The name of the asset group, applicable for campaigns using asset-based ads like Performance Max campaigns. |
asset_group__id | STRING | The unique identifier for the asset group. |
asset_group__ad_strength | STRING | The strength of the asset group as determined by Google Ads, typically represented as "Poor," "Average," "Good," or "Excellent." |
asset_group__status | STRING | The status of the asset group, such as "Enabled," "Paused," or "Removed." |
asset_group__primary_status | STRING | The primary status of the asset group, indicating its overall performance or issues. |
asset_group__path1 | STRING | The first path segment of the display URL for asset groups, often used in Performance Max campaigns. |
asset_group__path2 | STRING | The second path segment of the display URL for asset groups. |
video_views | FLOAT | The number of video views recorded for the ad. |
ad_spend | FLOAT | The total spend on the ad. |
clicks | FLOAT | The total number of clicks on the ad. |
impressions | FLOAT | The total number of impressions the ad received. |
viewable_impressions | FLOAT | The total number of viewable impressions according to industry standards. |
video_avg_time_watched_actions | FLOAT | The average time users spent watching the video. |
video_p25_watched_actions | FLOAT | The number of users who watched 25% of the video. |
video_p50_watched_actions | FLOAT | The number of users who watched 50% of the video. |
video_p75_watched_actions | FLOAT | The number of users who watched 75% of the video. |
video_p100_watched_actions | FLOAT | The number of users who watched 100% of the video. |
interactions | FLOAT | The total number of interactions with the ad, including clicks, video views, and other engagement actions. |
active_view_impressions | FLOAT | The number of Active View impressions, which meet Google's viewability standards. |
active_view_measurability | FLOAT | The percentage of measurable impressions, showing the share of impressions that could be measured for viewability. |
active_view_measurable_impressions | FLOAT | The total number of measurable impressions, which are eligible to be counted as viewable impressions. |
active_view_viewability | FLOAT | The percentage of viewable impressions, indicating the share of impressions that were actually viewed. |
average_page_views | FLOAT | The average number of pages viewed per session initiated by the ad. |
average_time_on_site | FLOAT | The average time users spent on the site after clicking on the ad. |
bounce_rate | FLOAT | The percentage of users who left the site after viewing only one page, indicating the level of engagement. |
cross_device_conversions | FLOAT | The total number of conversions that occurred across multiple devices, such as when a user clicks an ad on a mobile device but completes a purchase on a desktop. |
current_model_attributed_conversions | FLOAT | The total number of conversions attributed to the ad based on the current attribution model. |
current_model_attributed_conversions_value | FLOAT | The total value of conversions attributed to the ad based on the current attribution model. |
engagement_rate | FLOAT | The engagement rate, calculated as the ratio of engagements to impressions. |
engagements | FLOAT | The total number of engagements with the ad, including clicks, video views, and other interaction metrics. |
gmail_forwards | FLOAT | The number of times a Gmail ad was forwarded to another user. |
gmail_saves | FLOAT | The number of times a Gmail ad was saved by users. |
gmail_secondary_clicks | FLOAT | The number of secondary clicks on a Gmail ad, such as clicks to expand the ad or access additional content. |
percent_new_visitors | FLOAT | The percentage of new visitors to the site who came through the ad. |
top_impression_percentage | FLOAT | The percentage of impressions that were shown in the top position on the search results page. |
value_per_all_conversions | FLOAT | The average value per conversion, calculated as the total conversion value divided by the total number of conversions. |
view_through_conversions | FLOAT | The total number of conversions attributed to users who viewed but did not click on the ad. |
custom_dimension_1 | STRING | A custom dimension for specific reporting needs. |
custom_dimension_2 | STRING | A custom dimension for specific reporting needs. |
custom_dimension_3 | STRING | A custom dimension for specific reporting needs. |
custom_dimension_4 | STRING | A custom dimension for specific reporting needs. |
custom_dimension_5 | STRING | A custom dimension for specific reporting needs. |
ad_active_timeline | STRING | The timeline during which the ad was active. |
date_started | STRING | The date when the ad first started running. |
date_ended | STRING | The date when the ad stopped running. |
days_active | INTEGER | The total number of days the ad was active. |
ad_live | BOOLEAN | Indicates whether the ad is currently live. |
images | RECORD | A repeated field containing details about images used in the ad. |
ad_final_urls | RECORD | A repeated field containing details about final URLs used in the ad. |
ad_contents | RECORD | A repeated field containing details about ad content such as headlines, descriptions, and call-to-actions. |
ad_type | STRING | The type of ad, such as "Text," "Image," or "Video." |
conversions | RECORD | A repeated field containing details about conversions attributed to the ad. |
count_videos | INTEGER | The total number of videos used in the ad. |
count_images | INTEGER | The total number of images used in the ad. |
ad_has_video_and_image | BOOLEAN | Indicates whether the ad contains both video and image content. |
images.creative_no | INTEGER | The creative number or identifier used to distinguish different images used in the ad. |
images.creative_type | STRING | The type of creative, such as "Image," "Banner," etc. |
images.image_url | STRING | The URL of the image used in the ad. |
images.image_name | STRING | The name of the image file used in the ad. |
images.creative_size | STRING | The size of the image creative, typically specified in pixels (e.g., "300x250"). |
images.creative_height | STRING | The height of the image creative, specified in pixels. |
images.creative_width | STRING | The width of the image creative, specified in pixels. |
images.youtube_video_url | STRING | The URL of the associated YouTube video, if applicable. |
images.custom_image_dimension_1 | STRING | A custom dimension for specific image reporting needs. |
images.custom_image_dimension_2 | STRING | A custom dimension for specific image reporting needs. |
images.custom_image_dimension_3 | STRING | A custom dimension for specific image reporting needs. |
images.custom_image_dimension_4 | STRING | A custom dimension for specific image reporting needs. |
images.custom_image_dimension_5 | STRING | A custom dimension for specific image reporting needs. |
images.ad_spend | FLOAT | The total ad spend attributed to the image creative. |
images.impressions | FLOAT | The total number of impressions the image creative received. |
ad_final_urls.ad_final_urls | STRING | The final URLs that users are directed to after clicking on the ad. |
ad_contents.descriptions | STRING | The descriptions used in the ad content. |
ad_contents.headlines | STRING | The headlines used in the ad content. |
ad_contents.call_to_actions | STRING | The calls to action (CTAs) used in the ad content. |
ad_contents.body_assets | STRING | The main body text or assets used in the ad content. |
conversions.conversion_name | STRING | The name of the conversion event, such as "Purchase," "Sign-Up," etc. |
conversions.conversion_source | STRING | The source of the conversion, such as "Google Ads," "YouTube Ads," etc. |
conversions.conversion_group | STRING | The grouping or categorization of the conversion event, based on predefined categories like "Sales," "Leads," etc. |
conversions.source_conversion_name | STRING | The original name of the conversion as recorded in the source platform. |
conversions.conversion_value | FLOAT | The monetary value associated with the conversion event. |
conversions.conversions | FLOAT | The total number of conversions attributed to the ad. |
Table 5: creative_insights_report_output_tiktok_{table_suffix}
Full name | Type | Description |
date | DATE | The date of the record. |
platform | STRING | The platform where the ad campaign is being run, specifically TikTok in this case. |
account_name | STRING | The name of the account associated with the TikTok campaigns. |
source_currency | STRING | The original currency used in the data source, such as USD, EUR. |
currency | STRING | The currency used for reporting and conversion of financial metrics. |
account_id | STRING | The unique identifier for the TikTok account. |
campaign_name | STRING | The name of the campaign within TikTok. |
campaign_id | STRING | The unique identifier for the campaign. |
campaign_type | STRING | The type of campaign, such as "Brand Awareness," "Conversions," or "Traffic." |
adset_name | STRING | The name of the ad set or ad group within the campaign. |
adset_id | STRING | The unique identifier for the ad set or ad group. |
ad_name | STRING | The name of the individual ad within the ad set. |
ad_id | STRING | The unique identifier for the ad. |
cm360_placement_id | STRING | The unique identifier for the placement in Campaign Manager 360, if applicable. |
platform_placement | STRING | The specific placement of the ad on the platform, such as "Feed," "Stories," or "Explore." |
channel_grouping | STRING | The grouping of channels used in the campaign, such as "Social," "Display," or "Video." |
market_name | STRING | The market or geographic region where the campaign is targeted. |
audience_grouping | STRING | The audience segment targeted by the campaign, grouped by criteria like demographics, interests, or behavior. |
funnel_grouping | STRING | The stage in the marketing funnel targeted by the campaign, such as "Awareness," "Consideration," or "Conversion." |
custom_campaign_type | STRING | A custom classification of the campaign type, defined specifically for your analysis. |
ad_concept_grouping | STRING | The grouping of ad concepts used in the campaign, often used for creative testing. |
ad_format_grouping | STRING | The ad format grouping, such as "Video," "Image," or "Carousel." |
test_grouping | STRING | A custom grouping used for categorizing different tests or experiments within the campaign. |
custom_grouping_1 | STRING | An additional custom grouping for specific reporting needs. |
custom_grouping_2 | STRING | An additional custom grouping for specific reporting needs. |
custom_grouping_3 | STRING | An additional custom grouping for specific reporting needs. |
custom_grouping_4 | STRING | An additional custom grouping for specific reporting needs. |
video_views | FLOAT | The number of video views recorded for the ad. |
ad_spend | FLOAT | The total spend on the ad. |
clicks | FLOAT | The total number of clicks on the ad. |
impressions | FLOAT | The total number of impressions the ad received. |
viewable_impressions | FLOAT | The total number of viewable impressions according to industry standards. |
custom_dimension_1 | STRING | A custom dimension for specific reporting needs. |
custom_dimension_2 | STRING | A custom dimension for specific reporting needs. |
custom_dimension_3 | STRING | A custom dimension for specific reporting needs. |
custom_dimension_4 | STRING | A custom dimension for specific reporting needs. |
custom_dimension_5 | STRING | A custom dimension for specific reporting needs. |
ad_active_timeline | STRING | The timeline during which the ad was active. |
date_started | STRING | The date when the ad first started running. |
date_ended | STRING | The date when the ad stopped running. |
days_active | INTEGER | The total number of days the ad was active. |
ad_live | BOOLEAN | Indicates whether the ad is currently live. |
images | RECORD | A repeated field containing details about images used in the ad. |
ad_final_urls | RECORD | A repeated field containing details about final URLs used in the ad. |
ad_contents | RECORD | A repeated field containing details about ad content such as headlines, descriptions, and call-to-actions. |
ad_type | STRING | The type of ad, such as "Image," "Video," or "Carousel." |
count_videos | INTEGER | The total number of videos used in the ad. |
count_images | INTEGER | The total number of images used in the ad. |
ad_has_video_and_image | BOOLEAN | Indicates whether the ad contains both video and image content. |
conversions | RECORD | A repeated field containing details about conversions attributed to the ad. |
images.creative_no | INTEGER | The creative number or identifier used to distinguish different images used in the ad. |
images.creative_type | STRING | The type of creative, such as "Image," "Banner," etc. |
images.image_url | STRING | The URL of the image used in the ad. |
images.image_name | STRING | The name of the image file used in the ad. |
images.creative_size | STRING | The size of the image creative, typically specified in pixels (e.g., "300x250"). |
images.creative_height | STRING | The height of the image creative, specified in pixels. |
images.creative_width | STRING | The width of the image creative, specified in pixels. |
images.youtube_video_url | STRING | The URL of the associated YouTube video, if applicable. |
images.custom_image_dimension_1 | STRING | A custom dimension for specific image reporting needs. |
images.custom_image_dimension_2 | STRING | A custom dimension for specific image reporting needs. |
images.custom_image_dimension_3 | STRING | A custom dimension for specific image reporting needs. |
images.custom_image_dimension_4 | STRING | A custom dimension for specific image reporting needs. |
images.custom_image_dimension_5 | STRING | A custom dimension for specific image reporting needs. |
images.ad_spend | FLOAT | The total ad spend attributed to the image creative. |
images.impressions | FLOAT | The total number of impressions the image creative received. |
ad_final_urls.ad_final_urls | STRING | The final URLs that users are directed to after clicking on the ad. |
ad_final_urls.lifetime_impressions | FLOAT | The total number of impressions attributed to the final URL over the lifetime of the ad. |
ad_contents.descriptions | STRING | The descriptions used in the ad content. |
ad_contents.headlines | STRING | The headlines used in the ad content. |
ad_contents.call_to_actions | STRING | The calls to action (CTAs) used in the ad content. |
ad_contents.body_assets | STRING | The main body text or assets used in the ad content. |
ad_contents.lifetime_impressions | FLOAT | The total number of impressions attributed to the ad content over the lifetime of the ad. |
conversions.conversion_name | STRING | The name of the conversion event, such as "Purchase," "Sign-Up," etc. |
conversions.conversion_source | STRING | The source of the conversion, such as "TikTok Ads," "YouTube Ads," etc. |
conversions.conversion_group | STRING | The grouping or categorization of the conversion event, based on predefined categories like "Sales," "Leads," etc. |
conversions.source_conversion_name | STRING | The original name of the conversion as recorded in the source platform. |
conversions.conversion_value | FLOAT | The monetary value associated with the conversion event. |
conversions.conversions | FLOAT | The total number of conversions attributed to the ad. |
conversions.conversions_1_to_14_days | FLOAT | The number of conversions recorded in the first 1 to 14 days after the ad was shown. |
conversions.conversions_15_to_28_days | FLOAT | The number of conversions recorded between 15 to 28 days after the ad was shown. |
conversions.conversions_29_to_42_days | FLOAT | The number of conversions recorded between 29 to 42 days after the ad was shown. |
conversions.conversion_value_1_to_14_days | FLOAT | The monetary value of conversions recorded in the first 1 to 14 days after the ad was shown. |
conversions.conversion_value_15_to_28_days | FLOAT | The monetary value of conversions recorded between 15 to 28 days after the ad was shown. |
conversions.conversion_value_29_to_42_days | FLOAT | The monetary value of conversions recorded between 29 to 42 days after the ad was shown. |
conversions.benchmark_conversions | FLOAT | The benchmark number of conversions, based on similar campaigns within the account. |
conversions.benchmark_conversion_value | FLOAT | The benchmark conversion value, based on similar campaigns within the account. |