Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time | Year | campaign_performance_year | dim | |
| Year of week (Sun-Sat) | campaign_performance_year_of_week | dim | ||
| Year of week (Mon-Sun) | campaign_performance_year_of_week_iso | dim | ||
| Year & month | campaign_performance_year_month | dim | ||
| Month | campaign_performance_month | dim | ||
| Year & week (Sun-Sat) | campaign_performance_year_week | dim | ||
| Year & week (Mon-Sun) | campaign_performance_year_week_iso | dim | ||
| Week (Sun-Sat) | campaign_performance_week | dim | ||
| Week (Mon-Sun) | campaign_performance_week_iso | dim | ||
| Day of month | campaign_performance_day_of_month | dim | ||
| Day of week (Sun-Sat) | campaign_performance_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | campaign_performance_day_of_week_name_iso | dim | ||
| Date | campaign_performance_date | dim | ||
| Datetime | campaign_performance_atom | dim | ||
| Account | Account name | campaign_performance_account_name | dim | Name of the account. |
| Account ID | campaign_performance_account_id | dim | ID of the account. | |
| Brand | Brand name | campaign_performance_brand_name | dim | The name of the brand/advertiser. |
| Brand ID | campaign_performance_brand_id | dim | The ID of the brand/advertiser. | |
| Campaign | Campaign name | campaign_performance_campaign_name | dim | Name of the campaign. |
| Campaign ID | campaign_performance_campaign_id | dim | ID of the campaign. | |
| Creative | Creative name | campaign_performance_creative_name | dim | The name of the creative. |
| Creative ID | campaign_performance_creative_id | dim | The ID of the creative. | |
| Placement | Placement name | campaign_performance_placement_name | dim | The name of the placement in which the creative was trafficked. |
| Placement ID | campaign_performance_placement_id | dim | The ID of the placement in which the creative was trafficked. | |
| Time | Date (UTC) | campaign_performance_date_utc | dim | The date in UTC timezone presented in 'yyyy-mm-dd' format. |
| Targeting | Platform | campaign_performance_platform | dim | The platform on which the creative was loaded. |
| Device type | campaign_performance_device_type | dim | The device type that was recorded in an impression. | |
| Country | campaign_performance_country | dim | The country name associated to countryCode. | |
| State/province | campaign_performance_state | dim | The state or province name associated to principalSubdivisionCode. | |
| Facebook account name | campaign_performance_facebook_account_name | dim | Name of the Facebook ad account. | |
| Facebook account ID | campaign_performance_facebook_account_id | dim | The unique ID of the Facebook account. | |
| Facebook campaign name | campaign_performance_facebook_campaign_name | dim | Name of the Facebook campaign. | |
| Facebook campaign ID | campaign_performance_facebook_campaign_id | dim | The unique ID of the Facebook campaign. | |
| Facebook ad set name | campaign_performance_facebook_ad_set_name | dim | Name of the Facebook ad set. | |
| Facebook ad set ID | campaign_performance_facebook_ad_set_id | dim | The unique ID of the Facebook ad set. | |
| Facebook ad name | campaign_performance_facebook_ad_name | dim | Name of the Facebook ad. | |
| Facebook ad ID | campaign_performance_facebook_ad_id | dim | The unique ID of the Facebook ad. | |
| Twitter account ID | campaign_performance_twitter_account_id | dim | Twitter account ID. | |
| Twitter ad group ID | campaign_performance_twitter_ad_group_id | dim | Twitter ad group ID. | |
| Twitter ad ID | campaign_performance_twitter_ad_id | dim | Twitter ad ID. | |
| Snapchat | Snapchat account name | campaign_performance_snapchat_account_name | dim | The name of the Snapchat account. |
| Snapchat ad name | campaign_performance_snapchat_ad_name | dim | The name of the Snapchat ad. | |
| Snapchat ad ID | campaign_performance_snapchat_ad_id | dim | The id of the Snapchat ad. | |
| Snapchat creative ID | campaign_performance_snapchat_creative_id | dim | The id of the Snapchat creative. | |
| Requested impressions | campaign_performance_requested_impressions | met | The number of ad requests received by Celtra. | |
| Loaded impressions | campaign_performance_loaded_impressions | met | The number of times where the creative was loaded to the point where it could be displayed. The Base and first page of the banner unit have loaded and the SDK must have initialized. | |
| Rendered impressions | campaign_performance_rendered_impressions | met | The number of `Loaded impressions` in which the creative content appeared (best-effort, optimistic) and started playing (if animated or video). | |
| Creative load attempts | campaign_performance_creative_load_attempts | met | The number of ad requests received by Celtra with potential to be loaded. | |
| Load rate | campaign_performance_loaded_rate | met | The ratio of `Loaded impressions` to `Creative load attempts`. | |
| Render rate | campaign_performance_render_rate | met | The ratio of `Rendered impressions` to `Loaded impressions`. | |
| Exposure time | campaign_performance_exposure_time | met | The aggregate time (in seconds) in which some portion of the creative is displayed, as detectable in the current environment. | |
| Impressions with exposure time | campaign_performance_impression_with_exposure_time | met | The number of impressions where `Exposure time` is greater than zero. | |
| Avg. exposure time | campaign_performance_avg_exposure_time | met | The ratio of `Exposure time` to `Impressions with exposure time`. | |
| Ad engagements | campaign_performance_ad_engagements | met | The number of impressions where the user interacted with the creative. For any ad format that can be closed or dismissed, doing so is not considered an interaction. This metric may be lower than expansions if the creative was configured to expand automatically. | |
| Ad engagements rate | campaign_performance_ad_engagements_rate | met | The ratio of `Ad engagements` to `Rendered impressions`. | |
| Website opens | campaign_performance_website_opens | met | The sum of `Website opens on screen` and `Video website opens`. | |
| App store opens | campaign_performance_app_store_opens | met | The number of times the user was led to the app store. | |
| Requested video impressions | campaign_performance_requested_video_impressions | met | The number of ad requests for video creatives received by Celtra. | |
| Video starts | campaign_performance_video_starts | met | The number of times a video was loaded and playback began. | |
| Video clicks | campaign_performance_video_clicks | met | The number of `Video starts` in which a click occurred. | |
| Avg. video play time | campaign_performance_avg_video_play_time | met | The ratio of `Video play time` to `Video starts`. The average amount of time (in seconds) a video has played through. | |
| Video play time | campaign_performance_video_play_time | met | The aggregate non-overlapping time (in seconds) a video has played through. | |
| Video consumable seconds | campaign_performance_video_consumable_seconds | met | The product of `Video starts` and `Video length`. | |
| Video consumption rate | campaign_performance_video_consumption_rate | met | The ratio of `Video play time` to `Video consumable seconds`. The average percent of video consumed. | |
| 1st quartile video completes | campaign_performance_first_quartile_video_completes | met | The number of `Video starts` in which the video played for at least 25% of the duration. | |
| 2nd quartile video completes | campaign_performance_mid_quartile_video_completes | met | The number of `Video starts` in which the video played for at least 50% of the duration. | |
| 3rd quartile video completes | campaign_performance_third_quartile_video_completes | met | The number of `Video starts` in which the video played for at least 75% of the duration. | |
| Video completes | campaign_performance_video_completes | met | The number of `Video starts` in which the video was fully played. | |
| Video completion rate | campaign_performance_video_completion_rate | met | The ratio of `Video completes` to `Video starts`. The percentage of Video starts in which the video was fully played. | |
| End card engagements | campaign_performance_end_card_engagements | met | The number of impressions where the user interacted with the end card of the Video format. | |
| Video website opens | campaign_performance_website_opens_on_video | met | The number of times the user was led to an external website, for Video. | |
| Video CTR | campaign_performance_video_clicks_rate | met | The ratio of `Video clicks` to `Video starts`. | |
| End card clickthroughs | campaign_performance_end_card_clickthroughs | met | The number of `Video completes` in which a clickthrough occurred on the end card. | |
| End card CTR | campaign_performance_end_card_ctr | met | The ratio of `End card clickthroughs` to `Video completes`. | |
| Inline video first quarter views | campaign_performance_inline_video_first | met | The number of `Inline video starts` in which the inline video played through the first `Quarter marker` of the video. | |
| Inline video second quarter views | campaign_performance_inline_video_second | met | The number of times inline video played through a specific 'second marker' of the video, unique per Video play. Break down by the `Second marker` dimension to display per-second video attention. | |
| Inline video third quarter views | campaign_performance_inline_video_third | met | The number of `Inline video starts` in which the inline video played through the third `Quarter marker` of the video. | |
| Inline video fourth quarter views | campaign_performance_inline_video_fourth | met | The number of `Inline video starts` in which the video played through the fourth `Quarter marker` of the video. | |
| Facebook page likes | campaign_performance_facebook_likes | met | The number of page likes attributed to your ads. | |
| Facebook impressions | campaign_performance_facebook_impressions | met | The number of times ad seen on screen. | |
| Facebook clicks | campaign_performance_facebook_clicks | met | The number of clicks on your ads. | |
| Facebook post engagements | campaign_performance_facebook_post_engagements | met | The number of comments, clicks, shares, views etc. | |
| Facebook post reactions | campaign_performance_facebook_post_reactions | met | The number of reactions people had to your ads. | |
| Facebook page engagements | campaign_performance_facebook_page_engagements | met | The number of interactions with the page and its posts. | |
| Facebook link clicks | campaign_performance_facebook_link_clicks | met | The number of clicks on any area of the ad. | |
| Facebook video fifteen seconds played | campaign_performance_facebook_video_fifteen_seconds_played | met | The number of times video was played for an aggregate of at least 15 seconds, or for nearly its length, whichever happened first. | |
| Facebook 1st quartile video views | campaign_performance_facebook_first_quartile_video_views | met | The number of times video was played at 25% of its length, including watches that skipped to this point. | |
| Facebook 2nd quartile video views | campaign_performance_facebook_midpoint_quartile_video_views | met | The number of times video was played at 50% of its length, including watches that skipped to this point. | |
| Facebook 3rd quartile video views | campaign_performance_facebook_third_quartile_video_views | met | The number of times video was played at 75% of its length, including watches that skipped to this point. | |
| Facebook completions | campaign_performance_facebook_completions | met | The number of times video was played at 100% of its length, including watches that skipped to this point. | |
| Facebook desktop app installs | campaign_performance_facebook_desktop_app_installs | met | The number of desktop app installs. | |
| Facebook app installs | campaign_performance_facebook_omni_app_installs | met | The number of omni app installs. | |
| Facebook desktop app uses | campaign_performance_facebook_desktop_app_uses | met | The number of desktop app uses. | |
| Facebook post comments | campaign_performance_facebook_post_comments | met | The number of post comments. | |
| Facebook landing page views | campaign_performance_facebook_landing_page_views | met | The number of landing page views. | |
| Facebook mobile app installs | campaign_performance_facebook_mobile_app_installs | met | The number of mobile app installs. | |
| Facebook outbound clicks | campaign_performance_facebook_outbound_clicks | met | The number of facebook outbound clicks. | |
| Facebook post shares | campaign_performance_facebook_post_shares | met | The number of facebook post shares. | |
| Facebook app custom events | campaign_performance_facebook_app_custom_events | met | The number of facebook app custom events. | |
| Twitter impressions | campaign_performance_twitter_impressions | met | The number of Twitter ad impressions. | |
| Twitter engagements | campaign_performance_twitter_engagements | met | The number of Twitter ad engagements. | |
| Twitter clicks | campaign_performance_twitter_clicks | met | The number of Twitter ad clicks. | |
| Twitter retweets | campaign_performance_twitter_retweets | met | The number of Twitter ad retweets. | |
| Twitter replies | campaign_performance_twitter_replies | met | The number of Twitter ad replies. | |
| Twitter follows | campaign_performance_twitter_follows | met | The number of Twitter follows. | |
| Twitter likes | campaign_performance_twitter_likes | met | The number of Twitter ad likes. | |
| Twitter app clicks | campaign_performance_twitter_app_clicks | met | The number of Twitter app clicks. | |
| Twitter video views | campaign_performance_twitter_video_views | met | The number of Twitter ad video views. | |
| Twitter video starts | campaign_performance_twitter_video_starts | met | The number of Twitter ad video starts. | |
| Twitter 1st quartile views | campaign_performance_twitter_first_quartile_views | met | The number of Twitter ad video first quartile views. | |
| Twitter 2nd quartile views | campaign_performance_twitter_midpoint_quartile_views | met | The number of Twitter ad video midpoint quartile views. | |
| Twitter 3r quartile views | campaign_performance_twitter_third_quartile_views | met | The number of Twitter ad video first quartile views. | |
| Twitter video completions | campaign_performance_twitter_video_completions | met | The number of Twitter ad video completions. | |
| Snapchat impressions | campaign_performance_snapchat_impressions | met | The number of Snapchat impressions. | |
| Snapchat video views | campaign_performance_snapchat_video_views | met | The number of Snapchat impressions that meet the qualifying video view criteria of at least 2 seconds of consecutive watch time or a swipe up action on the Top Snap. | |
| Snapchat video view rate | campaign_performance_snapchat_video_view_rate | met | The ratio of `Snapchat video views` to `Snapchat impressions`. | |
| Snapchat swipe ups | campaign_performance_snapchat_swipe_ups | met | The number of Snapchat swipe ups. | |
| Snapchat swipe up rate | campaign_performance_snapchat_swipe_up_rate | met | The ratio of `Snapchat swipe ups` to `Snapchat impressions`. | |
| Snapchat screen time | campaign_performance_snapchat_screen_time | met | The time spent on Top Snap ad (in milliseconds). | |
| Snapchat avg. screen time | campaign_performance_snapchat_avg_screen_time | met | The ratio of `Snapchat screen time` to `Snapchat impressions`. The average time spent on Top Snap ad (in milliseconds). | |
| Snapchat 25% quartile | campaign_performance_snapchat_first_quartile_views | met | The number of `Snapchat video views` to 25%. | |
| Snapchat 50% quartile | campaign_performance_snapchat_midpoint_quartile_views | met | The number of `Snapchat video views` to 50%. | |
| Snapchat 75% quartile | campaign_performance_snapchat_third_quartile_views | met | The number of `Snapchat video views` to 75%. | |
| Snapchat completions | campaign_performance_snapchat_completions | met | The number of `Snapchat video views` to completion. | |
| Snapchat 25% quartile rate | campaign_performance_snapchat_first_quartile_rate | met | The ratio of `Snapchat 25% quartile` to `Snapchat impressions`. | |
| Snapchat 50% quartile rate | campaign_performance_snapchat_midpoint_quartile_rate | met | The ratio of `Snapchat 50% quartile` to `Snapchat impressions`. | |
| Snapchat 75% quartile rate | campaign_performance_snapchat_third_quartile_rate | met | The ratio of `Snapchat 75% quartile` to `Snapchat impressions`. | |
| Snapchat video completion rate | campaign_performance_snapchat_video_completion_rate | met | The ratio of `Snapchat completions` to `Snapchat impressions`. | |
| Snapchat spend | campaign_performance_snapchat_spend | met | The amount spent on Snapchat (in micro-currency). | |
| Snapchat uniques | campaign_performance_snapchat_uniques | met | The number of unique impressions. Can only be provided in combination with `Snapchat ad ID` dimension. | |
| Snapchat attachment uniques | campaign_performance_snapchat_attachment_uniques | met | The number of unique attachment impressions. Can only be provided in combination with `Snapchat ad ID` dimension. Available for any ad type with attachment. | |
| Snapchat installs | campaign_performance_snapchat_installs | met | The number of app installs. Available only for ads with APP_INSTALL attachment. | |
| Snapchat IOS installs | campaign_performance_snapchat_ios_installs | met | The number of iOS app installs. Available only for ads with APP_INSTALL attachment. | |
| Snapchat 25% attachment quartile | campaign_performance_snapchat_attachment_first_quartile_views | met | The number of long form video views to 25%. Available only for ads with LONGFORM_VIDEO attachment. | |
| Snapchat 50% attachment quartile | campaign_performance_snapchat_attachment_midpoint_quartile_views | met | The number of long form video views to 50%. Available only for ads with LONGFORM_VIDEO attachment. | |
| Snapchat 75% attachment quartile | campaign_performance_snapchat_attachment_third_quartile_views | met | The number of long form video views to 75%. Available only for ads with LONGFORM_VIDEO attachment. | |
| Snapchat attachment completions | campaign_performance_snapchat_attachment_completions | met | The number of long form video views to completion. Available only for ads with LONGFORM_VIDEO attachment. |