Celtra data warehouse table groups

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

Table: CAMPAIGN

campaign_performance__account_id
Display name Account ID
Description ID of the account
Field type dimension
Data type string.text.value
campaign_performance__account_name
Display name Account name
Description Name of the account
Field type dimension
Data type string.text.value
campaign_performance__ad_engagements
Display name 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__app_store_opens
Display name App store opens
Description The number of times the user was led to the app store
Field type metric
Data type int.number.value
campaign_performance__brand_id
Display name Brand ID
Description The ID of the brand/advertiser
Field type dimension
Data type string.text.value
campaign_performance__brand_name
Display name Brand name
Description The name of the brand/advertiser
Field type dimension
Data type string.text.value
campaign_performance__campaign_id
Display name Campaign ID
Description ID of the campaign
Field type dimension
Data type string.text.value
campaign_performance__campaign_name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaign_performance__country
Display name Country
Description The country name associated to countryCode
Field type dimension
Data type string.geo.country
campaign_performance__creative_id
Display name Creative ID
Description The ID of the creative
Field type dimension
Data type string.text.value
campaign_performance__creative_load_attempts
Display name 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__creative_name
Display name Creative name
Description The name of the creative
Field type dimension
Data type string.text.value
campaign_performance__date
Display name Date
Field type dimension
Data type string.time.date
campaign_performance__device_type
Display name Device type
Description The device type that was recorded in an impression
Field type dimension
Data type string.text.value
campaign_performance__end_card_clickthroughs
Display name 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_engagements
Display name 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__exposure_time
Display name 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__first_quartile_video_completes
Display name 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__impression_with_exposure_time
Display name 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__inline_video_first
Display name 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_fourth
Display name 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
campaign_performance__inline_video_second
Display name 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
Display name 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__loaded_impressions
Display name 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__mid_quartile_video_completes
Display name 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__placement_id
Display name Placement ID
Description The ID of the placement in which the creative was trafficked
Field type dimension
Data type string.text.value
campaign_performance__placement_name
Display name Placement name
Description The name of the placement in which the creative was trafficked
Field type dimension
Data type string.text.value
campaign_performance__platform
Display name Platform
Description The platform on which the creative was loaded
Field type dimension
Data type string.text.value
campaign_performance__rendered_impressions
Display name 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__requested_impressions
Display name Requested impressions
Description The number of ad requests received by Celtra
Field type metric
Data type int.number.value
campaign_performance__requested_video_impressions
Display name 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__state
Display name State/province
Description The state or province name associated to principalSubdivisionCode
Field type dimension
Data type string.text.value
campaign_performance__third_quartile_video_completes
Display name 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_clicks
Display name Video clicks
Description The number of `Video starts` in which a click occurred
Field type metric
Data type int.number.value
campaign_performance__video_completes
Display name 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_consumable_seconds
Display name Video consumable seconds
Description The product of `Video starts` and `Video length`
Field type metric
Data type int.number.value
campaign_performance__video_play_time
Display name 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_starts
Display name Video starts
Description The number of times a video was loaded and playback began
Field type metric
Data type int.number.value
campaign_performance__website_opens
Display name Website opens
Description The sum of `Website opens on screen` and `Video website opens`
Field type metric
Data type int.number.value
campaign_performance__website_opens_on_video
Display name 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
dataSourceName
Display name 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

Table: FACEBOOK

