Celtra fields

  • Updated on Oct 6, 2025
  • Published on Aug 5, 2025
Prev Next

Supermetrics brings all your Celtra data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

93 metrics56 dimensions

ACCOUNT

campaign_performance__account_name
Field label Account name
Description Name of the account
Field type dimension
Data type string.text.value
campaign_performance__account_id
Field label Account ID
Description ID of the account
Field type dimension
Data type string.text.value

ACTION

campaign_performance__website_opens
Field label Website opens
Description The sum of `Website opens on screen` and `Video website opens`
Field type metric
Data type int.number.value
campaign_performance__app_store_opens
Field label App store opens
Description The number of times the user was led to the app store
Field type metric
Data type int.number.value

BRAND

campaign_performance__brand_name
Field label Brand name
Description The name of the brand/advertiser
Field type dimension
Data type string.text.value
campaign_performance__brand_id
Field label Brand ID
Description The ID of the brand/advertiser
Field type dimension
Data type string.text.value

CAMPAIGN

campaign_performance__campaign_name
Field label Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaign_performance__campaign_id
Field label Campaign ID
Description ID of the campaign
Field type dimension
Data type string.text.value

CREATIVE

campaign_performance__creative_name
Field label Creative name
Description The name of the creative
Field type dimension
Data type string.text.value
campaign_performance__creative_id
Field label Creative ID
Description The ID of the creative
Field type dimension
Data type string.text.value

DATASOURCE

dataSourceName
Field label Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

DISPLAY

campaign_performance__exposure_time
Field label Exposure time
Description The aggregate time (in seconds) in which some portion of the creative is displayed, as detectable in the current environment
Field type metric
Data type int.number.value
campaign_performance__impression_with_exposure_time
Field label Impressions with exposure time
Description The number of impressions where `Exposure time` is greater than zero
Field type metric
Data type int.number.value
campaign_performance__avg_exposure_time
Field label Avg. exposure time
Description The ratio of `Exposure time` to `Impressions with exposure time`
Field type metric
Data type float.number.ratio

ENGAGEMENT

campaign_performance__ad_engagements
Field label Ad engagements
Description 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
Field type metric
Data type int.number.value
campaign_performance__ad_engagements_rate
Field label Ad engagements rate
Description The ratio of `Ad engagements` to `Rendered impressions`
Field type metric
Data type float.number.ratio

FACEBOOK

