Reviews data dictionary

For more information on the G2 + Snowflake integration, refer to the Get started with Snowflake documentation.

Column name	Data type	Description	Example value
review_id	number	The unique ID generated for the review.	7072685
review_url	varchar	The direct URL to the review on G2.com.	https://www.g2.com/products/g2/reviews/g2-review-4671454
product_id	varchar	The ID for the product reviewed. This column corresponds to `product_id` in the Buyer Intent table.	47d9f613-8052-47d0-9770-2cdf09106348
reviewed_product	varchar	The name of the product reviewed.	G2 Marketing Solutions
submitted_date	date	The date that the review was submitted for approval.	2021-05-04
review_for_categories	array	The G2 categories where the product was used, selected by the reviewer.	["Buyer Intent Data Providers", "Technology Review Platforms"]
user_role	varchar	Response to: "What is your primary role when using this product?" Answer choices: User, Administrator, Executive Sponsor, Internal Consultant, Consultant, Agency, Industry Analyst, Tech Writer	Administrator
star_rating	float	The star rating associated with the review, ranging from 0 to 5.	4.5
review_title	varchar	The title for the review, entered by the reviewer.	G2 Has Been Great - Good for Marketers
love	varchar	Response to: "What do you like best?" Answers are free-response, with a minimum of 40 characters and no maximum.	When I've provided feedback, G2 has listened to it and accomodated it.
hate	varchar	Response to: "What do you dislike?" Answers are free-response, with a minimum of 40 characters and no maximum.	There's not really a ton that I dislike. Again, I can't speak to too many of G2's products as I've only dabbled in a couple.
recommendations	varchar	Response to: "Recommendations to others considering `{reviewed_product}`:" Answers are free-response, with a minimum of 40 characters and no maximum. As of July 2022, this question is only displayed on the review form for service providers.	Start small and add as you choose after learning more about each product - there's a lot there!
benefits	varchar	Response to: "What business problems are you solving? What benefits have you realized?" Answers are free-response, with a minimum of 40 characters and no maximum.	We're able to gather quality leads from G2 that we otherwise wouldn't have had.
meets_requirements	float	Response to: "Does `{reviewed_product}` meet all of your requirements?" Answer choices range from 1 - 7.	6
price	float	Response to: “Price" Answer choices range from 1 - 7.	6
ease_of_setup	float	Response to: “Was `{reviewed_product}` easy to set up and rollout?” Answer choices range from 1 - 7.	6
nps	float	Response to: “How likely is it that you would recommend `{reviewed_product}` to a friend or colleague?” Answer choices range from 0 - 10.	6
ease_of_admin	float	Response to: “Is `{reviewed_product}` easy to administer?” Answer choices range from 1 - 7.	6
ease_of_use	float	Response to: “Is `{reviewed_product}` easy to use?” Answer choices range from 1 - 7.	6
quality_of_support	float	Response to: “Is the support team able to answer your questions or support cases quickly and effectively?" Answer choices range from 1 - 7.	6
ease_of_doing_business_with	float	Response to: “Has `{reviewed_product}` been a good partner in doing business?" Answer choices range from 1 - 7.	6
going_in_right_direction	varchar	Response to “Is `{reviewed_product}` headed in the right direction?” Answer choices: Yes, No, Don't Know	Yes
experience_with_product	varchar	Response to: "What is your level of experience with `{reviewed_product}`?" Answer choices: Trial/Evaluation Only, Still Implementing, Failed to Go Live, Less than 1 Year, 3-5 Years, >5 Years	3-5 Years
implementation_year	varchar	Response to: "When did you implement `{reviewed_product}`?", reported in years.	2017
implementation_method	varchar	Response to: "How did you implement `{reviewed_product}`?" Answer choices: In-House Team, Vendor Services Team, 3rd Party Consultant, Don't know	In-House Team
implementation_consultant	varchar	Response to: "Which service provider did you use to implement `{reviewed_product}`?" This question is only displayed if the reviewer selected 3rd Party Consultant as the `implementation_method`.	Service Provider X
deployment_type	varchar	Response to: "Did you deploy in the cloud or on-premise?" Answer choices: Hosted, On-premise	Hosted
go_live_time	varchar	Response to: "How long did it take you to go live?" Answer choices: < 1 day, < 1 month, 1-3 months, 3-6 months, 6-12 months, > 12 months, Never	3-6 months
implementation_cost	varchar	Response to: "What were your one-time costs for setting up `{reviewed_product}`?" Answer choices: $0-999, $10,000-24,999, $25,000-49,999, $50,000-99,999, $100,000-249,000, $250,000-499,999, $500,000-999,999, $1,000,000-2,499,999, $2,500,000-$4,999,999, $5,000,000+	$1,000-9,999
annual_cost	varchar	Response to: "What is your annual recurring cost for using `{product_name}`?" Answer choices: $0-999, $10,000-24,999, $25,000-49,999, $50,000-99,999, $100,000-249,000, $250,000-499,999, $500,000-999,999, $1,000,000-2,499,999, $2,500,000 - $4,999,999, $5,000,000+	$25,000-49,999
contract_term	varchar	Response to: "What is the term of your contract?" Answer choices: No Term, Month-to-month, 1 Year, 2 Years, 3 Years, 4+ Years	1 Year
contract_discount	varchar	Response to: "What % discount off list price did you receive?" Answer choices: 0-10%, 11-20%, 21-30%, 31-40%, 41-50%, 51-60%, 61-70%, 71-80%, 81-90%, 90%+	0-10%
users_purchased	varchar	Response to: "How many people use `{reviewed_product}` in your organization?" Answer chocies: 1-4, 5-9, 10-24, 25-49, 50-99, 100-249, 250-499, 500-999, 1,000-2,499, 2,500-4,999, 5,000-9,999, 10,000+	25-49
user_adoption	varchar	Response to: "What % of your users have fully adopted the system?" Answer choices: 0-10%, 11-20%, 21-30%, 31-40%, 41-50%, 51-60%, 61-70%, 71-80%, 81-90%, 90%+	90%+
estimated_roi	varchar	Response to: "What is your company's estimated ROI on this product (payback period in months)?" Answer choices: 6 months or less, 7-12 months, 13-24 months, 24-36 months, 37-48 months, 48+ months, Never Got Full Payback	7-12 months
switched_from_another_solution	varchar	Response to: "Did your company switch to `{reviewed_product}` from another software?" Answer choices: Yes, No, Don't Know	Yes
previous_solution_used	varchar	Response to: "What did you switch from?" Answer is selected from a dropdown containing all products listed on G2.	SaaS Company X
reason_for_switching	varchar	Response to: "Why did you switch? How does `{reviewed_product}` compare to your previous system?" Answers are free-response with no minimum or maximum.	"G2 is a more powerful and complete product suited for our business."
review_source	varchar	The review acquisition method. Example sources: g2_incentivized, organic, vendor, g2gives, unincentivized	organic
review_incentivized	boolean	Whether the reviewer received an incentive for submitting the review.	FALSE
response_language	varchar	The language tag associated with the reviewer's response.	en-us
anonymous	boolean	Whether the reviewer opted to publish their review anonymously.	TRUE
user_company	varchar	Response to: "At which organization did you most recently use `{reviewed_product}`?"	G2 Track
user_company_segment	varchar	The reviewer's market segment. Possible segments: Small Business, Mid Market, Enterprise	Mid Market
user_company_size	varchar	Response to: "What was your organization size when working with `{reviewed_product}`?" Answer choices: Myself Only, 2-10 employees, 11-50 employees, 51-200 employees, 201-500 employees, 501-1,000 employees, 1,001-5,000 employees, 5,001-10,000 employees, 10,001+ employees	500-1000 employees
user_company_industry	varchar	Response to: "What is your industry when using this product?" Answers are selected from a dropdown of industries.	Marketing and Advertising
user_region	varchar	The reviewer's global region.	APAC
user_country	varchar	The reviewer's country.	Australia
reference_opt_in	varchar	Response to: "Are you willing to be a reference for this software product or service?" Answer choices: accepted, declined, unanswered	unanswered
user_company_domain	varchar	Response to: "What was the URL of the organization where you most recently used `{reviewed_product}`?"	g2.com
all_company_domains	array	All website domains associated with the reviewer's company.	["g2crowd.com", "g2.com"]

