Flashtalking data warehouse table groups

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

Table: CREATIVE

campaign__campaign_id
Display name Campaign ID
Description ID associated with a Campaign
Field type dimension
Data type string.text.value
campaign__campaign_name
Display name Campaign name
Description Name of the campaign, a coordinated media delivery plan that includes placements, creatives, etc
Field type dimension
Data type string.text.value
campaign__performance__advertiser_id
Display name Advertiser ID
Description ID associated with an advertiser
Field type dimension
Data type string.text.value
campaign__performance__advertiser_name
Display name Advertiser name
Description A person, company or brand that attempts to target and engage customers/prospects through paid media
Field type dimension
Data type string.text.value
campaign__performance__booked_cost
Display name Booked cost
Description The expected cost for the placement or package. This is required when the Cost Cap Period is Total. This is optional when the Cost Cap Period is None
Field type metric
Data type float.currency.value
campaign__performance__clicks
Display name Clicks
Description The total number of times the ad has been clicked on
Field type metric
Data type int.number.value
campaign__performance__combined_viewable_impressions
Display name Combined viewable impressions
Description Combination of Desktop, Mobile App, and Mobile Web-Viewable Impressions. This metric is net of GIVT filtration
Field type metric
Data type int.number.value
campaign__performance__creative_id
Display name Creative ID
Description ID associated with a creative
Field type dimension
Data type string.text.value
campaign__performance__creative_name
Display name Creative name
Description The visual advertisement that will be shown to users
Field type dimension
Data type string.text.value
campaign__performance__date
Display name Date
Field type dimension
Data type string.time.date
campaign__performance__enhanced_clicks
Display name Enhanced clicks
Description The number of times the enhanced ad has been clicked on
Field type metric
Data type int.number.value
campaign__performance__enhanced_impressions
Display name Enhanced impressions
Description The number of times the enhanced ad has been served
Field type metric
Data type int.number.value
campaign__performance__media_buyer_id
Display name Media buyer ID
Description ID associated with a media buyer
Field type dimension
Data type string.text.value
campaign__performance__media_buyer_name
Display name Media buyer name
Description A person or entity that purchases and monitors advertising space
Field type dimension
Data type string.text.value
campaign__performance__media_cost_total
Display name Media cost total
Description The units of media cost type multiplied by the media cost rate. For example for CPM (impressions/1000) x Media Cost Rate
Field type metric
Data type float.currency.value
campaign__performance__placement_id
Display name Placement ID
Description ID associated with a placement
Field type dimension
Data type string.text.value
campaign__performance__placement_name
Display name Placement name
Description An object that contains tags and represents a unit of available ad space on a web page
Field type dimension
Data type string.text.value
campaign__performance__site_id
Display name Site ID
Description ID associated with a site
Field type dimension
Data type string.text.value
campaign__performance__site_name
Display name Site name
Description Publisher, ad network, website, or SSP which provides inventory space where media can be bought
Field type dimension
Data type string.text.value
campaign__performance__standard_clicks
Display name Standard clicks
Description The number of times the standard ad has been clicked on
Field type metric
Data type int.number.value
campaign__performance__standard_impressions
Display name Standard impressions
Description The number of times the standard ad has been served
Field type metric
Data type int.number.value
campaign__performance__total_ads_booked
Display name Total ads booked
Description The total number of time ads have been booked. This appears as Booked Units in the campaign manager. The number of expected delivered units (as in, impressions, clicks, or conversions) based on the selected Media Cost Type. This is required if the Cost Cap Period is Total and the Media Cost Type is Fix. Otherwise, this is optional
Field type metric
Data type int.number.value
campaign__performance__total_ads_requested
Display name Total ads requested
Description The number of times the ad has been served. Uses a 'Count on Decision' methodology as determined by IAB. This metric is net of GIVT filtration
Field type metric
Data type int.number.value
campaign__performance__total_conversion_value
Display name Total conversion value
Description Total value captured as a passed value against the selected spotlights (from combined non-viewable impressions)
Field type metric
Data type int.number.value
campaign__performance__total_conversion_value_from_clicks
Display name Total conversion value (from clicks)
Description Total value captured as a passed value against the selected spotlights following an attributed click event
Field type metric
Data type int.number.value
campaign__performance__total_conversion_value_from_views
Display name Total conversion value (from views)
Description Total value captured as a passed value against the selected spotlights following a view attributed event
Field type metric
Data type int.number.value
campaign__performance__total_cost
Display name Total cost
Description The combination of media total cost and FT Cost
Field type metric
Data type float.currency.value
campaign__performance__total_income
Display name Total income
Description The combination of all income
Field type metric
Data type float.currency.value
campaign__performance__total_interaction_time
Display name Total interaction time (sec)
Description The total time value of all interactions in seconds
Field type metric
Data type float.number.value
campaign__performance__total_spotlights
Display name Total spotlights
Description The number of last touch attributed conversions from users that have reached any of the targeted spotlight pages
Field type metric
Data type int.number.value
campaign__performance__total_spotlights_from_clicks
Display name Total spotlights (from clicks)
Description The number of last touch attributed conversions from users
Field type metric
Data type int.number.value
campaign__performance__total_spotlights_from_views
Display name Total spotlights (from views)
Description The number of last touch attributed conversions from users that have reached any of the targeted spotlight pages following an ad with no click
Field type metric
Data type int.number.value
campaign__performance__total_video_25_played
Display name Total video 25% played
Description The number of times any video is viewed to 25% completion. Net of GIVT
Field type metric
Data type int.number.value
campaign__performance__total_video_50_played
Display name Total video 50% played
Description The number of times any video is viewed to 50% completion. Net of GIVT
Field type metric
Data type int.number.value
campaign__performance__total_video_75_played
Display name Total video 75% played
Description The number of times any video is viewed to 75% completion. Net of GIVT
Field type metric
Data type int.number.value
campaign__performance__total_video_completes
Display name Total video completes
Description The number of times any video is viewed to completion. Net of GIVT
Field type metric
Data type int.number.value
campaign__performance__total_video_mute
Display name Total video mutes
Description The number of times any video is muted. Net of GIVT
Field type metric
Data type int.number.value
campaign__performance__total_video_replays
Display name Total video replays
Description The number of times any video is replayed. Net of GIVT
Field type metric
Data type int.number.value
campaign__performance__total_video_start
Display name Total video start
Description The number of total videos which began to play net of GIVT
Field type metric
Data type int.number.value
campaign__performance__total_video_unmute
Display name Total video unmutes
Description The number of times any video is unmuted. Net of GIVT
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