Getting started with BigQuery

The G2 + BigQuery integration enables you to use G2 Buyer Intent data alongside your internal business data in BigQuery to support analytics, account prioritization, and go-to-market workflows.

Basics of the G2 + BigQuery 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.

Understanding how G2 data is delivered

G2 publishes Buyer Intent data to Google BigQuery and shares it with customers through Google Analytics Hub.

When you subscribe to a G2 listing, Analytics Hub creates a linked dataset in your BigQuery project. This dataset provides a live, read-only view of your Buyer Intent data.

Each linked dataset includes two resources:

• A Buyer Intent table containing interaction-level intent signals.
• A Companies view containing enriched firmographic data for companies in your Buyer Intent dataset.

The data remains in G2’s BigQuery project. Your linked dataset provides direct query access without copying or syncing data.

Understanding datasets and relationships

The linked dataset contains two resources:

• The Buyer Intent table, which contains interaction-level intent signals.
• The Companies view, which contains firmographic enrichment data for companies in the Buyer Intent dataset.

You can join the Buyer Intent table with the Companies view to enrich intent signals with company attributes such as industry, employee count, and annual revenue.

Use the following join condition:

buyer_intent.company_id = companies.id

Subscribing to G2 data in Analytics Hub

To access G2 Buyer Intent data, subscribe to a listing in Analytics Hub.

1. Open the Google Cloud Console.
2. Navigate to Analytics Hub.
3. Search for the G2 Buyer Intent listing.
4. Select the listing.
5. Select Subscribe.
6. Choose your destination project and dataset.
7. Confirm the subscription.

After subscribing, a linked dataset appears in your BigQuery project.

Querying the data

G2 provides several example use cases and sample queries to help you understand how you can leverage G2 data in BigQuery.

Querying high-intent companies

The following query returns companies with high Buyer Intent scores from the last seven days.

SELECT
  company_name,
  company_domain,
  company_country,
  company_intent_score
FROM `your-project.linked_dataset.buyer_intent`
WHERE day >= FORMAT_DATE('%Y-%m-%d', DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY))
  AND company_intent_score >= 70
ORDER BY company_intent_score DESC

Enriching Buyer Intent data

The following query enriches Buyer Intent signals with firmographic data from the Companies view, including employee count, revenue, and industry.

SELECT
  bi.company_name,
  bi.company_intent_score,
  c.employees,
  c.annual_revenue,
  c.industry
FROM `your-project.linked_dataset.buyer_intent` bi
JOIN `your-project.linked_dataset.companies` c
  ON bi.company_id = c.id

Joining with your data

The following query joins G2 Buyer Intent data with CRM account data using the company domain as a shared identifier.

Example:

SELECT
  bi.company_name,
  bi.company_intent_score,
  crm.account_owner,
  crm.deal_stage
FROM `your-project.linked_dataset.buyer_intent` bi
JOIN `your-project.linked_dataset.companies` c
  ON bi.company_id = c.id
JOIN `your-project.your_dataset.accounts` crm
  ON c.domain = crm.website_domain