Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
Category | Field | Code | Description |
---|---|---|---|
TIME | Year | year | Year, e.g. 2017 |
Year of week (Sun-Sat) | yearOfWeek | Year of week for US weeks, e.g. 2017 | |
Year of week (Mon-Sun) | yearOfWeekIso | Year of week for ISO weeks, e.g. 2017 | |
Year & month | yearMonth | Year and month, e.g. 2017|06 | |
Quarter | quarter | Business quarter, e.g. Q1 | |
Month | month | Month, e.g. 6 | |
Year & week (Sun-Sat) | yearWeek | US week number, e.g. 51 | |
Year & week (Mon-Sun) | yearWeekIso | Year and week for ISO weeks, e.g. 2017|08 | |
Week (Sun-Sat) | week | Day of week name for US weeks, e.g. 0 Sunday | |
Week (Mon-Sun) | weekIso | ISO week number, e.g. 51 | |
Day of month | dayOfMonth | ||
Day of week (Mon-Sun) | dayOfWeekName | Day of week name for US weeks, e.g. 0 Sunday | |
Day of week (Mon-Sun) | dayOfWeekNameIso | Day of week name for US weeks, e.g. 0 Sunday | |
Date | date | Date, e.g. 2017-01-31 | |
ADVERTISER | Advertiser | advertisableName | Advertiser profile |
Advertiser EID | advertisableEid | EID of the advertiser | |
Advertiser status | advertisableStatus | Status of the advertiser: admin_review, approved or rejected | |
Advertiser created date | advertisableCreatedDate | Date the advertiser profile was created | |
Advertiser currency | advertisableCurrency | Currency code (ISO-4217) use by the advertiser's account | |
Is advertiser active | advertisableIsActive | Whether or not the advertiser is currently active | |
Business unit | businessUnit | The business unit this Advertisable has signed up for | |
Advertiser URL | url | Advertiser's URL | |
Organization EID | organization | EID of the advertiser's organization | |
Click-through conversions duration (days) | clickThroughConversionWindow | Duration of the advertiser's Click-through conversions conversion window in days | |
View-through conversions duration (days) | viewThroughConversionWindow | Duration of the advertiser's View-through conversions window in days | |
Rev share view | revshareViewPercent | Percentage of the rev share views | |
Rev share click | revshareClickPercent | Percentage of the rev share clicks | |
CAMPAIGN | Campaign | campaignName | Name of the campaign |
Campaign EID | campaignEid | EID of the campaign | |
Campaign type | campaignType | Type for the campaign: prospecting, blended or retargeting | |
Campaign status | campaignStatus | Status of the campaign: running, ended, paused, review, draft, rejected or deleted | |
Campaign currency | campaignCurrency | ISO-4217 currency code for the given amount | |
Budget | budget | Daily budget of the campaign | |
Max CPM | maxCpm | Maximum CPM for the campaign | |
Campaign created date | campaignCreatedDate | Date the campaign was created | |
Campaign updated date | campaignUpdatedDate | Date the campaign was last updated | |
Channel | channel | Campaign channel: email, social or web | |
Campaign start date | startDate | Date the campaign started | |
Campaign end date | endDate | Date the campaign ended, exclusive | |
KPI currency | kpiCurrency | ISO 4217 currency code for kpiGoal. If not provided assume the currency provided at the Advertiser level | |
KPI goal | kpiGoal | Goal for the kpiMetric that drives the campaign's bid strategy. Null for automatic | |
KPI metric | kpiMetric | Metric being targeted by the campaign's bid strategy | |
Source | source | Service responsible for the creation of the campaign | |
ADGROUP | Adgroup | adgroupName | Name of the adgroup |
Adgroup EID | adgroupEid | EID of the adgroup | |
Adgroup status | adgroupStatus | Adgroup status: approved, paused, draft, rejected or deleted | |
Adgroup created date | adgroupCreatedDate | Date the adgroup was created | |
Adgroup updated datetime | adgroupUpdatedDate | Date the adgroup was last updated | |
Is adgroup active | adgroupIsActive | Whether or not the adgroup is currently active | |
Ad optimization | adOptimization | Strategy used to optimize ads when multiple ads fit a single ad space | |
Site exclusions | siteExclusions | List of excluded domains for the adgroup, with ad format information, if any | |
Flights | flights | Scheduled flight periods when ads will be served. Null if there is no limitation | |
Flight timezone | flightTimezone | Timezone preference of all flights of this adgroup | |
AD | Ad | adName | Name of the ad |
Ad EID | adEid | EID of the ad | |
Ad type | adType | Ad type: liquid, image, flash or ad_network | |
Ad status | adStatus | Ad status: approved, paused, review, draft, rejected or deleted | |
Ad created date | adCreatedDate | Date the ad was created | |
Ad updated date | adUpdatedDate | Date the ad was last updated | |
Is ad active | adIsActive | Whether or not the ad is currently active | |
Ad format ID | adFormatID | Corresponding ad format ID in the AdRoll system | |
Ad format | adFormat | Format string. i.e. '300 wide x 250 high' | |
Ad format | adFormatName | Format string. i.e. '300x250' | |
Has future campaigns | hasFutureCampaigns | Whether or not the ad has the possibility of serving based on the adgroups & campaigns in which it inhabits | |
Ad destination URL | destinationURL | URL that the browser will navigate to when the ad is clicked | |
utm_source parameter value | utm_source | utm_source parameter value from the destination URL, can be used to join with Google Analytics data | |
utm_medium parameter value | utm_medium | utm_medium parameter value from the destination URL, can be used to join with Google Analytics data | |
utm_campaign parameter value | utm_campaign | utm_campaign parameter value from the destination URL, can be used to join with Google Analytics data | |
utm_term parameter value | utm_term | utm_term parameter value from the destination URL, can be used to join with Google Analytics data | |
utm_content parameter value | utm_content | utm_content parameter value from the destination URL, can be used to join with Google Analytics data | |
Ad headline | headline | For Facebook ads, the text to be displayed as the ad's headline | |
Ad body | body | For Facebook ads, the text to be displayed as the ad's body | |
Ad message | message | For Facebook Newsfeed ads, the text to be displayed as the ad\s message | |
Original Ad | originalAd | EID of the ad that was edited to create the ad | |
Ad source | src | Ad's creative's source URL | |
Ad image | ad_image | Ad's creative image | |
Has edits | hasEdits | Whether or not the ad has been edited such that another ad has it's original ad parameter set to this ad's EID | |
Has pending edits | hasPendingEdits | Whether or not the ad has edits that must be reviewed by an AdRoll administrator | |
Is outlined | isOutlined | Whether or not an outline has been applied to the ad to satisfy network compliance | |
Valid click tag | validClicktag | Flag showing if the ad is in flash format, whether or not the clickTAG is compliant | |
AdRoll EID | adrollEID | AdRoll EID for prospecting ads | |
Ad height | height | Height in pixels of the ad's creative | |
Ad width | width | Width in pixels of the ad's creative | |
Ad outline color | outlineColor | Hexadecimal color code corresponding to the outline of an ad | |
SEGMENT | Segment EID | eid | EID of the segment |
Segment name | name | Name of the segment, for use internally and for JS segment matching | |
Segment type | type | Type of the segment: c or s (c=Conversion, s=Segment) | |
Segment tags | tags | Tags explicitly assigned to the segment | |
Segment currency | segmentCurrency | The value of a conversion from this segment | |
Segment duration | duration | Duration of the segment, in days | |
Is segment active | isActive | Indicates if segment was deleted or active | |
Is segment conversion | segmentIsConversion | Is the audience a conversion audience | |
PLACEMENT | Placement | placement | Placement of the Ad in Facebook. For example "desktop", "feed" |
AUDIENCE | Audience | audienceName | Name of the audience |
Audience EID | audienceEid | EID of the audience | |
Audience type | audienceType | The type of the segment. url, crm, pages_viewed, products_viewed, etc | |
Audience campaign | audienceCampaign | Campaign for the audience | |
Advertiser audience | audienceAdvertisable | Advertiser EID for the audience | |
Audience currency | audienceCurrency | Currency code (ISO-4217) for the audience. Default to the Advertiser's currency | |
Segment EID | segmentEID | EID of the segment | |
Description | description | Pieces to build the Audience's description formatted following the type | |
Audience created date | audienceCreatedDate | Date the audience was created | |
Inclusion | inclusion | Is the audience an inclusion audience | |
Is conversion audience | isConversion | Is the audience a conversion audience | |
GRANULAR CONVERSIONS | AdRoll conversion ID | adrollConversionId | The unique identifier for the attributed or influenced conversion |
Device | device | The device where the conversion happened | |
Conversion time | time | When the conversion happened | |
Country | country | The country where the conversion happened | |
Country code | countryCode | The two-letter code of the country where the conversion happened | |
City | city | The city where the conversion happened | |
Cookie | cookie | The AdRoll cookie that was used to track this conversion's journey | |
Ad size | adSize | Size of the converting ad | |
Referrer URL | referrerURL | URL preceding the conversion | |
Days to conversion first touch | daysToConversionFirstTouch | Time from first AdRoll touch to conversion (days) | |
Days to conversion last touch | daysToConversionLastTouch | Time from last AdRoll touch to conversion (days) | |
First touch timestamp | firstTouchTimestamp | When the first AdRoll touch occurred | |
Last touch timestamp | lastTouchTimestamp | When the final AdRoll touch occurred | |
External data | externalData | Data recorded by the AdRoll Pixel on the conversion event | |
Last touch attribution | lastTouchAttribution | True if it has been attributed as last touch | |
Touchpoint timestamp | touchpointTimestamp | The last preceding AdRoll touchpoint, such as an impression or a click | |
Attribution credit | attributionCredit | The type of credit assigned: "attributed" or "influenced" | |
Attribution model | attributionModel | The attribution model applied at the time of conversion | |
DEPRECATED | Placement targets | placementTargets | List of strings for an adgroup's placement targets. Each entry can have a value of: all, newsfeed or rightcolumn. Please note that this field will be removed on 2020-04-28 |
Is a B2B customer | advertisableIsB2B | Whether or not the advertiser is a B2B customer. Please note that this field will be removed on 2022-04-28 | |
Segments | segments | List for the segments attached to the adgroup. Each entry has "id" and "is_negative" fields. Please note that this field will be removed on 2020-04-28 | |
Platform targets | platformTargets | List for the adgroup's platform targets. Please note that this field will be removed on 2020-04-28 |