Column name

Data type

Description

Example value

review_id

number

The unique ID generated for the review.

7072685

review_url

varchar

The direct URL to the review on G2.com.

https://www.g2.com/products/g2/reviews/g2-review-4671454

product_id

varchar

The ID for the product reviewed. This column corresponds to product_id in the Buyer Intent table.

47d9f613-8052-47d0-9770-2cdf09106348

reviewed_product

varchar

The name of the product reviewed.

G2 Marketing Solutions

submitted_date

date

The date that the review was submitted for approval.

2021-05-04

review_for_categories

array

The G2 categories where the product was used, selected by the reviewer.

["Buyer Intent Data Providers", "Technology Review Platforms"]

user_role

varchar

Response to: "What is your primary role when using this product?"
Answer choices: User, Administrator, Executive Sponsor, Internal Consultant, Consultant, Agency, Industry Analyst, Tech Writer

Administrator

star_rating

float

The star rating associated with the review, ranging from 0 to 5.

4.5

review_title

varchar

The title for the review, entered by the reviewer.

G2 Has Been Great - Good for Marketers

love

varchar

Response to: "What do you like best?"
Answers are free-response, with a minimum of 40 characters and no maximum.

When I've provided feedback, G2 has listened to it and accomodated it.

hate

varchar

Response to: "What do you dislike?"
Answers are free-response, with a minimum of 40 characters and no maximum.

