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 |
|