Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time | Year | clicks_year | dim | |
| Year of week (Sun-Sat) | clicks_year_of_week | dim | ||
| Year of week (Mon-Sun) | clicks_year_of_week_iso | dim | ||
| Year & month | clicks_year_month | dim | ||
| Month | clicks_month | dim | ||
| Year & week (Sun-Sat) | clicks_year_week | dim | ||
| Year & week (Mon-Sun) | clicks_year_week_iso | dim | ||
| Week (Sun-Sat) | clicks_week | dim | ||
| Week (Mon-Sun) | clicks_week_iso | dim | ||
| Day of month | clicks_day_of_month | dim | ||
| Day of week (Sun-Sat) | clicks_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | clicks_day_of_week_name_iso | dim | ||
| Date | clicks_date | dim | ||
| Datetime | clicks_atom | dim | ||
| Account | Vendor | clicks_vendor_name | dim | Name of the vendor |
| Product | clicks_product_name | dim | Name of the product | |
| Category | clicks_category | dim | The category where the click occurred | |
| Channel | clicks_channel | dim | The site where the click occurred | |
| Country | clicks_country | dim | The country where the click occurred | |
| Clicks | clicks_clicks | met | Number of clicks | |
| Cost (USD) | clicks_cost | met | Advertising cost in USD | |
| Cost (EUR) | clicks_cost_from_usd_to_eur | met | Advertising cost converted to EUR. | |
| Cost (GBP) | clicks_cost_from_usd_to_gbp | met | Advertising cost converted to GBP | |
| CPC | clicks_cost_per_click | met | Cost per Click. Cost / clicks | |
| Conversions | clicks_conversions | met | Number of conversions | |
| Conversion rate | clicks_conversion_rate | met | Conversions divided by clicks | |
| CPL | clicks_cost_per_lead | met | Cost per lead. Cost / conversions | |
| Average position | clicks_avg_position | met | Average position for the requested period. Note: the value is calculated as average of daily average values. |