campaign_performance__account_id
Display name Account ID
Description ID of the account
Field type dimension
Data type string.text.value
campaign_performance__account_name
Display name Account name
Description Name of the account
Field type dimension
Data type string.text.value
campaign_performance__brand_id
Display name Brand ID
Description The ID of the brand/advertiser
Field type dimension
Data type string.text.value
campaign_performance__brand_name
Display name Brand name
Description The name of the brand/advertiser
Field type dimension
Data type string.text.value
campaign_performance__campaign_id
Display name Campaign ID
Description ID of the campaign
Field type dimension
Data type string.text.value
campaign_performance__campaign_name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaign_performance__creative_id
Display name Creative ID
Description The ID of the creative
Field type dimension
Data type string.text.value
campaign_performance__creative_name
Display name Creative name
Description The name of the creative
Field type dimension
Data type string.text.value
campaign_performance__date
Display name Date
Field type dimension
Data type string.time.date
campaign_performance__facebook_account_id
Display name Facebook account ID
Description The unique ID of the Facebook account
Field type dimension
Data type string.text.value
campaign_performance__facebook_account_name
Display name Facebook account name
Description Name of the Facebook ad account
Field type dimension
Data type string.text.value
campaign_performance__facebook_ad_id
Display name Facebook ad ID
Description The unique ID of the Facebook ad
Field type dimension
Data type string.text.value
campaign_performance__facebook_ad_name
Display name Facebook ad name
Description Name of the Facebook ad
Field type dimension
Data type string.text.value
campaign_performance__facebook_ad_set_id
Display name 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_set_name
Display name Facebook ad set name
Description Name of the Facebook ad set
Field type dimension
Data type string.text.value
campaign_performance__facebook_app_custom_events
Display name Facebook app custom events
Description The number of facebook app custom events
Field type metric
Data type int.number.value
campaign_performance__facebook_campaign_id
Display name Facebook campaign ID
Description The unique ID of the Facebook campaign
Field type dimension
Data type string.text.value
campaign_performance__facebook_campaign_name
Display name Facebook campaign name
Description Name of the Facebook campaign
Field type dimension
Data type string.text.value
campaign_performance__facebook_clicks
Display name Facebook clicks
Description The number of clicks on your ads
Field type metric
Data type int.number.value
campaign_performance__facebook_completions
Display name 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
Display name Facebook desktop app installs
Description The number of desktop app installs
Field type metric
Data type int.number.value
campaign_performance__facebook_desktop_app_uses
Display name Facebook desktop app uses
Description The number of desktop app uses
Field type metric
Data type int.number.value
campaign_performance__facebook_first_quartile_video_views
Display name 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_impressions
Display name Facebook impressions
Description The number of times ad seen on screen
Field type metric
Data type int.number.value
campaign_performance__facebook_landing_page_views
Display name Facebook landing page views
Description The number of landing page views
Field type metric
Data type int.number.value
campaign_performance__facebook_likes
Display name Facebook page likes
Description The number of page likes attributed to your ads
Field type metric
Data type int.number.value
campaign_performance__facebook_link_clicks
Display name 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_midpoint_quartile_video_views
Display name 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_mobile_app_installs
Display name Facebook mobile app installs
Description The number of mobile app installs
Field type metric
Data type int.number.value
campaign_performance__facebook_omni_app_installs
Display name Facebook app installs
Description The number of omni app installs
Field type metric
Data type int.number.value
campaign_performance__facebook_outbound_clicks
Display name Facebook outbound clicks
Description The number of facebook outbound clicks
Field type metric
Data type int.number.value
campaign_performance__facebook_page_engagements
Display name 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_post_comments
Display name Facebook post comments
Description The number of post comments
Field type metric
Data type int.number.value
campaign_performance__facebook_post_engagements
Display name 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
Display name Facebook post reactions
Description The number of reactions people had to your ads
Field type metric
Data type int.number.value
campaign_performance__facebook_post_shares
Display name Facebook post shares
Description The number of facebook post shares
Field type metric
Data type int.number.value
campaign_performance__facebook_third_quartile_video_views
Display name 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_video_fifteen_seconds_played
Display name 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
dataSourceName
Display name 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

Table: SNAPCHAT

campaign_performance__account_id
Display name Account ID
Description ID of the account
Field type dimension
Data type string.text.value
campaign_performance__account_name
Display name Account name
Description Name of the account
Field type dimension
Data type string.text.value
campaign_performance__brand_id
Display name Brand ID
Description The ID of the brand/advertiser
Field type dimension
Data type string.text.value
campaign_performance__brand_name
Display name Brand name
Description The name of the brand/advertiser
Field type dimension
Data type string.text.value
campaign_performance__campaign_id
Display name Campaign ID
Description ID of the campaign
Field type dimension
Data type string.text.value
campaign_performance__campaign_name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaign_performance__creative_id
Display name Creative ID
Description The ID of the creative
Field type dimension
Data type string.text.value
campaign_performance__creative_name
Display name Creative name
Description The name of the creative
Field type dimension
Data type string.text.value
campaign_performance__date
Display name Date
Field type dimension
Data type string.time.date
campaign_performance__snapchat_account_name
Display name Snapchat account name
Description The name of the Snapchat account
Field type dimension
Data type string.text.value
campaign_performance__snapchat_ad_id
Display name Snapchat ad ID
Description The id of the Snapchat ad
Field type dimension
Data type string.text.value
campaign_performance__snapchat_ad_name
Display name Snapchat ad name
Description The name of the Snapchat ad
Field type dimension
Data type string.text.value
campaign_performance__snapchat_attachment_completions
Display name 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
campaign_performance__snapchat_attachment_first_quartile_views
Display name 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
Display name 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
Display name 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_completions
Display name Snapchat completions
Description The number of `Snapchat video views` to completion
Field type metric
Data type int.number.value
campaign_performance__snapchat_creative_id
Display name Snapchat creative ID
Description The id of the Snapchat creative
Field type dimension
Data type string.text.value
campaign_performance__snapchat_first_quartile_views
Display name Snapchat 25% quartile
Description The number of `Snapchat video views` to 25%
Field type metric
Data type int.number.value
campaign_performance__snapchat_impressions
Display name Snapchat impressions
Description The number of Snapchat impressions
Field type metric
Data type int.number.value
campaign_performance__snapchat_installs
Display name 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
Display name 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_midpoint_quartile_views
Display name Snapchat 50% quartile
Description The number of `Snapchat video views` to 50%
Field type metric
Data type int.number.value
campaign_performance__snapchat_screen_time
Display name Snapchat screen time
Description The time spent on Top Snap ad (in milliseconds)
Field type metric
Data type int.number.value
campaign_performance__snapchat_spend
Display name Snapchat spend
Description The amount spent on Snapchat (in micro-currency)
Field type metric
Data type int.number.value
campaign_performance__snapchat_swipe_ups
Display name Snapchat swipe ups
Description The number of Snapchat swipe ups
Field type metric
Data type int.number.value
campaign_performance__snapchat_third_quartile_views
Display name Snapchat 75% quartile
Description The number of `Snapchat video views` to 75%
Field type metric
Data type int.number.value
campaign_performance__snapchat_video_views
Display name 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
dataSourceName
Display name 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

