Supermetrics brings all your marketing data into Google Sheets, Google Data Studio, Excel, BigQuery, Snowflake, Redshift, Azure
| Category | Field | Code | Type | Description |
|---|---|---|---|---|
| Time | Year | reviews_year | dim | |
| Year of week (Sun-Sat) | reviews_year_of_week | dim | ||
| Year of week (Mon-Sun) | reviews_year_of_week_iso | dim | ||
| Year & month | reviews_year_month | dim | ||
| Month | reviews_month | dim | ||
| Year & week (Sun-Sat) | reviews_year_week | dim | ||
| Year & week (Mon-Sun) | reviews_year_week_iso | dim | ||
| Week (Sun-Sat) | reviews_week | dim | ||
| Week (Mon-Sun) | reviews_week_iso | dim | ||
| Day of month | reviews_day_of_month | dim | ||
| Day of week (Sun-Sat) | reviews_day_of_week_name | dim | ||
| Day of week (Mon-Sun) | reviews_day_of_week_name_iso | dim | ||
| Date | reviews_date | dim | ||
| Datetime | reviews_atom | dim | ||
| Reviews | ID | reviews_id | dim | ID of the review. |
| Title | reviews_title | dim | Title of the review. | |
| Rating | reviews_rating | dim | Rating of the review. | |
| Reviewer name | reviews_reviewer | dim | Name of the reviewer. | |
| Reviewer details | reviews_reviewer_details | dim | The details of the reviewer. | |
| Company size | reviews_company_size | dim | Size of the company. | |
| Reviewer role | reviews_reviewer_role | dim | Role of the reviewer. | |
| Avatar | reviews_reviewer_avatar | dim | Avatar of the reviewer. | |
| Text | reviews_text | dim | Text written for the review. | |
| Review date & time | reviews_review_datetime | dim | Date and time when the review was written. | |
| Review date | reviews_review_date | dim | Date when the review was written. | |
| Link to the review | reviews_url | dim | Link of the review. | |
| Number of reviews | reviews_number_of_reviews | met | Total number of reviews. | |
| Average rating | reviews_avg_rating | met | Average rating of the review. |