Contents x
Buyer Intent data dictionary
  • 26 Mar 2024
  • 2 Minutes to read
  • Dark
    Light
Contents

Buyer Intent data dictionary

  • Updated on 26 Mar 2024
  • 2 Minutes to read
  • Dark
    Light
Article summary

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 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 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.g2.com/products/g2/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.For more information on each type of Buyer Intent signal, refer to the Buyer Intent documentaiton.		 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
What's Next