AdRoll data warehouse table groups

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

Table: AD

adEid
Display name Ad EID
Description EID of the ad
Field type dimension
Data type string.text.value
adFormat
Display name Ad format
Description Format string. i.e. '300 wide x 250 high'
Field type dimension
Data type string.text.value
adFormatID
Display name Ad format ID
Description Corresponding ad format ID in the AdRoll system
Field type dimension
Data type string.text.value
adFormatName
Display name Ad format
Description Format string. i.e. '300x250'
Field type dimension
Data type string.text.value
adgroupEid
Display name Adgroup EID
Description EID of the adgroup
Field type dimension
Data type string.text.value
adgroupIsActive
Display name Is adgroup active
Description Whether or not the adgroup is currently active
Field type dimension
Data type bool
adgroupName
Display name Adgroup
Description Name of the adgroup
Field type dimension
Data type string.text.value
adgroupStatus
Display name Adgroup status
Description Adgroup status: approved, paused, draft, rejected or deleted
Field type dimension
Data type string.text.value
adIsActive
Display name Is ad active
Description Whether or not the ad is currently active
Field type dimension
Data type bool
adName
Display name Ad
Description Name of the ad
Field type dimension
Data type string.text.value
adOptimization
Display name Ad optimization
Description Strategy used to optimize ads when multiple ads fit a single ad space
Field type dimension
Data type string.text.value
adrollEID
Display name AdRoll EID
Description AdRoll EID for prospecting ads
Field type dimension
Data type string.text.value
adStatus
Display name Ad status
Description Ad status: approved, paused, review, draft, rejected or deleted
Field type dimension
Data type string.text.value
adType
Display name Ad type
Description Ad type: liquid, image, flash or ad_network
Field type dimension
Data type string.text.value
advertisableCurrency
Display name Advertiser currency
Description Currency code (ISO-4217) use by the advertiser's account
Field type dimension
Data type string.currency.code
advertisableEid
Display name Advertiser EID
Description EID of the advertiser
Field type dimension
Data type string.text.value
advertisableName
Display name Advertiser
Description Advertiser profile
Field type dimension
Data type string.text.value
body
Display name Ad body
Description For Facebook ads, the text to be displayed as the ad's body
Field type dimension
Data type string.text.value
bouncedVisitors
Display name Bounced visitors
Description Visitors who have only viewed one page and left the site after viewing a prospecting ad. Please note that this field will be removed on 2022-04-28
Field type metric
Data type int.number.value
campaignEid
Display name Campaign EID
Description EID of the campaign
Field type dimension
Data type string.text.value
campaignName
Display name Campaign
Description Name of the campaign
Field type dimension
Data type string.text.value
campaignStatus
Display name Campaign status
Description Status of the campaign: running, ended, paused, review, draft, rejected or deleted
Field type dimension
Data type string.text.value
campaignType
Display name Campaign type
Description Type for the campaign: prospecting, blended or retargeting
Field type dimension
Data type string.text.value
channel
Display name Channel
Description Campaign channel: email, social or web
Field type dimension
Data type string.text.value
clickRevenue
Display name Click revenue
Description Click revenue amount
Field type metric
Data type float.currency.value
clicks
Display name Clicks
Description Number of times an ad was clicked over the date range selected
Field type metric
Data type int.number.value
clickThroughConversionWindow
Display name Click-through conversions duration (days)
Description Duration of the advertiser's Click-through conversions conversion window in days
Field type dimension
Data type int.number.value
clickThroughs
Display name Click-through conversions
Description Click-through conversions amount
Field type metric
Data type int.number.value
conversions
Display name Conversions
Description Conversions (count) = View Conversions + Click Conversions
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
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
destinationURL
Display name Ad destination URL
Description URL that the browser will navigate to when the ad is clicked
Field type dimension
Data type string.text.url
endDate
Display name Campaign end date
Description Date the campaign ended, exclusive
Field type dimension
Data type string.time.date
engagedVisitors
Display name Engaged visitors
Description Number of new visitors who have viewed at least 3 pages on the site after viewing a prospecting ad
Field type metric
Data type int.number.value
flights
Display name Flights
Description Scheduled flight periods when ads will be served. Null if there is no limitation
Field type dimension
Data type string.text.json
hasEdits
Display name Has edits
Description Whether or not the ad has been edited such that another ad has it's original ad parameter set to this ad's EID
Field type dimension
Data type bool
hasFutureCampaigns
Display name Has future campaigns
Description Whether or not the ad has the possibility of serving based on the adgroups & campaigns in which it inhabits
Field type dimension
Data type bool
hasPendingEdits
Display name Has pending edits
Description Whether or not the ad has edits that must be reviewed by an AdRoll administrator
Field type dimension
Data type bool
headline
Display name Ad headline
Description For Facebook ads, the text to be displayed as the ad's headline
Field type dimension
Data type string.text.value
height
Display name Ad height
Description Height in pixels of the ad's creative
Field type dimension
Data type int.number.value
impressions
Display name Impressions
Description Sum of the number of ad impressions and the number of unique-by-session email opens collected
Field type metric
Data type int.number.value
isOutlined
Display name Is outlined
Description Whether or not an outline has been applied to the ad to satisfy network compliance
Field type dimension
Data type bool
kpiMetric
Display name KPI metric
Description Metric being targeted by the campaign's bid strategy
Field type dimension
Data type string.text.value
message
Display name Ad message
Description For Facebook Newsfeed ads, the text to be displayed as the ad\s message
Field type dimension
Data type string.text.value
newVisitors
Display name New visitors
Description Number of new visitors who came to the site after viewing a prospecting ad
Field type metric
Data type int.number.value
nonBouncedVisitors
Display name Non-bounced visitors
Description Visitors who have only viewed more than one page after viewing a prospecting ad. Please note that this field will be removed on 2022-04-28
Field type metric
Data type int.number.value
originalAd
Display name Original Ad
Description EID of the ad that was edited to create the ad
Field type dimension
Data type string.text.value
outlineColor
Display name Ad outline color
Description Hexadecimal color code corresponding to the outline of an ad
Field type dimension
Data type string.text.value
revenue
Display name Revenue
Description Revenue (amount) = View Revenue + Click Conversions
Field type metric
Data type float.currency.value
revenue_campaignCurrency
Display name Revenue (account currency)
Description Revenue (amount) in your campaign currency
Field type metric
Data type float.currency.value
spend
Display name Cost (USD)
Description Cost amount in USD
Field type metric
Data type float.currency.value
src
Display name Ad source
Description Ad's creative's source URL
Field type dimension
Data type string.text.url
startDate
Display name Campaign start date
Description Date the campaign started
Field type dimension
Data type string.time.date
validClicktag
Display name Valid click tag
Description Flag showing if the ad is in flash format, whether or not the clickTAG is compliant
Field type dimension
Data type bool
viewRevenue
Display name View revenue
Description View revenue amount
Field type metric
Data type float.currency.value
viewThroughs
Display name View-through conversions
Description View-through conversions amount
Field type metric
Data type int.number.value
width
Display name Ad width
Description Width in pixels of the ad's creative
Field type dimension
Data type int.number.value

