Introduction

Datasources and destinations

Fields listing for g2 Review

Review ID
Unique identifier for the review
Field IDid
TypeNUMBER
Data Typedimension
Review Date
Date when the review was posted
Field IDdatetime
TypeYEAR_MONTH_DAY
Data Typedimension
Rating
Star rating given in the review
Field IDrating
TypeNUMBER
Data Typemetric
Review Title
Title of the review
Field IDtitle
TypeTEXT
Data Typedimension
Review Text
Content of the review
Field IDtext
TypeTEXT
Data Typedimension
Reviewer Name
Name of the reviewer
Field IDreviewer
TypeTEXT
Data Typedimension
Reviewer Details
Details about the reviewer
Field IDreviewer_details
TypeTEXT
Data Typedimension
Reviewer Role
Role of the reviewer
Field IDreviewer_role
TypeTEXT
Data Typedimension
Company Size
Size of the reviewer's company
Field IDcompany_size
TypeTEXT
Data Typedimension
Reviewer Avatar
URL of the reviewer's avatar image
Field IDreviewer_avatar
TypeURL
Data Typedimension
Review URL
Link to the original review on G2
Field IDurl
TypeURL
Data Typedimension
Review Count
Total number of reviews for the product
Field IDreview_count
TypeNUMBER
Data Typemetric
Ease of Use Rating
Rating for ease of use
Field IDease_of_use_rating
TypeNUMBER
Data Typemetric
Quality of Support Rating
Rating for quality of support
Field IDquality_of_support_rating
TypeNUMBER
Data Typemetric
Ease of Setup Rating
Rating for ease of setup
Field IDease_of_setup_rating
TypeNUMBER
Data Typemetric
Average Rating
Average rating across all reviews
Field IDaverage_rating
TypeNUMBER
Data Typemetric
Stars Count - 5 Stars
Number of 5-star ratings
Field IDstars_count.5_stars
TypeNUMBER
Data Typemetric
Stars Count - 4 Stars
Number of 4-star ratings
Field IDstars_count.4_stars
TypeNUMBER
Data Typemetric
Stars Count - 3 Stars
Number of 3-star ratings
Field IDstars_count.3_stars
TypeNUMBER
Data Typemetric
Stars Count - 2 Stars
Number of 2-star ratings
Field IDstars_count.2_stars
TypeNUMBER
Data Typemetric
Stars Count - 1 Star
Number of 1-star ratings
Field IDstars_count.1_stars
TypeNUMBER
Data Typemetric
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
TypeYEAR
Data Typedimension
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
TypeYEAR_QUARTER
Data Typedimension
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
TypeYEAR_MONTH
Data Typedimension
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
TypeYEAR_WEEK
Data Typedimension
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
TypeQUARTER
Data Typedimension
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
TypeMONTH
Data Typedimension
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
TypeWEEK
Data Typedimension
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
TypeMONTH_DAY
Data Typedimension
Date and Hour
Month and day
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Date
Year month day data
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
TypeYEAR_MONTH_DAY
Data Typedimension
Day of the week
Day of the week
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
TypeDAY_OF_WEEK
Data Typedimension
Day of the year
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
TypeDAY
Data Typedimension
Extracted Date
The date where the extraction take times.
Field ID_catchr_date_extract
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Platform Name
Return the platform name
Field ID_catchr_platform_name
TypeTEXT
Data Typedimension