AdRoll fields

Prev Next

Supermetrics brings all your AdRoll data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

40 metrics138 dimensions

AD

adName
adEid
adType
adStatus
adCreatedDate
adUpdatedDate
adIsActive
adFormatID
adFormat
adFormatName
hasFutureCampaigns
destinationURL
utm_source
utm_medium
utm_campaign
utm_term
utm_content
headline
body
message
originalAd
src
ad_image
hasEdits
hasPendingEdits
isOutlined
validClicktag
adrollEID
height
width
outlineColor

ADGROUP

adgroupName
adgroupEid
adgroupStatus
adgroupCreatedDate
adgroupUpdatedDate
adgroupIsActive
adOptimization
siteExclusions
flights
flightTimezone

ADVERTISER

advertisableName
advertisableEid
advertisableStatus
advertisableCreatedDate
advertisableCurrency
advertisableIsActive
businessUnit
url
organization
clickThroughConversionWindow
viewThroughConversionWindow
revshareViewPercent
revshareClickPercent

AUDIENCE

audienceName
audienceEid
audienceType
audienceCampaign
audienceAdvertisable
audienceCurrency
segmentEID
description
audienceCreatedDate
inclusion
isConversion
audienceSyncSize

AUDIENCE PERFORMANCE

audienceSizeTotal
audienceSizeCurrent

CAMPAIGN

campaignName
campaignEid
campaignType
campaignStatus
campaignCurrency
budget
maxCpm
campaignCreatedDate
campaignUpdatedDate
channel
startDate
endDate
kpiCurrency
kpiGoal
kpiMetric
source

CONVERSIONS

conversions
conversionRate
clickThroughs
viewThroughs
ctcRate
vtcRate
revenue
revenue_campaignCurrency
clickRevenue
viewRevenue
cpa
clickCPA
viewCPA
roi
clickROI
viewROI

DATASOURCE

dataSourceName
system_metadata.data_source_logins
system_metadata.data_source_login_owners

DEPRECATED

placementTargets
advertisableIsB2B
segments
platformTargets
totalVisitors
bouncedVisitors
bounceRate
audienceSizeNew
nonBouncedVisitors

EMAIL

sends

GRANULAR CONVERSIONS

adrollConversionId
device
time
country
countryCode
city
adSize
referrerURL
daysToConversionFirstTouch
daysToConversionLastTouch
firstTouchTimestamp
lastTouchTimestamp
externalData
lastTouchAttribution
touchpointTimestamp
attributionCredit
attributionModel
attributedConversions

PERFORMANCE

impressions
clicks
spend
spend_campaignCurrency
ctr
cpc
cpm

PLACEMENT

placement
avg_order_value

QUERY

system_metadata.query_date_range_start
system_metadata.query_date_range_end
system_metadata.query_timezone
system_metadata.query_filters
system_metadata.query_date_start
system_metadata.query_date_end
system_metadata.query_duration
system_metadata.query_accounts

SEGMENT

eid
name
type
tags
segmentCurrency
duration
isActive
segmentIsConversion
conversionValue

TIME

today
year
yearOfWeek
yearOfWeekIso
yearMonth
quarter
month
yearWeek
yearWeekIso
week
weekIso
dayOfMonth
dayOfWeekName
dayOfWeekNameIso
date

VISITORS

newVisitors
engagedVisitors
nonBouncedVisitorsRate
newVisitorCost
engagedVisitorCost