--- title: "Market Intelligence data dictionary" slug: "snowflake-market-intelligence-data-dictionary" updated: 2023-06-23T14:36:14Z published: 2023-06-23T14:36:14Z canonical: "documentation.g2.com/snowflake-market-intelligence-data-dictionary" --- > ## Documentation Index > Fetch the complete documentation index at: https://documentation.g2.com/llms.txt > Use this file to discover all available pages before exploring further. # Market Intelligence data dictionary The following data dictionary describes each column for the *G2 Market Intelligence Data* private listing in Snowflake. For more information on the G2 + Snowflake integration, refer to the [Get started with Snowflake](/docs/snowflake) documentation. To learn more about G2 Market Intelligence, refer to the [Market Intelligence](https://documentation.g2.com/docs/market-intelligence) documentation. | Column name | Data type | Description | Example value | | --- | --- | --- | --- | | Review URL | varchar | The direct URL to the review on G2.com. | https://www.g2.com/products/g2/reviews/g2-review-4671454 | | Reviewed Date | varchar | The date that the review was submitted for approval, in YYYY-MM-DD format. | 2021-05-04 | | 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 | | Product | varchar | The name of the product reviewed. | G2 Marketing Solutions | | User Company Segment | varchar | The reviewer's market segment. Possible segments: *Small Business*, *Mid Market*, *Enterprise* | Mid Market | | 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 | | 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 | | Going in Right Direction | varchar | Response to “Is `{reviewed_product}` headed in the right direction?” Answer choices: *Yes*, *No*, *Don't Know* | Yes | | Ease of Setup | float | Response to: “Was `{reviewed_product}` easy to set up and rollout?” 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 | | Meets Requirements | float | Response to: "Does `{reviewed_product}` meet all of your requirements?" Answer choices range from 1 - 7. | 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 | | 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. | | Price | float | Response to: “Price" Answer choices range from 1 - 7. | 6 | | 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 | | Deployed in the Cloud? | 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." | | Reason for Switching Theme | varchar | The Market Intelligence theme associated with the review. G2 analyzes review data to find common themes for switching products. For more information, refer to the [Market Intelligence](https://documentation.g2.com/docs/market-intelligence#switching-themes) documentation. | performance | | Reviewed for Categories | array | The G2 categories where the product was used, selected by the reviewer. | ["Buyer Intent Data Providers", "Technology Review Platforms"] | | User Country Code | varchar | The two-letter code for the reviewer's country. | US |