---
title: "Buyer Intent data dictionary"
slug: "snowflake-buyer-intent-data-dictionary"
updated: 2025-10-09T16:29:32Z
published: 2025-10-09T16:29:32Z
---

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

The following data dictionary describes each column for the *G2 Seller Buyer Intent Data* private listing in Snowflake.

          
          

For more information on the G2 + Snowflake integration, refer to the [Get started with Snowflake](/docs/snowflake) documentation.

| Column name | Data type | Description | Example value |
| --- | --- | --- | --- |
| product_id | varchar | The ID for the product subscribed to G2 Buyer Intent. This column corresponds to *product_id* in the [Reviews](/docs/snowflake-reviews-data-dictionary) table. | 47d9f613-8052-47d0-9770-2cdf09106348 |
| product_name | varchar | The name of the product subscribed to G2 Buyer Intent. | G2 Track |
| category_id | varchar | The ID for the G2 product category. Only populated for Category signals (*visit_type*: **category**). | 1004661 |
| company_id | number | The ID for the buyer organization. | 2683174 |
| company_name | varchar | The name of the buyer organization. | SaaS Company X |
| visit_url | varchar | The URL for the G2 page that was visited. | https://www<wbr data-tomark-pass="">.g2<wbr data-tomark-pass="">.com<wbr data-tomark-pass="">/products<wbr data-tomark-pass="">/g2<wbr data-tomark-pass="">/reviews |
| visit_title | varchar | The title of the G2 page that was visited. | Profile: G2 Marketing Solutions |
| visit_type | varchar | The type of G2 page that was visited. Possible types: ***profile***, ***category***, ***compare***, ***competitors***, ***ad***, ***product_reference_page***, ***licensed_content***, ***vendors***, ***competitive/profile***, ***competitive/compare***, ***competitive/pricing***. For more information on each type of Buyer Intent signal, refer to the [Buyer Intent](https://documentation.g2.com/docs/buyer-intent#signal-types) documentation. | compare |
| visit_date | date | The date of the visit, in YYYY-MM-DD format. | 2022-10-23 |
| company_domain | varchar | The buyer organization's website domain. | saascompanyx.com |
| visitor_region | varchar | The local region of the individual visitor who triggered the Buyer Intent signal. | Tamil Nadu |
| visitor_country | varchar | The country of the individual visitor who triggered the Buyer Intent signal. | India |
| company_state | varchar | The buyer organization’s headquarters local region. | Illinois |
| company_country | varchar | The buyer organization’s headquarters country. | United States |
| company_employees | number | The number of employees at the buyer organization. | 700 |
| org_employees_range | varchar | The number of employees at the buyer organization, reported as a range. | 500 - 999 |
| company_sector | varchar | The buyer organization's business sector. | Industrials |
| company_industry_group | varchar | The buyer organization’s industry grouping. | Commercial & Professional Services |
| company_industry | varchar | The buyer organization’s industry. | Professional Services |
| company_sub_industry | varchar | The buyer organization’s sub-industry. | Automation |
| total_page_views | number | The daily total number of visits to the specific G2 page by users from the same geographic region and buyer organization. | 2 |
| last_seen | timestamp | The datetime for the most recent visit to a specific G2 page each day, in UTC. For example, if a buyer viewed a product's profile page at *2023-01-22 11:10:05* and *2023-01-22 22:40:05*, the datetime of the latter visit will be reported for Profile signals (*visit_type*: **profile**). | 2023-01-22 21:40:05 |
| activity_level | varchar | The measure of a buyer's general activity on G2. | Low, Medium, and High |
| buying_stage | varchar | The evaluation of a buyer's journey on G2. | Awareness, Consideration, and Decision |