There's not really a ton that I dislike. Again, I can't speak to too many of G2's products as I've only dabbled in a couple.

recommendations

varchar

Response to: "Recommendations to others considering {reviewed_product}:"
Answers are free-response, with a minimum of 40 characters and no maximum. As of July 2022, this question is only displayed on the review form for service providers.

Start small and add as you choose after learning more about each product - there's a lot there!

benefits

varchar

Response to: "What business problems are you solving? What benefits have you realized?"
Answers are free-response, with a minimum of 40 characters and no maximum.

We're able to gather quality leads from G2 that we otherwise wouldn't have had.

meets_requirements

float

Response to: "Does {reviewed_product} meet all of your requirements?"
Answer choices range from 1 - 7.

price

float

Response to: “Price"
Answer choices range from 1 - 7.

ease_of_setup

float

Response to: “Was {reviewed_product} easy to set up and rollout?”
Answer choices range from 1 - 7.

nps

float

Response to: “How likely is it that you would recommend {reviewed_product} to a friend or colleague?”
Answer choices range from 0 - 10.

ease_of_admin

float

Response to: “Is {reviewed_product} easy to administer?”
Answer choices range from 1 - 7.

ease_of_use

float

Response to: “Is {reviewed_product} easy to use?”
Answer choices range from 1 - 7.

quality_of_support

float

Response to: “Is the support team able to answer your questions or support cases quickly and effectively?"
Answer choices range from 1 - 7.

ease_of_doing_business_with

float

Response to: “Has {reviewed_product} been a good partner in doing business?"
Answer choices range from 1 - 7.

going_in_right_direction

varchar

Response to “Is {reviewed_product} headed in the right direction?”
Answer choices: Yes, No, Don't Know

Yes

experience_with_product

varchar

Response to: "What is your level of experience with {reviewed_product}?"
Answer choices: Trial/Evaluation Only, Still Implementing, Failed to Go Live, Less than 1 Year, 3-5 Years, >5 Years

3-5 Years

implementation_year

varchar

Response to: "When did you implement {reviewed_product}?", reported in years.

2017

implementation_method

varchar

Response to: "How did you implement {reviewed_product}?"
Answer choices: In-House Team, Vendor Services Team, 3rd Party Consultant, Don't know

In-House Team

implementation_consultant

varchar

Response to: "Which service provider did you use to implement {reviewed_product}?"
This question is only displayed if the reviewer selected 3rd Party Consultant as the implementation_method.

Service Provider X

deployment_type

varchar

Response to: "Did you deploy in the cloud or on-premise?"
Answer choices: Hosted, On-premise

Hosted

go_live_time

varchar

Response to: "How long did it take you to go live?"
Answer choices: < 1 day, < 1 month, 1-3 months, 3-6 months, 6-12 months, > 12 months, Never

