Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| TIME | Year | year | dim | |
| Year of week (Sun-Sat) | yearOfWeek | dim | ||
| Year of week (Mon-Sun) | yearOfWeekIso | dim | ||
| Year & month | yearMonth | dim | ||
| Month | month | dim | ||
| Year & week (Sun-Sat) | yearWeek | dim | ||
| Year & week (Mon-Sun) | yearWeekIso | dim | ||
| Week (Sun-Sat) | week | dim | ||
| Week (Mon-Sun) | weekIso | dim | ||
| Day of month | dayOfMonth | dim | ||
| Day of week (Sun-Sat) | dayOfWeekName | dim | ||
| Day of week (Mon-Sun) | dayOfWeekNameIso | dim | ||
| Date | date | dim | ||
| ACCOUNT | Account ID | accountId | dim | |
| Account name | accountName | dim | ||
| Account currency | accountCurrency | dim | Preferred currency of the ad account | |
| CAMPAIGN | Campaign ID | campaignId | dim | |
| Campaign name | campaignName | dim | ||
| AD SET | Ad set ID | adSetId | dim | |
| Ad set name | adSetName | dim | ||
| AD | Ad ID | adId | dim | |
| Ad name | adName | dim | ||
| STATUS | Running status | status | dim | |
| CONVERSION TYPES | Conversion type | conversionType | dim | Type of conversion |
| PERFORMANCE | Landing page URL | landingURL | dim | Landing URL of the ad |
| Conversions | conversions | met | Conversion count, taking into account attribution window and conversion type settings | |
| Clicks | clicks | met | ||
| Impressions | impressions | met | Number of times an ad/ad set/campaign has been seen | |
| Conversion rate (%) | conversionRate_perc | met | Conversions per clicks | |
| Cost per click | cpc | met | ||
| Cost per conversion | cpcon | met | ||
| CTR (%) | ctr_perc | met | Clicks per times seen | |
| SPENDING | Cost | spend | met | Advertising spend in USD |
| Cost (EUR) | cost_eur | met | Cost converted to Euros | |
| Cost (GBP) | cost_gbp | met | Cost converted to British pounds | |
| Cost (USD) | cost_usd | met | Cost converted to US dollars | |
| Daily budget | dailyBudget | met | Daily budget for advertising cost | |
| Lifetime budget | lifetimeBudget | met | Budget for advertising cost for the lifetime of a campaign | |
| Bid amount | bidAmount | met | Daily budget for advertising cost |