Outbrain Amplify data warehouse table groups

  • Updated on Dec 10, 2025
  • Published on Aug 5, 2025
Prev Next

Table: CAMPAIGN

budget_amount
Display name Budget amount
Description The monetary amount of the budget
Field type dimension
Data type float.currency.value
budget_amount_remaining
Display name Budget remaining
Description The unspent monetary amount remaining on the budget
Field type dimension
Data type float.currency.value
budget_amount_spent
Display name Budget spent
Description The spent monetary amount of the budget
Field type dimension
Data type float.currency.value
budget_created_at
Display name Budget created date
Description The time when the budget was created
Field type dimension
Data type string.time.datetime
budget_currency
Display name Budget currency
Description The currency denomination applied to the budget amount
Field type dimension
Data type string.currency.code
budget_daily_target
Display name Budgets daily target
Description The maximum amount of spend that is allowed per day
Field type dimension
Data type float.currency.value
budget_end_date
Display name Budget end date
Description The date the budget is scheduled to stop spending
Field type dimension
Data type string.time.date
budget_id
Display name Budget ID
Description The ID of the budget
Field type dimension
Data type string.text.value
budget_maximum_amount
Display name Budgets allowed maximum amount
Description The maximum amount allowed
Field type dimension
Data type float.currency.value
budget_name
Display name Budget name
Description The name of the budget
Field type dimension
Data type string.text.value
budget_pacing
Display name Budget spending pace
Description Controls how fast the budget will be spent SPEND_ASAP/AUTOMATIC/DAILY_TARGET
Field type dimension
Data type string.text.value
budget_runs_forever
Display name Budget runs forever
Description Whether the budged has an end date or not
Field type dimension
Data type bool
budget_start_date
Display name Budget start date
Description The date the budget is scheduled to begin spending
Field type dimension
Data type string.time.date
budget_type
Display name Budget refresh period
Description Budget refresh period CAMPAIGN/MONTHLY/DAILY
Field type dimension
Data type string.text.value
budget_updated_at
Display name Budget updated date
Description The last modification date of the budget
Field type dimension
Data type string.time.datetime
campaign_content_type
Display name Content type
Description The content type of campaign
Field type dimension
Data type string.text.value
campaign_cpc
Display name Campaign CPC
Description Cost per click
Field type dimension
Data type float.currency.value
campaign_created_at
Display name Campaign created date
Description The date when the campaign was created
Field type dimension
Data type string.time.datetime
campaign_currency
Display name Campaign budget currency
Description The currency of the Budget
Field type dimension
Data type string.currency.code
campaign_id
Display name Campaign ID
Description Campaign ID
Field type dimension
Data type string.text.value
campaign_min_cpc
Display name Min. campaign CPC
Description The minimal possible cost per click
Field type dimension
Data type float.currency.value
campaign_name
Display name Campaign name
Description Campaign name
Field type dimension
Data type string.text.value
campaign_on_air_reason
Display name Campaign On Air reason
Description Indicates a meaningful reason in case the campaign is On Air
Field type dimension
Data type string.text.value
campaign_on_air_type
Display name Campaign On Air type
Description Represents the scheduling type for the campaign to be On Air
Field type dimension
Data type string.text.value
campaign_optimization_type
Display name Campaign optimization type
Description The campaign optimization type
Field type dimension
Data type string.text.value
campaign_start_time
Display name Campaign start time
Description Time of the day when this campaign should start
Field type dimension
Data type string.time.hms
campaign_updated_at
Display name Campaign updated date
Description The date when the campaign was last modified
Field type dimension
Data type string.time.datetime
clicks
Display name Clicks
Description Total promoted links clicks
Field type metric
Data type int.number.value
clicks_conversions
Display name Click conversions
Description The total number of conversions from clicks calculated
Field type metric
Data type int.number.value
clicks_sum_value
Display name Total click conversion amount
Description The total amount of money reported for conversions from clicks
Field type metric
Data type float.currency.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
date
Display name Date
Field type dimension
Data type string.time.date
impressions
Display name Impressions
Description Total number of promoted links impressions
Field type metric
Data type int.number.value
is_campaign_archived
Display name Is campaign archived
Description Indicates whether the campaign is archived
Field type dimension
Data type bool
is_campaign_enabled
Display name Is campaign enabled
Description Indicates whether the campaign is enabled
Field type dimension
Data type bool
is_campaign_on_air
Display name Is campaign On Air
Description Indicates whether the campaign is On Air
Field type dimension
Data type bool
is_marketer_enabled
Display name Is account enabled
Description Indicates whether the marketer is enabled
Field type dimension
Data type bool
marketer_created_at
Display name Account created date
Description The date when the Marketer was created
Field type dimension
Data type string.time.datetime
marketer_currency
Display name Account currency
Description Marketer's currency
Field type dimension
Data type string.currency.code
marketer_id
Display name Account ID
Description Marketer's ID
Field type dimension
Data type string.text.value
marketer_name
Display name Account
Description Marketer's name
Field type dimension
Data type string.text.value
spend
Display name Spend
Description The total amount of money spent
Field type metric
Data type float.currency.value
spend_eur
Display name Spend (EUR)
Description The total amount of money spent in EUR
Field type metric
Data type float.currency.value
spend_gbp
Display name Spend (GBP)
Description The total amount of money spent in GBP
Field type metric
Data type float.currency.value
spend_usd
Display name Spend (USD)
Description The total amount of money spent in USD
Field type metric
Data type float.currency.value
total_conversions
Display name Total conversions
Description The total number of conversions calculated
Field type metric
Data type int.number.value
total_sum_value
Display name Total conversions amount
Description The total amount of money reported for all conversions
Field type metric
Data type float.currency.value
view_conversions
Display name View-through conversions
Description The total number of view-through conversions calculated
Field type metric
Data type int.number.value
view_sum_value
Display name Total view-through conversion amount
Description The total amount of money reported for view-through conversions
Field type metric
Data type float.currency.value

