This data dictionary describes each column in the Companies view available in Google BigQuery through Analytics Hub.
The Companies view provides enriched firmographic data for companies that appear in your Buyer Intent dataset. The view is scoped to your data and does not expose the full G2 companies dataset.
Companies view
The following table describes the Companies view.
| Column name | Data type | Description | Join usage | Example value |
|---|---|---|---|---|
id |
STRING | Unique identifier for the company. | Primary join key to Buyer Intent (company_id) |
2683174 |
name |
STRING | Company name. | Secondary join key if needed | Example Corp |
legal_name |
STRING | Legal entity name of the company. | Not typically used for joins | Example Corporation Inc. |
domain |
STRING | Primary website domain. | Primary join key for CRM and marketing data | example.com |
domain_aliases |
STRING (REPEATED) | Additional known domains for the company. | Used for advanced domain matching | ["example.co", "example.io"] |
url |
STRING | Company website URL. | Not typically used for joins | https://www.example.com |
description |
STRING | Company description. | Used for enrichment and segmentation | B2B SaaS company |
linkedin |
STRING | LinkedIn profile URL. | Used for enrichment | https://linkedin.com/company/example |
twitter |
STRING | Twitter profile or handle. | Used for enrichment | https://twitter.com/example |
facebook |
STRING | Facebook page URL. | Used for enrichment | https://facebook.com/example |
city |
STRING | Company city. | Used for geographic segmentation | Chicago |
state |
STRING | Company state or region. | Used for geographic segmentation | Illinois |
state_code |
STRING | State or region code. | Used for normalization | IL |
postal_code |
STRING | Postal or ZIP code. | Used for location analysis | 60601 |
country |
STRING | Company country. | Used for segmentation and joins | United States |
country_code |
STRING | Country code (ISO format). | Used for normalization | US |
global_region |
STRING | Global region grouping. | Used for reporting | North America |
street_address |
STRING (REPEATED) | Street address lines. | Not typically used for joins | ["123 Main St"] |
latitude |
FLOAT | Latitude coordinate. | Used for geospatial analysis | 41.8781 |
longitude |
FLOAT | Longitude coordinate. | Used for geospatial analysis | -87.6298 |
location |
STRING | Formatted location string. | Used for display | Chicago, IL, US |
employees |
INTEGER | Number of employees. | Used for segmentation and scoring | 750 |
employees_range |
STRING | Employee count range. | Used for segmentation | 500-999 |
annual_revenue |
FLOAT | Estimated annual revenue in USD. | Used for segmentation and prioritization | 50000000 |
founded_year |
FLOAT | Year the company was founded. | Used for enrichment | 2012 |
company_type |
STRING | Type of company (e.g. public, private). | Used for segmentation | Private |
is_public |
BOOLEAN | Whether the company is publicly traded. | Used for filtering | FALSE |
is_hq |
BOOLEAN | Whether the record represents headquarters. | Used for filtering | TRUE |
ticker |
STRING | Stock ticker symbol. | Used for enrichment | EXMPL |
raised |
FLOAT | Total funding raised in USD. | Used for enrichment | 120000000 |
sector |
STRING | High-level sector classification. | Used for segmentation | Technology |
industry_group |
STRING | Industry group classification. | Used for segmentation | Software & Services |
industry |
STRING | Industry classification. | Used for segmentation | Software |
sub_industry |
STRING | Sub-industry classification. | Used for segmentation | SaaS |
tags |
STRING (REPEATED) | Tags associated with the company. | Used for filtering and enrichment | ["b2b", "saas"] |
provider |
STRING | Data provider source. | Not used for joins | G2 |
external_id |
STRING | External identifier for the company. | Used for integration mapping | ext_12345 |
created_at |
DATETIME | Record creation timestamp. | Used for auditing | 2023-01-01T00:00:00 |
updated_at |
DATETIME | Last update timestamp. | Used for auditing | 2024-01-01T00:00:00 |