campaign_performance__facebook_account_name
Field label Facebook account name
Description Name of the Facebook ad account
Field type dimension
Data type string.text.value
campaign_performance__facebook_account_id
Field label Facebook account ID
Description The unique ID of the Facebook account
Field type dimension
Data type string.text.value
campaign_performance__facebook_campaign_name
Field label Facebook campaign name
Description Name of the Facebook campaign
Field type dimension
Data type string.text.value
campaign_performance__facebook_campaign_id
Field label Facebook campaign ID
Description The unique ID of the Facebook campaign
Field type dimension
Data type string.text.value
campaign_performance__facebook_ad_set_name
Field label Facebook ad set name
Description Name of the Facebook ad set
Field type dimension
Data type string.text.value
campaign_performance__facebook_ad_set_id
Field label Facebook ad set ID
Description The unique ID of the Facebook ad set
Field type dimension
Data type string.text.value
campaign_performance__facebook_ad_name
Field label Facebook ad name
Description Name of the Facebook ad
Field type dimension
Data type string.text.value
campaign_performance__facebook_ad_id
Field label Facebook ad ID
Description The unique ID of the Facebook ad
Field type dimension
Data type string.text.value
campaign_performance__facebook_likes
Field label Facebook page likes
Description The number of page likes attributed to your ads
Field type metric
Data type int.number.value
campaign_performance__facebook_impressions
Field label Facebook impressions
Description The number of times ad seen on screen
Field type metric
Data type int.number.value
campaign_performance__facebook_clicks
Field label Facebook clicks
Description The number of clicks on your ads
Field type metric
Data type int.number.value
campaign_performance__facebook_post_engagements
Field label Facebook post engagements
Description The number of comments, clicks, shares, views etc
Field type metric
Data type int.number.value
campaign_performance__facebook_post_reactions
Field label Facebook post reactions
Description The number of reactions people had to your ads
Field type metric
Data type int.number.value
campaign_performance__facebook_page_engagements
Field label Facebook page engagements
Description The number of interactions with the page and its posts
Field type metric
Data type int.number.value
campaign_performance__facebook_link_clicks
Field label Facebook link clicks
Description The number of clicks on any area of the ad
Field type metric
Data type int.number.value
campaign_performance__facebook_video_fifteen_seconds_played
Field label Facebook video fifteen seconds played
Description The number of times video was played for an aggregate of at least 15 seconds, or for nearly its length, whichever happened first
Field type metric
Data type int.number.value
campaign_performance__facebook_first_quartile_video_views
Field label Facebook 1st quartile video views
Description The number of times video was played at 25% of its length, including watches that skipped to this point
Field type metric
Data type int.number.value
campaign_performance__facebook_midpoint_quartile_video_views
Field label Facebook 2nd quartile video views
Description The number of times video was played at 50% of its length, including watches that skipped to this point
Field type metric
Data type int.number.value
campaign_performance__facebook_third_quartile_video_views
Field label Facebook 3rd quartile video views
Description The number of times video was played at 75% of its length, including watches that skipped to this point
Field type metric
Data type int.number.value
campaign_performance__facebook_completions
Field label Facebook completions
Description The number of times video was played at 100% of its length, including watches that skipped to this point
Field type metric
Data type int.number.value
campaign_performance__facebook_desktop_app_installs
Field label Facebook desktop app installs
Description The number of desktop app installs
Field type metric
Data type int.number.value
campaign_performance__facebook_omni_app_installs
Field label Facebook app installs
Description The number of omni app installs
Field type metric
Data type int.number.value
campaign_performance__facebook_desktop_app_uses
Field label Facebook desktop app uses
Description The number of desktop app uses
Field type metric
Data type int.number.value
campaign_performance__facebook_post_comments
Field label Facebook post comments
Description The number of post comments
Field type metric
Data type int.number.value
campaign_performance__facebook_landing_page_views
Field label Facebook landing page views
Description The number of landing page views
Field type metric
Data type int.number.value
campaign_performance__facebook_mobile_app_installs
Field label Facebook mobile app installs
Description The number of mobile app installs
Field type metric
Data type int.number.value
campaign_performance__facebook_outbound_clicks
Field label Facebook outbound clicks
Description The number of facebook outbound clicks
Field type metric
Data type int.number.value
campaign_performance__facebook_post_shares
Field label Facebook post shares
Description The number of facebook post shares
Field type metric
Data type int.number.value
campaign_performance__facebook_app_custom_events
Field label Facebook app custom events
Description The number of facebook app custom events
Field type metric
Data type int.number.value

IMPRESSIONS

campaign_performance__requested_impressions
Field label Requested impressions
Description The number of ad requests received by Celtra
Field type metric
Data type int.number.value
campaign_performance__loaded_impressions
Field label Loaded impressions
Description 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
Field type metric
Data type int.number.value
campaign_performance__rendered_impressions
Field label Rendered impressions
Description The number of `Loaded impressions` in which the creative content appeared (best-effort, optimistic) and started playing (if animated or video)
Field type metric
Data type int.number.value
campaign_performance__creative_load_attempts
Field label Creative load attempts
Description The number of ad requests received by Celtra with potential to be loaded
Field type metric
Data type int.number.value
campaign_performance__loaded_rate
Field label Load rate
Description The ratio of `Loaded impressions` to `Creative load attempts`
Field type metric
Data type float.number.ratio
campaign_performance__render_rate
Field label Render rate
Description The ratio of `Rendered impressions` to `Loaded impressions`
Field type metric
Data type float.number.ratio

INLINE AND 360 VIDEO

campaign_performance__inline_video_first
Field label Inline video first quarter views
Description The number of `Inline video starts` in which the inline video played through the first `Quarter marker` of the video
Field type metric
Data type int.number.value
campaign_performance__inline_video_second
Field label Inline video second quarter views
Description 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
Field type metric
Data type int.number.value
campaign_performance__inline_video_third
Field label Inline video third quarter views
Description The number of `Inline video starts` in which the inline video played through the third `Quarter marker` of the video
Field type metric
Data type int.number.value
campaign_performance__inline_video_fourth
Field label Inline video fourth quarter views
Description The number of `Inline video starts` in which the video played through the fourth `Quarter marker` of the video
Field type metric
Data type int.number.value