Table: PROMOTED_LINK_PERFORMANCE

budget_amount
Display name Budget amount
Description The monetary amount of the budget
Field type dimension
Data type float.currency.value
campaign_content_type
Display name Content type
Description The content type of campaign
Field type dimension
Data type string.text.value
campaign_cpc
Display name Campaign CPC
Description Cost per click
Field type dimension
Data type float.currency.value
campaign_created_at
Display name Campaign created date
Description The date when the campaign was created
Field type dimension
Data type string.time.datetime
campaign_currency
Display name Campaign budget currency
Description The currency of the Budget
Field type dimension
Data type string.currency.code
campaign_id
Display name Campaign ID
Description Campaign ID
Field type dimension
Data type string.text.value
campaign_min_cpc
Display name Min. campaign CPC
Description The minimal possible cost per click
Field type dimension
Data type float.currency.value
campaign_name
Display name Campaign name
Description Campaign name
Field type dimension
Data type string.text.value
campaign_on_air_reason
Display name Campaign On Air reason
Description Indicates a meaningful reason in case the campaign is On Air
Field type dimension
Data type string.text.value
campaign_on_air_type
Display name Campaign On Air type
Description Represents the scheduling type for the campaign to be On Air
Field type dimension
Data type string.text.value
campaign_optimization_type
Display name Campaign optimization type
Description The campaign optimization type
Field type dimension
Data type string.text.value
campaign_start_time
Display name Campaign start time
Description Time of the day when this campaign should start
Field type dimension
Data type string.time.hms
campaign_updated_at
Display name Campaign updated date
Description The date when the campaign was last modified
Field type dimension
Data type string.time.datetime
clicks
Display name Clicks
Description Total promoted links clicks
Field type metric
Data type int.number.value
clicks_conversions
Display name Click conversions
Description The total number of conversions from clicks calculated
Field type metric
Data type int.number.value
clicks_sum_value
Display name Total click conversion amount
Description The total amount of money reported for conversions from clicks
Field type metric
Data type float.currency.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
date
Display name Date
Field type dimension
Data type string.time.date
impressions
Display name Impressions
Description Total number of promoted links impressions
Field type metric
Data type int.number.value
is_campaign_archived
Display name Is campaign archived
Description Indicates whether the campaign is archived
Field type dimension
Data type bool
is_campaign_enabled
Display name Is campaign enabled
Description Indicates whether the campaign is enabled
Field type dimension
Data type bool
is_campaign_on_air
Display name Is campaign On Air
Description Indicates whether the campaign is On Air
Field type dimension
Data type bool
is_marketer_enabled
Display name Is account enabled
Description Indicates whether the marketer is enabled
Field type dimension
Data type bool
is_promoted_link_archived
Display name Is promoted link archived
Description Designates whether this promoted link is archived
Field type dimension
Data type bool
is_promoted_link_editable
Display name Is promoted link editable
Description Indicated whether the promoted link is editable
Field type dimension
Data type bool
is_promoted_link_enabled
Display name Is promoted link enabled
Description Designates whether this promoted link will be served
Field type dimension
Data type bool
is_promoted_link_on_air
Display name Is promoted link On Air
Description Indicates whether the promoted link is On Air (can be served)
Field type dimension
Data type bool
marketer_created_at
Display name Account created date
Description The date when the Marketer was created
Field type dimension
Data type string.time.datetime
marketer_currency
Display name Account currency
Description Marketer's currency
Field type dimension
Data type string.currency.code
marketer_id
Display name Account ID
Description Marketer's ID
Field type dimension
Data type string.text.value
marketer_name
Display name Account
Description Marketer's name
Field type dimension
Data type string.text.value
promoted_link_approval_status
Display name Promoted link status
Description The approval status of the promoted link
Field type dimension
Data type string.text.value
promoted_link_approval_status_reasons
Display name Promoted link rejection reasons
Description The rejection reasons of the promoted link
Field type dimension
Data type string.text.value
promoted_link_base_url
Display name Promoted link base URL
Description The URL that the promoted link was created with
Field type dimension
Data type string.text.url
promoted_link_cpc_adjustment
Display name Promoted link CPC adjustment
Description Cost Per Click adjustment bid based on the campaign's CPC
Field type dimension
Data type float.number.value
promoted_link_created_at
Display name Promoted link created date
Description The date when the promoted link was created
Field type dimension
Data type string.time.datetime
promoted_link_document_id
Display name Promoted link document ID
Description The ID of the document to which this promoted link belongs
Field type dimension
Data type string.text.value
promoted_link_id
Display name Promoted link ID
Description The ID of the promoted link
Field type dimension
Data type string.text.value
promoted_link_image_url
Display name Promoted link image url
Description The URL of the promoted link image
Field type dimension
Data type string.text.url
promoted_link_lang
Display name Promoted link language
Description The 2-letter code for the language of this promoted link
Field type dimension
Data type string.language.twolettercode
promoted_link_on_air_reason
Display name Promoted link On Air reason
Description Indicates a meaningful reason in case the On Air property is false
Field type dimension
Data type string.text.value
promoted_link_section_name
Display name Promoted link section name
Description The section name of the site the promoted link URL points to
Field type dimension
Data type string.text.value
promoted_link_text
Display name Promoted link text
Description The text of the promoted link
Field type dimension
Data type string.text.value
promoted_link_updated_at
Display name Promoted link updated date
Description The date when the promoted link was last modified
Field type dimension
Data type string.time.datetime
promoted_link_url
Display name Promoted link URL
Description The URL visitors will be sent to upon clicking the promoted link
Field type dimension
Data type string.text.url
spend
Display name Spend
Description The total amount of money spent
Field type metric
Data type float.currency.value
spend_eur
Display name Spend (EUR)
Description The total amount of money spent in EUR
Field type metric
Data type float.currency.value
spend_gbp
Display name Spend (GBP)
Description The total amount of money spent in GBP
Field type metric
Data type float.currency.value
spend_usd
Display name Spend (USD)
Description The total amount of money spent in USD
Field type metric
Data type float.currency.value
total_conversions
Display name Total conversions
Description The total number of conversions calculated
Field type metric
Data type int.number.value
total_sum_value
Display name Total conversions amount
Description The total amount of money reported for all conversions
Field type metric
Data type float.currency.value
view_conversions
Display name View-through conversions
Description The total number of view-through conversions calculated
Field type metric
Data type int.number.value
view_sum_value
Display name Total view-through conversion amount
Description The total amount of money reported for view-through conversions
Field type metric
Data type float.currency.value