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 | Title | reviews_title | dim | Title of the review. |
Text | reviews_text | dim | Text written for the review. | |
Overall rating | reviews_rating | dim | Overall rating of the review. | |
ID | reviews_id | dim | ID of the review. | |
Language | reviews_language | dim | Language of the review. | |
Reviewer | reviews_reviewer | dim | Name of the reviewer. | |
Location | reviews_location | dim | Location of the reviewer. | |
Cons | reviews_cons | dim | Cons of the company. | |
Pros | reviews_pros | dim | Pros of the company. | |
Link to review | reviews_url | dim | A link to the review. | |
Review date | reviews_datetime | dim | Date when the review was written. | |
Reviewer employee type | reviews_reviewer_employee_type | dim | Employee type of the reviewer. | |
Job work and life balance rating | reviews_job_work_and_life_balance_rating | dim | Job work and life balance rating. | |
Compensation and benefits rating | reviews_compensation_and_benefits_rating | dim | Compensation and benefits rating. | |
Job security and advancement rating | reviews_job_security_and_advancement_rating | dim | Job security and advancement rating. | |
Management rating | reviews_management_rating | dim | Management rating. | |
Job culture rating | reviews_job_culture_rating | dim | Job culture rating. | |
Reviews | reviews_reviews | met | Number of reviews. | |
Avg Overall rating | reviews_avg_rating | met | Average Overall rating. | |
Avg Job work and life balance rating | reviews_avg_job_work_and_life_balance_rating | met | Average Job work and life balance rating. | |
Avg Compensation and benefits rating | reviews_avg_compensation_and_benefits_rating | met | Average Compensation and benefits rating. | |
Avg Job security and advancement rating | reviews_avg_job_security_and_advancement_rating | met | Average Job security and advancement rating. | |
Avg Management rating | reviews_avg_management_rating | met | Average Management rating. | |
Avg Job culture rating | reviews_avg_job_culture_rating | met | Average Job culture rating. |