AdRoll data warehouse table groups

Prev Next

Table: AD

adEid
adFormat
adFormatID
adFormatName
adgroupEid
adgroupIsActive
adgroupName
adgroupStatus
adIsActive
adName
adOptimization
adrollEID
adStatus
adType
advertisableCurrency
advertisableEid
advertisableName
body
bouncedVisitors
campaignEid
campaignName
campaignStatus
campaignType
channel
clickRevenue
clicks
clickThroughConversionWindow
clickThroughs
conversions
dataSourceName
date
destinationURL
endDate
engagedVisitors
flights
hasEdits
hasFutureCampaigns
hasPendingEdits
headline
height
impressions
isOutlined
kpiMetric
message
newVisitors
nonBouncedVisitors
originalAd
outlineColor
revenue
revenue_campaignCurrency
spend
src
startDate
validClicktag
viewRevenue
viewThroughs
width

Table: CAMPAIGN

advertisableCurrency
advertisableEid
advertisableName
bouncedVisitors
budget
campaignCreatedDate
campaignEid
campaignName
campaignStatus
campaignType
campaignUpdatedDate
channel
clickRevenue
clicks
clickThroughConversionWindow
clickThroughs
conversions
dataSourceName
date
endDate
engagedVisitors
impressions
kpiCurrency
kpiGoal
kpiMetric
maxCpm
newVisitors
nonBouncedVisitors
revenue
revenue_campaignCurrency
source
spend
startDate
viewRevenue
viewThroughs