Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure

Field list for StackAdapt

45 metrics and 24 dimensions available

CategoryFieldCodeTypeDescription
TIMEYearyeardimYear, e.g. 2017
Year of week (Sun-Sat)yearofweekdimYear of week for US-style Sunday-Saturday weeks, e.g. 2017
Year of week (Mon-Sun)yearofweekisodimYear of week for ISO standard Monday-Sunday weeks, e.g. 2017
Year & monthyearmonthdimYear and month, e.g. 2017|06
MonthmonthdimMonth, e.g. 6
Year & week (Sun-Sat)yearweekdimYear and week for US-style Sunday-Saturday weeks, e.g. 2017|08
Year & week (Mon-Sun)yearweekisodimYear and week for ISO standard Monday-Sunday weeks, e.g. 2017|08
Week (Sun-Sat)weekdimUS week number, e.g. 51
Week (Mon-Sun)weekisodimISO week number, e.g. 51
Day of monthdayofmonthdimDay of month, e.g. 2
Day of week (Sun-Sat)dayofweeknamedimDay of week number & name for US-style Sunday-Saturday weeks, e.g. 0 Sunday
Day of week (Mon-Sun)dayofweeknameisodimDay of week number & name for ISO standard Monday to Sunday weeks, e.g. 1 Sunday
DatedatedimDate, e.g. 2017-01-31
ADVERTISERAdvertiseradvertiserdimName of advertiser, typically an agency or brand
Advertiser IDadvertiser_iddimUnique ID of the advertiser
CAMPAIGNCampaign groupline_itemdimName of the campaign group, which organizes campaigns into one marketing initiative
CampaigncampaigndimName of the campaign, which consists of creatives, targeting, and technical parameters to drive objectives
Campaign IDcampaign_iddimUnique ID of the campaign
Campaign typecampaign_typedimDescribes the type of campaign, native or video
NATIVE ADCreative adnative_addimName of ad creative
Creative ad IDnative_ad_iddimUnique ID of ad creative
HeadingheadingdimHeading text used in ad creative
TaglinetaglinedimTagline text used in ad creative
Click URLclick_urldimURL used in ad creative to drive users to a specific site
BASICImpressionsimpressionsmetTotal number of Impressions served
Unique impressionsimpressions_uniquemetTotal number of unique people who were shown an ad
ClicksclicksmetTotal number of clicks registered
CTRctrmetClick-through rate; Clicks divided by impressions
Media costcostmetTotal budget spent on campaign
CPCcpcmetCost per click; Media cost divided by Clicks
CPMcpmmetCost per mille; Media cost divided by Impressions x 1000
CPEcpemetCost per click; Media cost divided by Engagement
eCPCLecpclmetEffective cost per completed listen. Calculated by Media cost / Audio completed
FrequencyfrequencymetImpressions per unique impression
Third-party CPC costtpcpc_costmetThird-party CPC cost
Third-party CPM costtpcpm_costmetThird-party CPM cost
CONVERSIONSConversionsconversionsmetTotal number of times conversion event took place
Conversion ratecvrmetConversions divided by clicks
Cost per conversioncpametMedia cost divided by Conversions
Impression conversionsimpression_conversionsmetNumber of impression conversions
Click conversionsclick_conversionsmetNumber of click conversions
Conversion revenueconversion_revenuemetRevenue generated through conversions
RevenuerevenuemetTotal budget spent including margin
ProfitprofitmetMargin kept from total budget
View-through conversionsviewthrough_conversionsmetNumber of view-through conversions
Unique conversionsunique_conversionsmetNumber of times a unique conversion event took place
Cookie conversionscookie_conversionsmetCookie conversions
IP conversionsip_conversionsmetIP conversions
Secondary conversionssecondary_conversionsmetSecondary conversions
ENGAGEMENTPage startspage_startsmetNumber of times user spent least 2 seconds on site
15s Engagements (LP)page_time_15smetNumber of times user has spent at least 15 seconds on the advertiser's domain after clicking the ad
Total time on pagepage_timemetTotal time spent on site
Engagement rateengagement_ratemetEngagement divided by clicks
Average time on siteatosmetAverage time on site (seconds)
VIDEOVideo startedvcomp_0metVideo views started
Video completed to 25 %vcomp_25metVideo watched to at least 25 %
Video completed to 50 %vcomp_50metVideo watched to at least 50 %
Video completed to 75 %vcomp_75metVideo watched to at least 75 %
Video completedvcomp_95metVideo watched to at least 95 %
Completion ratevcomp_ratemetVideo completion rate. Calculated by Video completed / Video started
AUDIOAudio startedaudio_startsmetAudio started
Audio completedaudio_completionsmetAudio completed
Audio completion rateaudio_completion_ratemetListen through rate, calculated by Audio completed / Audio started
REVENUErCPArcpametRevenue cost per action. Calculated by Revenue / Conversions
rCPCrcpcmetRevenue cost per click. Calculated by Revenue / Click
rCPCLrcpclmetRevenue cost per completed listen. Calculated by Revenue / Audio completed
rCPErcpemetRevenue cost per engagement. Calculated by Revenue / 15s Engagements (LP)
rCPMrcpmmetRevenue cost per mile. Calculated by (Revenue / Impressions) * 1000
ROASroasmetReturn on ad spend. Calculated by Revenue / Media cost