Ignite data warehouse table groups

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

Table: CAMPAIGN

campaigns__account_manager_id
Display name Account manager ID
Description ID of the REA account manager servicing the campaign
Field type dimension
Data type string.text.value
campaigns__account_manager_name
Display name Account manager name
Description Name of the REA account manager servicing the campaign
Field type dimension
Data type string.text.value
campaigns__advertiser_id
Display name Advertiser ID
Description ID of the advertiser running the campaign
Field type dimension
Data type string.text.value
campaigns__advertiser_name
Display name Advertiser name
Description Name of the advertising agency running the campaign
Field type dimension
Data type string.text.value
campaigns__budget
Display name Budget
Description Total budgeted for campaign spend
Field type dimension
Data type string.text.value
campaigns__budget_remaining
Display name Budget remaining
Description Total budget remaining
Field type dimension
Data type string.text.value
campaigns__campaign_id
Display name Campaign ID
Description ID of the campaign
Field type dimension
Data type string.text.value
campaigns__campaign_name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaigns__campaign_performance__clicks
Display name Clicks
Description Number of delivered clicks for the campaign
Field type metric
Data type int.number.value
campaigns__campaign_performance__date
Display name Date
Field type dimension
Data type string.time.date
campaigns__campaign_performance__impressions
Display name Impressions
Description Number of delivered impressions for the campaign
Field type metric
Data type int.number.value
campaigns__campaign_performance__leads
Display name Leads
Description Number of delivered leads for the campaign
Field type metric
Data type int.number.value
campaigns__campaign_performance__post_click_leads
Display name Post click leads
Description Number of leads delivered directly after a customer interacts with an ad
Field type metric
Data type int.number.value
campaigns__campaign_performance__post_impression_leads
Display name Post impression leads
Description Number of leads delivered directly after a customer sees an ad
Field type metric
Data type int.number.value
campaigns__campaign_performance__spend
Display name Spend
Description Total spent on campaign to date
Field type metric
Data type float.currency.value
campaigns__campaign_status
Display name Campaign status
Description Current status of the campaign
Field type dimension
Data type string.text.value
campaigns__creation_date
Display name Creation date
Description Creation date of the campaign
Field type dimension
Data type string.time.date
campaigns__end_date
Display name End date
Description End date of the campaign
Field type dimension
Data type string.time.date
campaigns__impressions_goal
Display name Impressions goal
Description Number of goal impressions for the campaign
Field type dimension
Data type string.text.value
campaigns__insertion_order_number
Display name Insertion order number
Description Insertion order number
Field type dimension
Data type string.text.value
campaigns__product
Display name Product
Description Type of the advertising product
Field type dimension
Data type string.text.value
campaigns__start_date
Display name Start date
Description Start date of the campaign
Field type dimension
Data type string.time.date
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: CAMPAIGN_FLIGHTS

campaign_flights__account_manager_id
Display name Account manager ID
Description ID of the REA account manager servicing the campaign
Field type dimension
Data type string.text.value
campaign_flights__account_manager_name
Display name Account manager name
Description Name of the REA account manager servicing the campaign
Field type dimension
Data type string.text.value
campaign_flights__advertiser_id
Display name Advertiser ID
Description ID of the advertiser running the campaign
Field type dimension
Data type string.text.value
campaign_flights__advertiser_name
Display name Advertiser name
Description Name of the advertising agency running the campaign
Field type dimension
Data type string.text.value
campaign_flights__budget
Display name Budget
Description Total budgeted for campaign spend
Field type dimension
Data type string.text.value
campaign_flights__budget_remaining
Display name Budget remaining
Description Total budget remaining
Field type dimension
Data type string.text.value
campaign_flights__campaign_id
Display name Campaign ID
Description ID of the campaign
Field type dimension
Data type string.text.value
campaign_flights__campaign_name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaign_flights__campaign_status
Display name Campaign status
Description Current status of the campaign
Field type dimension
Data type string.text.value
campaign_flights__creation_date
Display name Creation date
Description Creation date of the campaign
Field type dimension
Data type string.time.date
campaign_flights__end_date
Display name End date
Description End date of the campaign
Field type dimension
Data type string.time.date
campaign_flights__flights_decoration__ad_type
Display name Ad type
Description Ad type applied to flight
Field type dimension
Data type string.text.value
campaign_flights__flights_decoration__channel
Display name Channel
Description Advertising channel where flight is live
Field type dimension
Data type string.text.value
campaign_flights__flights_decoration__clicks
Display name Clicks
Description Number of clicks delivered
Field type metric
Data type int.number.value
campaign_flights__flights_decoration__comments
Display name Comments
Description Number of comments on a post
Field type metric
Data type int.number.value
campaign_flights__flights_decoration__flight_budget
Display name Flight budget
Description Total budgeted for flight spend
Field type dimension
Data type string.text.value
campaign_flights__flights_decoration__flight_end_date
Display name Flight end date
Description End date of the flight
Field type dimension
Data type string.time.date
campaign_flights__flights_decoration__flight_id
Display name Flight ID
Description ID of the flight
Field type dimension
Data type string.text.value
campaign_flights__flights_decoration__flight_name
Display name Flight name
Description Name of the flight
Field type dimension
Data type string.text.value
campaign_flights__flights_decoration__flight_start_date
Display name Flight start date
Description Start date of the flight
Field type dimension
Data type string.time.date
campaign_flights__flights_decoration__flight_status
Display name Flight status
Description Current status of flight
Field type dimension
Data type string.text.value
campaign_flights__flights_decoration__impressions
Display name Impressions
Description Number of impressions delivered
Field type metric
Data type int.number.value
campaign_flights__flights_decoration__impressions_goal
Display name Flight impressions goal
Description Number of goal impressions for the flight
Field type dimension
Data type string.text.value
campaign_flights__flights_decoration__leads
Display name Leads
Description Number of leads delivered
Field type metric
Data type int.number.value
campaign_flights__flights_decoration__likes
Display name Likes
Description Number of likes the parent page has received
Field type metric
Data type int.number.value
campaign_flights__flights_decoration__post_clicks
Display name Post clicks
Description Number of delivered post clicks
Field type metric
Data type int.number.value
campaign_flights__flights_decoration__post_impressions
Display name Post impressions
Description Number of delivered post impressions
Field type metric
Data type int.number.value
campaign_flights__flights_decoration__product_rate_type
Display name Product rate type
Description Rate type applied to product
Field type dimension
Data type string.text.value
campaign_flights__flights_decoration__reactions
Display name Reactions
Description Number of reactions a post has generated
Field type metric
Data type int.number.value
campaign_flights__flights_decoration__shares
Display name Shares
Description Number of times a post has been shared
Field type metric
Data type int.number.value
campaign_flights__flights_decoration__spend
Display name Spend
Description Total spent on flight to date
Field type metric
Data type float.currency.value
campaign_flights__impressions_goal
Display name Impressions goal
Description Number of goal impressions for the campaign
Field type dimension
Data type string.text.value
campaign_flights__insertion_order_number
Display name Insertion order number
Description Insertion order number
Field type dimension
Data type string.text.value
campaign_flights__product
Display name Product
Description Type of the advertising product
Field type dimension
Data type string.text.value
campaign_flights__start_date
Display name Start date
Description Start date of the campaign
Field type dimension
Data type string.time.date
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
today
Display name Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date

