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 of week (Sun-Sat) | yearOfWeek | ||
| Year of week (Mon-Sun) | yearOfWeekIso | ||
| Year & month | yearMonth | ||
| Month | month | ||
| Year & week (Sun-Sat) | yearWeek | ||
| Year & week (Mon-Sun) | yearWeekIso | ||
| Week (Sun-Sat) | week | ||
| Week (Mon-Sun) | weekIso | ||
| Day of month | dayOfMonth | ||
| Day of week (Sun-Sat) | dayOfWeekName | ||
| Day of week (Mon-Sun) | dayOfWeekNameIso | ||
| Date | date | ||
| ACCOUNT | Account ID | accountId | |
| Account name | accountName | ||
| Account currency | accountCurrency | Preferred currency of the ad account | |
| CAMPAIGN | Campaign ID | campaignId | |
| Campaign name | campaignName | ||
| AD SET | Ad set ID | adSetId | |
| Ad set name | adSetName | ||
| AD | Ad ID | adId | |
| Ad name | adName | ||
| STATUS | Running status | status | |
| CONVERSION TYPES | Conversion type | conversionType | Type of conversion |
| PERFORMANCE | Landing page URL | landingURL | Landing URL of the ad |