Table: CAMPAIGN

advertisableCurrency
Display name Advertiser currency
Description Currency code (ISO-4217) use by the advertiser's account
Field type dimension
Data type string.currency.code
advertisableEid
Display name Advertiser EID
Description EID of the advertiser
Field type dimension
Data type string.text.value
advertisableName
Display name Advertiser
Description Advertiser profile
Field type dimension
Data type string.text.value
bouncedVisitors
Display name Bounced visitors
Description Visitors who have only viewed one page and left the site after viewing a prospecting ad. Please note that this field will be removed on 2022-04-28
Field type metric
Data type int.number.value
budget
Display name Budget
Description Daily budget of the campaign
Field type dimension
Data type float.number.value
campaignCreatedDate
Display name Campaign created date
Description Date the campaign was created
Field type dimension
Data type string.time.date
campaignEid
Display name Campaign EID
Description EID of the campaign
Field type dimension
Data type string.text.value
campaignName
Display name Campaign
Description Name of the campaign
Field type dimension
Data type string.text.value
campaignStatus
Display name Campaign status
Description Status of the campaign: running, ended, paused, review, draft, rejected or deleted
Field type dimension
Data type string.text.value
campaignType
Display name Campaign type
Description Type for the campaign: prospecting, blended or retargeting
Field type dimension
Data type string.text.value
campaignUpdatedDate
Display name Campaign updated date
Description Date the campaign was last updated
Field type dimension
Data type string.time.date
channel
Display name Channel
Description Campaign channel: email, social or web
Field type dimension
Data type string.text.value
clickRevenue
Display name Click revenue
Description Click revenue amount
Field type metric
Data type float.currency.value
clicks
Display name Clicks
Description Number of times an ad was clicked over the date range selected
Field type metric
Data type int.number.value
clickThroughConversionWindow
Display name Click-through conversions duration (days)
Description Duration of the advertiser's Click-through conversions conversion window in days
Field type dimension
Data type int.number.value
clickThroughs
Display name Click-through conversions
Description Click-through conversions amount
Field type metric
Data type int.number.value
conversions
Display name Conversions
Description Conversions (count) = View Conversions + Click Conversions
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
date
Display name Date
Description Date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
endDate
Display name Campaign end date
Description Date the campaign ended, exclusive
Field type dimension
Data type string.time.date
engagedVisitors
Display name Engaged visitors
Description Number of new visitors who have viewed at least 3 pages on the site after viewing a prospecting ad
Field type metric
Data type int.number.value
impressions
Display name Impressions
Description Sum of the number of ad impressions and the number of unique-by-session email opens collected
Field type metric
Data type int.number.value
kpiCurrency
Display name KPI currency
Description ISO 4217 currency code for kpiGoal. If not provided assume the currency provided at the Advertiser level
Field type dimension
Data type string.currency.code
kpiGoal
Display name KPI goal
Description Goal for the kpiMetric that drives the campaign's bid strategy. Null for automatic
Field type dimension
Data type float.number.value
kpiMetric
Display name KPI metric
Description Metric being targeted by the campaign's bid strategy
Field type dimension
Data type string.text.value
maxCpm
Display name Max CPM
Description Maximum CPM for the campaign
Field type dimension
Data type float.number.value
newVisitors
Display name New visitors
Description Number of new visitors who came to the site after viewing a prospecting ad
Field type metric
Data type int.number.value
nonBouncedVisitors
Display name Non-bounced visitors
Description Visitors who have only viewed more than one page after viewing a prospecting ad. Please note that this field will be removed on 2022-04-28
Field type metric
Data type int.number.value
revenue
Display name Revenue
Description Revenue (amount) = View Revenue + Click Conversions
Field type metric
Data type float.currency.value
revenue_campaignCurrency
Display name Revenue (account currency)
Description Revenue (amount) in your campaign currency
Field type metric
Data type float.currency.value
source
Display name Source
Description Service responsible for the creation of the campaign
Field type dimension
Data type string.text.value
spend
Display name Cost (USD)
Description Cost amount in USD
Field type metric
Data type float.currency.value
startDate
Display name Campaign start date
Description Date the campaign started
Field type dimension
Data type string.time.date
viewRevenue
Display name View revenue
Description View revenue amount
Field type metric
Data type float.currency.value
viewThroughs
Display name View-through conversions
Description View-through conversions amount
Field type metric
Data type int.number.value