PLACEMENT

campaign_performance__placement_name
Field label Placement name
Description The name of the placement in which the creative was trafficked
Field type dimension
Data type string.text.value
campaign_performance__placement_id
Field label Placement ID
Description The ID of the placement in which the creative was trafficked
Field type dimension
Data type string.text.value

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

SNAPCHAT

campaign_performance__snapchat_account_name
Field label Snapchat account name
Description The name of the Snapchat account
Field type dimension
Data type string.text.value
campaign_performance__snapchat_ad_name
Field label Snapchat ad name
Description The name of the Snapchat ad
Field type dimension
Data type string.text.value
campaign_performance__snapchat_ad_id
Field label Snapchat ad ID
Description The id of the Snapchat ad
Field type dimension
Data type string.text.value
campaign_performance__snapchat_creative_id
Field label Snapchat creative ID
Description The id of the Snapchat creative
Field type dimension
Data type string.text.value
campaign_performance__snapchat_impressions
Field label Snapchat impressions
Description The number of Snapchat impressions
Field type metric
Data type int.number.value
campaign_performance__snapchat_video_views
Field label Snapchat video views
Description 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
Field type metric
Data type int.number.value
campaign_performance__snapchat_video_view_rate
Field label Snapchat video view rate
Description The ratio of `Snapchat video views` to `Snapchat impressions`
Field type metric
Data type float.number.ratio
campaign_performance__snapchat_swipe_ups
Field label Snapchat swipe ups
Description The number of Snapchat swipe ups
Field type metric
Data type int.number.value
campaign_performance__snapchat_swipe_up_rate
Field label Snapchat swipe up rate
Description The ratio of `Snapchat swipe ups` to `Snapchat impressions`
Field type metric
Data type float.number.ratio
campaign_performance__snapchat_screen_time
Field label Snapchat screen time
Description The time spent on Top Snap ad (in milliseconds)
Field type metric
Data type int.number.value
campaign_performance__snapchat_avg_screen_time
Field label Snapchat avg. screen time
Description The ratio of `Snapchat screen time` to `Snapchat impressions`. The average time spent on Top Snap ad (in milliseconds)
Field type metric
Data type float.number.ratio
campaign_performance__snapchat_first_quartile_views
Field label Snapchat 25% quartile
Description The number of `Snapchat video views` to 25%
Field type metric
Data type int.number.value
campaign_performance__snapchat_midpoint_quartile_views
Field label Snapchat 50% quartile
Description The number of `Snapchat video views` to 50%
Field type metric
Data type int.number.value
campaign_performance__snapchat_third_quartile_views
Field label Snapchat 75% quartile
Description The number of `Snapchat video views` to 75%
Field type metric
Data type int.number.value
campaign_performance__snapchat_completions
Field label Snapchat completions
Description The number of `Snapchat video views` to completion
Field type metric
Data type int.number.value
campaign_performance__snapchat_first_quartile_rate
Field label Snapchat 25% quartile rate
Description The ratio of `Snapchat 25% quartile` to `Snapchat impressions`
Field type metric
Data type float.number.ratio
campaign_performance__snapchat_midpoint_quartile_rate
Field label Snapchat 50% quartile rate
Description The ratio of `Snapchat 50% quartile` to `Snapchat impressions`
Field type metric
Data type float.number.ratio
campaign_performance__snapchat_third_quartile_rate
Field label Snapchat 75% quartile rate
Description The ratio of `Snapchat 75% quartile` to `Snapchat impressions`
Field type metric
Data type float.number.ratio
campaign_performance__snapchat_video_completion_rate
Field label Snapchat video completion rate
Description The ratio of `Snapchat completions` to `Snapchat impressions`
Field type metric
Data type float.number.ratio
campaign_performance__snapchat_spend
Field label Snapchat spend
Description The amount spent on Snapchat (in micro-currency)
Field type metric
Data type int.number.value
campaign_performance__snapchat_uniques
Field label Snapchat uniques
Description The number of unique impressions. Can only be provided in combination with `Snapchat ad ID` dimension
Field type metric
Data type int.number.value
campaign_performance__snapchat_attachment_uniques
Field label Snapchat attachment uniques
Description The number of unique attachment impressions. Can only be provided in combination with `Snapchat ad ID` dimension. Available for any ad type with attachment
Field type metric
Data type int.number.value
campaign_performance__snapchat_installs
Field label Snapchat installs
Description The number of app installs. Available only for ads with APP_INSTALL attachment
Field type metric
Data type int.number.value
campaign_performance__snapchat_ios_installs
Field label Snapchat IOS installs
Description The number of iOS app installs. Available only for ads with APP_INSTALL attachment
Field type metric
Data type int.number.value
campaign_performance__snapchat_attachment_first_quartile_views
Field label Snapchat 25% attachment quartile
Description The number of long form video views to 25%. Available only for ads with LONGFORM_VIDEO attachment
Field type metric
Data type int.number.value
campaign_performance__snapchat_attachment_midpoint_quartile_views
Field label Snapchat 50% attachment quartile
Description The number of long form video views to 50%. Available only for ads with LONGFORM_VIDEO attachment
Field type metric
Data type int.number.value
campaign_performance__snapchat_attachment_third_quartile_views
Field label Snapchat 75% attachment quartile
Description The number of long form video views to 75%. Available only for ads with LONGFORM_VIDEO attachment
Field type metric
Data type int.number.value
campaign_performance__snapchat_attachment_completions
Field label Snapchat attachment completions
Description The number of long form video views to completion. Available only for ads with LONGFORM_VIDEO attachment
Field type metric
Data type int.number.value

