Contents x
    Reviews data dictionary
    • 18 Mar 2023
    • 5 Minutes to read
    • Dark
      Light
    Contents

    Reviews data dictionary

    • Updated on 18 Mar 2023
    • 5 Minutes to read
    • Dark
      Light
    Article Summary

    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 nameData typeDescriptionExample value
    review_idnumberThe unique ID generated for the review.7072685
    review_urlvarcharThe direct URL to the review on G2.com.https://www.g2.com/products/g2/reviews/g2-review-4671454
    product_idvarcharThe ID for the product reviewed. This column corresponds to product_id in the Buyer Intent table.47d9f613-8052-47d0-9770-2cdf09106348
    reviewed_productvarcharThe name of the product reviewed.G2 Marketing Solutions
    submitted_datedateThe date that the review was submitted for approval.2021-05-04
    review_for_categoriesarrayThe G2 categories where the product was used, selected by the reviewer.["Buyer Intent Data Providers", "Technology Review Platforms"]
    user_rolevarcharResponse 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_ratingfloatThe star rating associated with the review, ranging from 0 to 5.4.5
    review_titlevarcharThe title for the review, entered by the reviewer.G2 Has Been Great - Good for Marketers
    lovevarcharResponse 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.
    hatevarcharResponse 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.
    recommendationsvarcharResponse 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!
    benefitsvarcharResponse 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_requirementsfloatResponse to: "Does {reviewed_product} meet all of your requirements?"
    Answer choices range from 1 - 7.    		6
    pricefloatResponse to: “Price"
    Answer choices range from 1 - 7.    		6
    ease_of_setupfloatResponse to: “Was {reviewed_product} easy to set up and rollout?”
    Answer choices range from 1 - 7.    		6
    npsfloatResponse 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_adminfloatResponse to: “Is {reviewed_product} easy to administer?”
    Answer choices range from 1 - 7.    		6
    ease_of_usefloatResponse to: “Is {reviewed_product} easy to use?”
    Answer choices range from 1 - 7.    		6
    quality_of_supportfloatResponse 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_withfloatResponse to: “Has {reviewed_product} been a good partner in doing business?"
    Answer choices range from 1 - 7.    		6
    going_in_right_directionvarcharResponse to “Is {reviewed_product} headed in the right direction?”
    Answer choices: Yes, No, Don't Know    		Yes
    experience_with_productvarcharResponse 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_yearvarcharResponse to: "When did you implement {reviewed_product}?", reported in years.2017
    implementation_methodvarcharResponse 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_consultantvarcharResponse 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_typevarcharResponse to: "Did you deploy in the cloud or on-premise?"
    Answer choices: Hosted, On-premise    		Hosted
    go_live_timevarcharResponse 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_costvarcharResponse 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_costvarcharResponse 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_termvarcharResponse 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_discountvarcharResponse 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_purchasedvarcharResponse 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_adoptionvarcharResponse 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_roivarcharResponse 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_solutionvarcharResponse to: "Did your company switch to {reviewed_product} from another software?"
    Answer choices: Yes, No, Don't Know    		Yes
    previous_solution_usedvarcharResponse to: "What did you switch from?"
    Answer is selected from a dropdown containing all products listed on G2.    		SaaS Company X
    reason_for_switchingvarcharResponse 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_sourcevarcharThe review acquisition method.
    Example sources: g2_incentivized, organic, vendor, g2gives, unincentivized    		organic
    review_incentivizedbooleanWhether the reviewer received an incentive for submitting the review.FALSE
    response_languagevarcharThe language tag associated with the reviewer's response.en-us
    anonymousbooleanWhether the reviewer opted to publish their review anonymously.TRUE
    user_companyvarcharResponse to: "At which organization did you most recently use {reviewed_product}?"G2 Track
    user_company_segmentvarcharThe reviewer's market segment.
    Possible segments: Small Business, Mid Market, Enterprise    		Mid Market
    user_company_sizevarcharResponse 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_industryvarcharResponse to: "What is your industry when using this product?"
    Answers are selected from a dropdown of industries.    		Marketing and Advertising
    user_regionvarcharThe reviewer's global region.APAC
    user_countryvarcharThe reviewer's country.Australia
    reference_opt_invarcharResponse to: "Are you willing to be a reference for this software product or service?"
    Answer choices: accepted, declined, unanswered    		unanswered
    user_company_domainvarcharResponse to: "What was the URL of the organization where you most recently used {reviewed_product}?"g2.com
    all_company_domainsarrayAll website domains associated with the reviewer's company.["g2crowd.com", "g2.com"]
    What's Next