3-6 months

implementation_cost

varchar

Response to: "What were your one-time costs for setting up {reviewed_product}?"
Answer choices: $0-999, $10,000-24,999, $25,000-49,999, $50,000-99,999, $100,000-249,000, $250,000-499,999, $500,000-999,999, $1,000,000-2,499,999, $2,500,000-$4,999,999, $5,000,000+

$1,000-9,999

annual_cost

varchar

Response to: "What is your annual recurring cost for using {product_name}?"
Answer choices: $0-999, $10,000-24,999, $25,000-49,999, $50,000-99,999, $100,000-249,000, $250,000-499,999, $500,000-999,999, $1,000,000-2,499,999, $2,500,000 - $4,999,999, $5,000,000+

$25,000-49,999

contract_term

varchar

Response to: "What is the term of your contract?"
Answer choices: No Term, Month-to-month, 1 Year, 2 Years, 3 Years, 4+ Years

1 Year

contract_discount

varchar

Response to: "What % discount off list price did you receive?"
Answer choices: 0-10%, 11-20%, 21-30%, 31-40%, 41-50%, 51-60%, 61-70%, 71-80%, 81-90%, 90%+

0-10%

users_purchased

varchar

Response to: "How many people use {reviewed_product} in your organization?"
Answer chocies: 1-4, 5-9, 10-24, 25-49, 50-99, 100-249, 250-499, 500-999, 1,000-2,499, 2,500-4,999, 5,000-9,999, 10,000+

25-49

user_adoption

varchar

Response to: "What % of your users have fully adopted the system?"
Answer choices: 0-10%, 11-20%, 21-30%, 31-40%, 41-50%, 51-60%, 61-70%, 71-80%, 81-90%, 90%+

90%+

estimated_roi

varchar

Response to: "What is your company's estimated ROI on this product (payback period in months)?"
Answer choices: 6 months or less, 7-12 months, 13-24 months, 24-36 months, 37-48 months, 48+ months, Never Got Full Payback

7-12 months

switched_from_another_solution

varchar

Response to: "Did your company switch to {reviewed_product} from another software?"
Answer choices: Yes, No, Don't Know

Yes

previous_solution_used

varchar

Response to: "What did you switch from?"
Answer is selected from a dropdown containing all products listed on G2.

SaaS Company X

reason_for_switching

varchar

Response to: "Why did you switch? How does {reviewed_product} compare to your previous system?"
Answers are free-response with no minimum or maximum.

"G2 is a more powerful and complete product suited for our business."

review_source

varchar

The review acquisition method.
Example sources: g2_incentivized, organic, vendor, g2gives, unincentivized

organic

review_incentivized

boolean

Whether the reviewer received an incentive for submitting the review.

FALSE

response_language

varchar

The language tag associated with the reviewer's response.

en-us

anonymous

boolean

Whether the reviewer opted to publish their review anonymously.

TRUE

user_company

varchar

Response to: "At which organization did you most recently use {reviewed_product}?"

G2 Track

user_company_segment

varchar

The reviewer's market segment.
Possible segments: Small Business, Mid Market, Enterprise

Mid Market

user_company_size

varchar

Response to: "What was your organization size when working with {reviewed_product}?"
Answer choices: Myself Only, 2-10 employees, 11-50 employees, 51-200 employees, 201-500 employees, 501-1,000 employees, 1,001-5,000 employees, 5,001-10,000 employees, 10,001+ employees

500-1000 employees

user_company_industry

varchar

Response to: "What is your industry when using this product?"
Answers are selected from a dropdown of industries.

Marketing and Advertising

user_region

varchar

The reviewer's global region.

APAC

user_country

varchar

The reviewer's country.

Australia

reference_opt_in

varchar

Response to: "Are you willing to be a reference for this software product or service?"
Answer choices: accepted, declined, unanswered

unanswered

user_company_domain

varchar

Response to: "What was the URL of the organization where you most recently used {reviewed_product}?"

g2.com

all_company_domains

array

All website domains associated with the reviewer's company.

["g2crowd.com", "g2.com"]

Reviews data dictionary

What's Next