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 | |
| Query | Start date | system_metadata.query_date_range_start | The start date of the requested query |
| End date | system_metadata.query_date_range_end | The end date of the requested query | |
| Timezone | system_metadata.query_timezone | The timezone that is supplied to the query | |
| Filters | system_metadata.query_filters | All filters used in the query | |
| Start | system_metadata.query_date_start | When the query was started | |
| End | system_metadata.query_date_end | When the query completed | |
| Duration | system_metadata.query_duration | The duration in seconds of the query | |
| Accounts | system_metadata.query_accounts | A list of accounts of which the data was pulled from | |
| Datasource | Data source logins | system_metadata.data_source_logins | The data source login accounts that were used to authenticate against the data source |
| Data source login owners | system_metadata.data_source_login_owners | The Supermetrics users that created the data source login connections |