The following data dictionary describes each column for the G2 Seller Review Data private listing in Snowflake.
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 |
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"] |