Review ID Unique identifier for the review | Field ID | id | Type | NUMBER | Data Type | dimension |
|
Review Date Date when the review was posted | Field ID | datetime | Type | YEAR_MONTH_DAY | Data Type | dimension |
|
Rating Star rating given in the review | Field ID | rating | Type | NUMBER | Data Type | metric |
|
Review Title Title of the review | Field ID | title | Type | TEXT | Data Type | dimension |
|
Review Text Content of the review | Field ID | text | Type | TEXT | Data Type | dimension |
|
Reviewer Name Name of the reviewer | Field ID | reviewer | Type | TEXT | Data Type | dimension |
|
Reviewer Details Details about the reviewer | Field ID | reviewer_details | Type | TEXT | Data Type | dimension |
|
Reviewer Role Role of the reviewer | Field ID | reviewer_role | Type | TEXT | Data Type | dimension |
|
Company Size Size of the reviewer's company | Field ID | company_size | Type | TEXT | Data Type | dimension |
|
Reviewer Avatar URL of the reviewer's avatar image | Field ID | reviewer_avatar | Type | URL | Data Type | dimension |
|
Review URL Link to the original review on G2 | Field ID | url | Type | URL | Data Type | dimension |
|
Review Count Total number of reviews for the product | Field ID | review_count | Type | NUMBER | Data Type | metric |
|
Ease of Use Rating Rating for ease of use | Field ID | ease_of_use_rating | Type | NUMBER | Data Type | metric |
|
Quality of Support Rating Rating for quality of support | Field ID | quality_of_support_rating | Type | NUMBER | Data Type | metric |
|
Ease of Setup Rating Rating for ease of setup | Field ID | ease_of_setup_rating | Type | NUMBER | Data Type | metric |
|
Average Rating Average rating across all reviews | Field ID | average_rating | Type | NUMBER | Data Type | metric |
|
Stars Count - 5 Stars Number of 5-star ratings | Field ID | stars_count.5_stars | Type | NUMBER | Data Type | metric |
|
Stars Count - 4 Stars Number of 4-star ratings | Field ID | stars_count.4_stars | Type | NUMBER | Data Type | metric |
|
Stars Count - 3 Stars Number of 3-star ratings | Field ID | stars_count.3_stars | Type | NUMBER | Data Type | metric |
|
Stars Count - 2 Stars Number of 2-star ratings | Field ID | stars_count.2_stars | Type | NUMBER | Data Type | metric |
|
Stars Count - 1 Star Number of 1-star ratings | Field ID | stars_count.1_stars | Type | NUMBER | Data Type | metric |
|
Year Year such as 2017. | Field ID | _NORMALIZED_DATE_FIELD_YEAR | Type | YEAR | Data Type | dimension |
|
Year Quarter Year and quarter. | Field ID | _NORMALIZED_DATE_FIELD_YEAR_QUARTER | Type | YEAR_QUARTER | Data Type | dimension |
|
Year month Year and month. | Field ID | _NORMALIZED_DATE_FIELD_YEAR_MONTH | Type | YEAR_MONTH | Data Type | dimension |
|
Year week Year and week. | Field ID | _NORMALIZED_DATE_FIELD_YEAR_WEEK | Type | YEAR_WEEK | Data Type | dimension |
|
Quarter of the year Quarter of the year | Field ID | _NORMALIZED_DATE_FIELD_QUARTER | Type | QUARTER | Data Type | dimension |
|
Month of the year Month of the year | Field ID | _NORMALIZED_DATE_FIELD_MONTH | Type | MONTH | Data Type | dimension |
|
Week of the year Week of the year | Field ID | _NORMALIZED_DATE_FIELD_WEEK | Type | WEEK | Data Type | dimension |
|
Month and day Month and day | Field ID | _NORMALIZED_DATE_FIELD_MONTH_DAY | Type | MONTH_DAY | Data Type | dimension |
|
Date and Hour Month and day | Field ID | _NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR | Type | YEAR_MONTH_DAY_HOUR | Data Type | dimension |
|
Date Year month day data | Field ID | _NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY | Type | YEAR_MONTH_DAY | Data Type | dimension |
|
Day of the week Day of the week | Field ID | _NORMALIZED_DATE_FIELD_DAY_OF_WEEK | Type | DAY_OF_WEEK | Data Type | dimension |
|
Day of the year Day of the year | Field ID | _NORMALIZED_DATE_FIELD_DAY | Type | DAY | Data Type | dimension |
|
Extracted Date The date where the extraction take times. | Field ID | _catchr_date_extract | Type | YEAR_MONTH_DAY_SECOND | Data Type | dimension |
|
Platform Name Return the platform name | Field ID | _catchr_platform_name | Type | TEXT | Data Type | dimension |
|