TARGETING

campaign_performance__platform
Field label Platform
Description The platform on which the creative was loaded
Field type dimension
Data type string.text.value
campaign_performance__device_type
Field label Device type
Description The device type that was recorded in an impression
Field type dimension
Data type string.text.value
campaign_performance__country
Field label Country
Description The country name associated to countryCode
Field type dimension
Data type string.geo.country
campaign_performance__state
Field label State/province
Description The state or province name associated to principalSubdivisionCode
Field type dimension
Data type string.text.value

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
campaign_performance__year
Field label Year
Field type dimension
Data type string.time.year
campaign_performance__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
campaign_performance__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
campaign_performance__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
campaign_performance__month
Field label Month
Field type dimension
Data type string.time.month
campaign_performance__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
campaign_performance__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
campaign_performance__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
campaign_performance__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
campaign_performance__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
campaign_performance__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
campaign_performance__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
campaign_performance__date
Field label Date
Field type dimension
Data type string.time.date
campaign_performance__atom
Field label Datetime
Field type dimension
Data type string.time.datetime
campaign_performance__date_utc
Field label Date (UTC)
Description The date in UTC timezone presented in 'yyyy-mm-dd' format
Field type dimension
Data type string.time.date

TWITTER

campaign_performance__twitter_account_id
Field label Twitter account ID
Description Twitter account ID
Field type dimension
Data type string.text.value
campaign_performance__twitter_ad_group_id
Field label Twitter ad group ID
Description Twitter ad group ID
Field type dimension
Data type string.text.value
campaign_performance__twitter_ad_id
Field label Twitter ad ID
Description Twitter ad ID
Field type dimension
Data type string.text.value
campaign_performance__twitter_impressions
Field label Twitter impressions
Description The number of Twitter ad impressions
Field type metric
Data type int.number.value
campaign_performance__twitter_engagements
Field label Twitter engagements
Description The number of Twitter ad engagements
Field type metric
Data type int.number.value
campaign_performance__twitter_clicks
Field label Twitter clicks
Description The number of Twitter ad clicks
Field type metric
Data type int.number.value
campaign_performance__twitter_retweets
Field label Twitter retweets
Description The number of Twitter ad retweets
Field type metric
Data type int.number.value
campaign_performance__twitter_replies
Field label Twitter replies
Description The number of Twitter ad replies
Field type metric
Data type int.number.value
campaign_performance__twitter_follows
Field label Twitter follows
Description The number of Twitter follows
Field type metric
Data type int.number.value
campaign_performance__twitter_likes
Field label Twitter likes
Description The number of Twitter ad likes
Field type metric
Data type int.number.value
campaign_performance__twitter_app_clicks
Field label Twitter app clicks
Description The number of Twitter app clicks
Field type metric
Data type int.number.value
campaign_performance__twitter_video_views
Field label Twitter video views
Description The number of Twitter ad video views
Field type metric
Data type int.number.value
campaign_performance__twitter_video_starts
Field label Twitter video starts
Description The number of Twitter ad video starts
Field type metric
Data type int.number.value
campaign_performance__twitter_first_quartile_views
Field label Twitter 1st quartile views
Description The number of Twitter ad video first quartile views
Field type metric
Data type int.number.value
campaign_performance__twitter_midpoint_quartile_views
Field label Twitter 2nd quartile views
Description The number of Twitter ad video midpoint quartile views
Field type metric
Data type int.number.value
campaign_performance__twitter_third_quartile_views
Field label Twitter 3r quartile views
Description The number of Twitter ad video first quartile views
Field type metric
Data type int.number.value
campaign_performance__twitter_video_completions
Field label Twitter video completions
Description The number of Twitter ad video completions
Field type metric
Data type int.number.value