Table: TWITTER

campaign_performance__account_id
Display name Account ID
Description ID of the account
Field type dimension
Data type string.text.value
campaign_performance__account_name
Display name Account name
Description Name of the account
Field type dimension
Data type string.text.value
campaign_performance__brand_id
Display name Brand ID
Description The ID of the brand/advertiser
Field type dimension
Data type string.text.value
campaign_performance__brand_name
Display name Brand name
Description The name of the brand/advertiser
Field type dimension
Data type string.text.value
campaign_performance__campaign_id
Display name Campaign ID
Description ID of the campaign
Field type dimension
Data type string.text.value
campaign_performance__campaign_name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaign_performance__creative_id
Display name Creative ID
Description The ID of the creative
Field type dimension
Data type string.text.value
campaign_performance__creative_name
Display name Creative name
Description The name of the creative
Field type dimension
Data type string.text.value
campaign_performance__date
Display name Date
Field type dimension
Data type string.time.date
campaign_performance__twitter_account_id
Display name Twitter account ID
Description Twitter account ID
Field type dimension
Data type string.text.value
campaign_performance__twitter_ad_group_id
Display name Twitter ad group ID
Description Twitter ad group ID
Field type dimension
Data type string.text.value
campaign_performance__twitter_ad_id
Display name Twitter ad ID
Description Twitter ad ID
Field type dimension
Data type string.text.value
campaign_performance__twitter_app_clicks
Display name Twitter app clicks
Description The number of Twitter app clicks
Field type metric
Data type int.number.value
campaign_performance__twitter_clicks
Display name Twitter clicks
Description The number of Twitter ad clicks
Field type metric
Data type int.number.value
campaign_performance__twitter_engagements
Display name Twitter engagements
Description The number of Twitter ad engagements
Field type metric
Data type int.number.value
campaign_performance__twitter_first_quartile_views
Display name 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_follows
Display name Twitter follows
Description The number of Twitter follows
Field type metric
Data type int.number.value
campaign_performance__twitter_impressions
Display name Twitter impressions
Description The number of Twitter ad impressions
Field type metric
Data type int.number.value
campaign_performance__twitter_likes
Display name Twitter likes
Description The number of Twitter ad likes
Field type metric
Data type int.number.value
campaign_performance__twitter_midpoint_quartile_views
Display name 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_replies
Display name Twitter replies
Description The number of Twitter ad replies
Field type metric
Data type int.number.value
campaign_performance__twitter_retweets
Display name Twitter retweets
Description The number of Twitter ad retweets
Field type metric
Data type int.number.value
campaign_performance__twitter_third_quartile_views
Display name 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
Display name Twitter video completions
Description The number of Twitter ad video completions
Field type metric
Data type int.number.value
campaign_performance__twitter_video_starts
Display name Twitter video starts
Description The number of Twitter ad video starts
Field type metric
Data type int.number.value
campaign_performance__twitter_video_views
Display name Twitter video views
Description The number of Twitter ad video views
Field type metric
Data type int.number.value
dataSourceName
Display name 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