---
title: "Buyer Intent data dictionary"
slug: "bigquery-buyer-intent-data-dictionary"
updated: 2026-06-17T04:22:46Z
published: 2026-06-17T04:22:46Z
canonical: "documentation.g2.com/bigquery-buyer-intent-data-dictionary"
stale: true
---

> ## 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.

# Buyer Intent data dictionary

This data dictionary describes the columns available in the Buyer Intent table shared through Google Analytics Hub.

Each row in the Buyer Intent table represents a single interaction event.

When a subscription includes multiple products, `company_intent_score` uses maximum aggregation across products rather than summation.

For example, if a company has intent scores of 80, 60, and 40 across multiple tracked products, the reported score is 80.

## Buyer Intent table

The following table describes the Buyer Intent dataset.

| Column name | Data type | Description | Join usage | Example value |
| --- | --- | --- | --- | --- |
| `aggregate_id` | STRING | Unique identifier for each interaction event. Generated as a hash of key fields. | Not used for joins | `a3f5c9...` |
| `subject_product_id` | STRING | Unique identifier for the product being researched. | Join to product datasets if applicable | `47d9f613-8052...` |
| `subject_product_slug` | STRING | URL-friendly product identifier. | Not typically used for joins | `g2-track` |
| `subject_product_name` | STRING | Display name of the product being researched. | Used for reporting and filtering | `G2 Track` |
| `day` | STRING | Date of the interaction in YYYY-MM-DD format. | Used for time-based filtering | `2024-01-15` |
| `time` | STRING | Timestamp of the interaction. | Used for ordering and time analysis | `2024-01-15T12:34:56Z` |
| `signal_type` | STRING | Type of Buyer Intent signal generated by the interaction. | Used for segmentation and scoring | `compare` |
| `total_activity` | INTEGER | Count of interactions for the event grouping. | Used in aggregation logic | `3` |
| `company_intent_score` | INTEGER | Intent score for the company (0–100). | Used for prioritization models | `82` |
| `category_id` | STRING | Unique identifier for the G2 category. | Join to category datasets if available | `1004661` |
| `category_slug` | STRING | URL-friendly category identifier. | Not typically used for joins | `crm-software` |
| `category_name` | STRING | Display name of the category. | Used for reporting | `CRM Software` |
| `left_product_id` | STRING | Identifier for the left-side product in comparisons. | Join to product datasets if available | `abc123` |
| `left_product_slug` | STRING | Slug for the left-side comparison product. | Not typically used for joins | `product-a` |
| `left_product_name` | STRING | Name of the left-side comparison product. | Used for competitive analysis | `Competitor A` |
| `right_product_id` | STRING | Identifier for the right-side comparison product. | Join to product datasets if available | `xyz789` |
| `right_product_slug` | STRING | Slug for the right-side comparison product. | Not typically used for joins | `product-b` |
| `right_product_name` | STRING | Name of the right-side comparison product. | Used for competitive analysis | `Competitor B` |
| `vendor_id` | STRING | Unique identifier for the vendor. | Join to vendor datasets if available | `vendor_123` |
| `vendor_name` | STRING | Vendor name. | Used for reporting and filtering | `Vendor Inc.` |
| `vendor_slug` | STRING | URL-friendly vendor identifier. | Not typically used for joins | `vendor-inc` |
| `company_id` | STRING | Unique G2 company identifier. | Primary join key to the Companies view (`id`) | `2683174` |
| `company_domain` | STRING | Primary company website domain. | Primary join key for CRM and marketing data | `example.com` |
| `company_city` | STRING | Company city. | Used for geographic segmentation | `Chicago` |
| `company_name` | STRING | Company name. | Not recommended for joins | `Example Corp` |
| `company_state` | STRING | Company state or region. | Used for geographic segmentation | `Illinois` |
| `company_country` | STRING | Company country. | Used for geographic segmentation | `United States` |
| `company_employees` | STRING | Employee count or employee range. | Used for segmentation and prioritization | `500-999` |
| `company_industry` | STRING | Company industry classification. | Used for segmentation and targeting | `Software` |
| `visit_url` | STRING | URL of the G2 page visited. | Not used for joins | `https://www.g2.com/...` |
| `visit_title` | STRING | Title of the visited page. | Used for activity analysis | `Compare Product A vs B` |
| `visit_tag` | STRING | Tag describing the visit type or classification. | Used for filtering and segmentation | `comparison` |
| `visitor_id` | STRING | Anonymized visitor identifier. | Not used for joins | `visitor_abc` |
| `visitor_city` | STRING | Visitor city. | Used for geographic analysis | `Austin` |
| `visitor_state` | STRING | Visitor state or region. | Used for geographic analysis | `Texas` |
| `visitor_country` | STRING | Visitor country. | Used for geographic analysis | `United States` |

## Notes

- Each row represents a single interaction event.
- Use the Companies view to enrich Buyer Intent data with firmographic attributes.
- Refer to the Companies data dictionary for detailed field definitions and enrichment attributes.