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_review_id | dim | ID of the review. |
| Title | reviews_title | dim | Title of the review. | |
| Reviewer occupation | reviews_reviewer | dim | Occupation of the reviewer. | |
| Pros | reviews_pros | dim | Pros of the reviewed company. | |
| Cons | reviews_cons | dim | Cons of the reviewed company. | |
| Advice | reviews_advice | dim | Advice written for the management by the reviewer. | |
| Language | reviews_language | dim | Language of the review. | |
| Location | reviews_review_location | dim | Location of the review. | |
| Current job | reviews_is_current_job | dim | Whether it is the reviewers current job or not. | |
| Review link | reviews_url | dim | A link to the review. | |
| Review date & time | reviews_review_datetime | dim | Date & time of the review. | |
| Review date | reviews_review_date | dim | Date of the review. | |
| Overall rating | reviews_rating | dim | Overall rating of the review. | |
| Work life balance rating | reviews_work_life_balance | dim | Work and life balance rating. | |
| Culture and values rating | reviews_culture_and_values | dim | Culture and values rating. | |
| Diversity and inclusion rating | reviews_diversity_and_inclusion | dim | Diversity and inclusion rating. | |
| Career opportunities rating | reviews_career_opportunities | dim | Career opportunities rating. | |
| Compensation and benefits rating | reviews_compensation_and_benefits | dim | Compensation and benefits rating. | |
| Senior management rating | reviews_senior_management | dim | Senior management rating. | |
| CEO approval | reviews_ceo_approval | dim | CEO approval. | |
| Business outlook | reviews_business_outlook | dim | Business outlook. | |
| Recommend to a friend | reviews_recommend_to_a_friend | dim | Recommend to a friend. | |
| Reviews | reviews_reviews | met | Total number of reviews. | |
| Average rating | reviews_avg_rating | met | Average overall rating of the reviews. | |
| Average work life balance rating | reviews_work_life_balance_rating | met | Average Work life balance rating. | |
| Average culture and values rating | reviews_culture_and_values_rating | met | Average culture and values rating. | |
| Average diversity and inclusion rating | reviews_diversity_and_inclusion_rating | met | Average diversity and inclusion rating. | |
| Average career opportunities rating | reviews_career_opportunities_rating | met | Average career opportunities rating. | |
| Average compensation and benefits rating | reviews_compensation_and_benefits_rating | met | Average compensation and benefits rating. | |
| Average senior management rating | reviews_senior_management_rating | met | Average senior management rating. |