Table: CAMPAIGN_CREATIVES

campaign_creatives__account_manager_id
Display name Account manager ID
Description ID of the REA account manager servicing the campaign
Field type dimension
Data type string.text.value
campaign_creatives__account_manager_name
Display name Account manager name
Description Name of the REA account manager servicing the campaign
Field type dimension
Data type string.text.value
campaign_creatives__advertiser_id
Display name Advertiser ID
Description ID of the advertiser running the campaign
Field type dimension
Data type string.text.value
campaign_creatives__advertiser_name
Display name Advertiser name
Description Name of the advertising agency running the campaign
Field type dimension
Data type string.text.value
campaign_creatives__budget
Display name Budget
Description Total budgeted for campaign spend
Field type dimension
Data type string.text.value
campaign_creatives__budget_remaining
Display name Budget remaining
Description Total budget remaining
Field type dimension
Data type string.text.value
campaign_creatives__campaign_id
Display name Campaign ID
Description ID of the campaign
Field type dimension
Data type string.text.value
campaign_creatives__campaign_name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaign_creatives__campaign_status
Display name Campaign status
Description Current status of the campaign
Field type dimension
Data type string.text.value
campaign_creatives__creation_date
Display name Creation date
Description Creation date of the campaign
Field type dimension
Data type string.time.date
campaign_creatives__creation_time
Display name Creation date and time
Description Creation date and time of the campaign
Field type dimension
Data type string.time.datetime
campaign_creatives__creatives_decoration__channel
Display name Channel
Description Advertising channel where creative is live
Field type dimension
Data type string.text.value
campaign_creatives__creatives_decoration__clicks
Display name Clicks
Description Number of clicks delivered
Field type metric
Data type int.number.value
campaign_creatives__creatives_decoration__comments
Display name Comments
Description Number of comments on a post
Field type metric
Data type int.number.value
campaign_creatives__creatives_decoration__creative_id
Display name Creative ID
Description ID of the creative
Field type dimension
Data type string.text.value
campaign_creatives__creatives_decoration__creative_name
Display name Creative name
Description Name of the creative
Field type dimension
Data type string.text.value
campaign_creatives__creatives_decoration__image_url
Display name Image URL
Description URL location of creative image
Field type dimension
Data type string.text.url
campaign_creatives__creatives_decoration__impressions
Display name Impressions
Description Number of impressions delivered
Field type metric
Data type int.number.value
campaign_creatives__creatives_decoration__leads
Display name Leads
Description Number of leads delivered
Field type metric
Data type int.number.value
campaign_creatives__creatives_decoration__likes
Display name Likes
Description Number of likes the parent page has received
Field type metric
Data type int.number.value
campaign_creatives__creatives_decoration__post_clicks
Display name Post clicks
Description Number of delivered post clicks
Field type metric
Data type int.number.value
campaign_creatives__creatives_decoration__post_impressions
Display name Post impressions
Description Number of delivered post impressions
Field type metric
Data type int.number.value
campaign_creatives__creatives_decoration__reactions
Display name Reactions
Description Number of reactions a post has generated
Field type metric
Data type int.number.value
campaign_creatives__creatives_decoration__shares
Display name Shares
Description Number of times a post has been shared
Field type metric
Data type int.number.value
campaign_creatives__creatives_decoration__spend
Display name Spend
Description Total spent on creative to date
Field type metric
Data type float.currency.value
campaign_creatives__creatives_decoration__type
Display name Type
Description Type of the advertisement
Field type dimension
Data type string.text.value
campaign_creatives__end_date
Display name End date
Description End date of the campaign
Field type dimension
Data type string.time.date
campaign_creatives__impressions_goal
Display name Impressions goal
Description Number of goal impressions for the campaign
Field type dimension
Data type string.text.value
campaign_creatives__insertion_order_number
Display name Insertion order number
Description Insertion order number
Field type dimension
Data type string.text.value
campaign_creatives__product
Display name Product
Description Type of the advertising product
Field type dimension
Data type string.text.value
campaign_creatives__start_date
Display name Start date
Description Start date of the campaign
Field type dimension
Data type string.time.date
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
today
Display name Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date