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.