- 26 Mar 2024
- 9 Minutes to read
- Dark
Get started with Snowflake
- Updated on 26 Mar 2024
- 9 Minutes to read
- Dark
The G2 + Snowflake integration helps you make smarter product, marketing, and revenue decisions by enabling you to leverage G2 Buyer Intent and review data alongside your other business-critical data in Snowflake.
Already familiar with the basics of the G2 + Snowflake integration? Select one of the following links to skip to data dictionaries or use cases and sample queries:
Basics of the G2 + Snowflake integration
About G2 Buyer Intent data
G2 Buyer Intent captures enriched data about buyers researching your product across G2. Buyer Intent signals can be generated by a variety of buyer actions, including interacting with your G2 product profile page, comparing your product to a competitor, and viewing alternatives for a product in a shared category. This data enables your sales, marketing, and customer success teams to identify a buyer's stage in the buyer journey.
Refer to the Buyer Intent documentation for more information on signal types, checking the signals included in your subscription, and more.
How G2 data is provisioned in Snowflake
G2 uses Snowflake Private Listings to share access to Buyer Intent and review data for your product(s).
For each listing, G2 represents the corresponding data as a View within the SELLER_DATA_FEED schema.
For more information on materialized views, refer to Snowflake's Working with Materialized Views documentation.
Data delivery frequency
Your first delivery includes G2 Buyer Intent data starting from the date that your listing was created, and all historical G2 review data. New data is delivered daily.
Using G2 data in Snowflake
G2 offers a comprehensive data dictionary describing each column in the Buyer Intent and Reviews listings, as well as sample use cases and SQL queries to demonstrate how you can layer G2 data with your other data in Snowflake.
After completing the implementation steps you can preview Buyer Intent or review data for your product(s) directly in Snowsight.
To preview G2 data in Snowflake:
- Navigate to Data > Databases, select your database, then select SELLER_DATA_FEED > Views to access the corresponding view.
- From the schema panel, select Data Preview, choose your Warehouse, then select Preview to generate a preview of your data.
Implementation
This section details every step you need to take to implement the G2 + Snowflake integration.
Before getting started
Activating the G2 + Snowflake integration enables you to receive data for all of your G2-listed products that receive Buyer Intent data in your Snowflake workspace
To activate this integration, you will need to provide your organization’s account details.
Access your Snowflake account details:
- Log in to Snowsight.
- In the left sidebar, select the account dropdown, then hover over the name of your account to reveal the account details panel.
You can retrieve your cloud provider, region and account locator directly from the account details panel.
1. Set the Integration Status
To set your G2 + Snowflake integration status:
- Go to my.G2, then Integrations > Integration Hub.
- Select the Snowflake tile.
- Set the Integration Status slider to Active.
2. Connect your Snowflake account
To obtain access to G2’s Snowflake Private Listing you will need to provide your Snowflake account details.
Entering incorrect account details will delay the implementation process. For more information on how to access your Snowflake account details, refer to the Access your Snowflake account details section.
To enter your account details:
- Go to my.G2, then Integrations > Integration Hub.
- Select the Snowflake tile.
- Enter your Account Name, Organization Name, and Account Locator into the corresponding fields.
- Select Save.
3. Create a database
After receiving your account details, G2 will provision access to data within eight business days. To be able to query G2 data in Snowflake, you must generate a database from the corresponding listing(s).
To create a database from a listing:
- Log in to Snowsight, then navigate to Data > Private Sharing. Your G2 listings appear within the Privately Shared Listings section.
- Select a listing, then select Get.
- (Optional) Expand the Options panel to rename your database and configure access permissions for different Snowflake roles.
- Select Get to create your database.
Once your database is created, you can preview G2 data directly in Snowsight or begin writing queries.
Use cases and sample queries
G2 provides several example use cases and sample queries to help you understand how you can leverage G2 data in Snowflake.
The following queries use brackets to denote placeholders for information unique to your Snowflake warehouse, including specific values, table names, and database names.
For example, G2 uses the syntax [DATABASE]
to indicate that you should replace this value with the name of your database.
Create an account scoring and ABM prioritization model
The following query creates a basic account prioritization model by assigning a score to each Buyer Intent signal type.
G2 includes example scoring for demonstration purposes. You should adapt these values to your business and use case.
Sample output
PRODUCT_NAME | COMPANY_ID | COMPANY_NAME | COMPANY_DOMAIN | VISITOR_COUNTRY | VISITOR_REGION | G2_MOST_RECENT_VISIT | G2_INTENT_SCORE |
---|---|---|---|---|---|---|---|
{YOUR PRODUCT} | 123456 | SaaS Company X | saascompanyx.com | United States | Illinois | 2023-03-09T01:20:10Z | 112.923 |
{YOUR PRODUCT} | 78910 | SaaS Company Y | saascompanyy.com | United States | California | 2023-03-15T11:20:10Z | 35.563 |
Calculate ROI from your G2 Marketing Solutions investment
The following query tracks the number of opportunities sourced and influenced by G2 Buyer Intent data, and enables you to measure G2's impact on your win rate, deal size, and time to close.
Sample output
OPPORTUNITY_ID | OPPORTUNITY_PRODUCT_LINE | OPPORTUNITY_TYPE | OPPORTUNITY_STAGE | OPPORTUNITY_AMOUNT | CREATED_DATE | CLOSE_DATE | G2__TOTAL_TOUCHPOINTS | G2__INFLUENCE_TOUCHPOINTS | G2__SOURCED_TOUCHPOINTS |
---|---|---|---|---|---|---|---|---|---|
0064W000013usCLQAY | {YOUR PRODUCT} | New Business | Closed Lost | 25000 | 7/12/21 | 8/31/21 | 1 | 1 | 1 |
0064W0000191nZLQAY | {YOUR PRODUCT} | Renewal | Working | 22750 | 1/31/22 | 2/6/24 | 3 | 3 | 1 |
Monitor customer and prospect touchpoints
This query joins G2 Buyer Intent data with marketing and CRM data to help you assess customer and prospect journeys per market segment. Use this query to analyze how your current customers engage with G2 and the stage at which prospects interact with your G2 profile before becoming customers.
Sample output
COMPANY_ACCOUNT_TYPE | SEGMENT | ACCOUNT_RECORDS | ACCOUNTS_WITH_G2_VISITS | ACCOUNTS_WITH_G2_ENGAGEMENT | NET_NEW_G2_COMPANIES | NEW_ENGAGED_ON_G2 |
---|---|---|---|---|---|---|
Vendor - Prospect | Small Business | 98976 | 1550 | 1284 | 150 | 100 |
Vendor - Customer | Small Business | 1501 | 290 | 272 | 49 | 23 |
Track G2 review trends per region, industry, and market segment
The following query enables you to identify quarterly trends in your review volume, star rating, and net promotors for each of your products by grouping review data by region, industry, and market segment.
Sample output
REVIEW_DATE_PERIOD | REVIEWED_PRODUCT | REVIEWER_SEGMENT | REVIEWER_INDUSTRY | REVIEWER_REGION | G2_REVIEWS_TO_DATE | G2_RATING_TO_DATE | PROMOTER_COUNT_TO_DATE | DETRACTOR_COUNT_TO_DATE | NEW_REVIEWS | NEW_PROMOTERS | NEW_DETRACTORS |
---|---|---|---|---|---|---|---|---|---|---|---|
1/1/23 | {YOUR PRODUCT} | Enterprise | Computer Software | EMEA | 36 | 4.01388889 | 18 | 8 | 2 | 1 | 0 |
10/1/22 | {YOUR PRODUCT} | Enterprise | Computer Software | EMEA | 34 | 4.01470588 | 17 | 8 | 0 | 0 | 0 |
Identify opportunities for competitive positioning
This query helps you identify opportunities to position your product against competitors in your category by comparing G2 pageviews that exclusively feature your G2 profile versus pageviews that include your competitors, such as compare pageviews and alternatives pageviews.
Sample output
VISIT_PERIOD | PRODUCT_ID | PRODUCT_NAME | PAGE_TOPIC | VISITING_COMPANIES | TOTAL_VIEWS | COMPARISONS | COMPANIES_SEEKING_ALTERNATIVES |
---|---|---|---|---|---|---|---|
1/1/23 | 309cf298-0fa3-4bfb | {YOUR PRODUCT} | Cloud Compliance | 819 | 2069 | 92 | 354 |
10/1/22 | 309cf298-0fa3-4bfb | {YOUR PRODUCT} | Cloud Compliance | 697 | 1920 | 114 | 340 |