VIDEO

campaign_performance__requested_video_impressions
Field label Requested video impressions
Description The number of ad requests for video creatives received by Celtra
Field type metric
Data type int.number.value
campaign_performance__video_starts
Field label Video starts
Description The number of times a video was loaded and playback began
Field type metric
Data type int.number.value
campaign_performance__video_clicks
Field label Video clicks
Description The number of `Video starts` in which a click occurred
Field type metric
Data type int.number.value
campaign_performance__avg_video_play_time
Field label Avg. video play time
Description The ratio of `Video play time` to `Video starts`. The average amount of time (in seconds) a video has played through
Field type metric
Data type float.number.ratio
campaign_performance__video_play_time
Field label Video play time
Description The aggregate non-overlapping time (in seconds) a video has played through
Field type metric
Data type int.number.value
campaign_performance__video_consumable_seconds
Field label Video consumable seconds
Description The product of `Video starts` and `Video length`
Field type metric
Data type int.number.value
campaign_performance__video_consumption_rate
Field label Video consumption rate
Description The ratio of `Video play time` to `Video consumable seconds`. The average percent of video consumed
Field type metric
Data type float.number.ratio
campaign_performance__first_quartile_video_completes
Field label 1st quartile video completes
Description The number of `Video starts` in which the video played for at least 25% of the duration
Field type metric
Data type int.number.value
campaign_performance__mid_quartile_video_completes
Field label 2nd quartile video completes
Description The number of `Video starts` in which the video played for at least 50% of the duration
Field type metric
Data type int.number.value
campaign_performance__third_quartile_video_completes
Field label 3rd quartile video completes
Description The number of `Video starts` in which the video played for at least 75% of the duration
Field type metric
Data type int.number.value
campaign_performance__video_completes
Field label Video completes
Description The number of `Video starts` in which the video was fully played
Field type metric
Data type int.number.value
campaign_performance__video_completion_rate
Field label Video completion rate
Description The ratio of `Video completes` to `Video starts`. The percentage of Video starts in which the video was fully played
Field type metric
Data type float.number.ratio
campaign_performance__end_card_engagements
Field label End card engagements
Description The number of impressions where the user interacted with the end card of the Video format
Field type metric
Data type int.number.value
campaign_performance__website_opens_on_video
Field label Video website opens
Description The number of times the user was led to an external website, for Video
Field type metric
Data type int.number.value
campaign_performance__video_clicks_rate
Field label Video CTR
Description The ratio of `Video clicks` to `Video starts`
Field type metric
Data type float.number.ratio
campaign_performance__end_card_clickthroughs
Field label End card clickthroughs
Description The number of `Video completes` in which a clickthrough occurred on the end card
Field type metric
Data type int.number.value
campaign_performance__end_card_ctr
Field label End card CTR
Description The ratio of `End card clickthroughs` to `Video completes`
Field type metric
Data type float.number.ratio