Skip to main content
Contact + Organization + Insight is a pre-joined table that combines Contact, Organization, and Insight in one view. Each row represents a contact with company and company-level insight attributes already joined.

​
What it is

Use this view when you need contact, company, and company-level insight (e.g., technographics, hiring signals) columns in a single query. No need to join the three base tables yourself — the view is maintained for you. Note that all insights are company-level only.

​
Data dictionary

Field names, descriptions, and examples are sourced from the Contact, Organization, and Insight table pages. This pre-joined table includes all person fields (suffix _PER), all company fields (suffix _ORG from Companies category), and all insight fields (suffix _ORG from Company Insights category).

​
Identifiers

FieldDescriptionExample
RBID_PERRevenueBase’s unique identification for the person. The RBID stays the same if someone changes their job.rb-pabq6o2xf
RBID_ORGRevenueBase’s unique identifier for a companyrb-oab75n3pe
RBID_PAORevenueBase’s unique identifier for the person at a specific company.Revenue Base Internal field

​
Key person fields

FieldDescriptionExample
FIRST_NAME_PERThe person’s first nameMarc
LAST_NAME_PERThe person’s last nameRojas
FULL_NAME_PERThe person’s full nameKathryn E. Gibson
EMAIL_ADDRESS_PERThe person’s work email addresskcollins@fortmckaygroup.com
JOB_TITLE_PERThe person’s current job titleSenior Technical Consultant
JOB_LEVEL_PERThe seniority level of the person’s jobManager
JOB_FUNCTION_PERThe department that the person works in.Information Technology
For the complete list of person fields, see People + Companies documentation. This table includes all person fields with _PER suffix.

​
Key company fields

FieldDescriptionExample
COMPANY_NAME_ORGName of the organizationDell Technologies
DOMAIN_ORGDoman of the company’s websitefsiservices.com
EMPLOYEE_COUNT_MAXMaximum number of employees10000
EMPLOYEE_COUNT_RANGE_ORGRange of employee count5001 to 10000
LINKEDIN_INDUSTRY_ORGIndustry description from LinkedIn[ ""Software Development"" ]
REVENUE_RANGE_ORGRange of the company’s revenue$50M to <$100M
HEADQUARTERS_CITY_ORGCity where the company HQ is locatedNew York
HEADQUARTERS_STATE_NAME_ORGState where the company HQ is locatedNY
HEADQUARTERS_COUNTRY_NAME_ORGCountry where the company HQ is locatedUnited States
For the complete list of company fields, see People + Companies documentation. This table includes all company fields with _ORG suffix from the Companies category.

​
Insight fields

FieldDescriptionExample
ABM_TECH_ORGThere is evidence of particular activity based management technologies in use6Sense;Demandbase;Uberflip;Terminus;Engagio;Triblio
ANALYTICS_TECH_ORGThere is evidence of particular analytics technologies in useTableau;Power BI;Segment;Looker;Qlik
CRM_TECH_ORGThere is evidence of particular customer relationship management technologies in useSalesforce CRM;Hubspot;Microsoft Dynamics;Zoho;Pipedrive CRM;SugarCRM
SALES_ROLE_COUNT_ORGNumber of people with sales titles associated with the organization4
SALES_OPEN_ROLES_COUNT_ORGNumber of open job postings for sales positions at the organization6
LAST_FUNDING_AMOUNT_ORGIf the organization received funding, the last funding amount15400000
LAST_FUNDING_DATE_ORGIf the organization received funding, the last funding date2022-09-22
LAST_FUNDING_TYPE_ORGIf the business received funding, the last funding typePost-IPO Equity
TOTAL_FUNDING_AMOUNT_ORGIf the organization received funding, the total amount of funding to date175500000
EMPLOYEE_ON_LINKEDIN_GROWTH_RATE_ORGPercentage of latest month’s employee growth rate as a percentage.4
HAS_CIO_ORGIf the business has a chief information officerYes
HAS_CISO_ORGIf the business has a chief information security officerYes
For the complete list of insight fields, see Insights documentation. This table includes all insight fields with _ORG suffix from the Company Insights category.

​
Example queries

​
Find contacts at companies using specific technologies

SELECT 
    RBID_PER,
    FIRST_NAME_PER,
    LAST_NAME_PER,
    EMAIL_ADDRESS_PER,
    JOB_TITLE_PER,
    COMPANY_NAME_ORG,
    CRM_TECH_ORG,
    SALES_ROLE_COUNT_ORG
FROM RELEASES.RELEASE.VELOCITY_ENHANCED_UNLIMITED_LATEST
WHERE CRM_TECH_ORG IS NOT NULL
  AND SALES_ROLE_COUNT_ORG > 0
LIMIT 100;

​
Find contacts at companies with recent funding

SELECT 
    FIRST_NAME_PER,
    LAST_NAME_PER,
    EMAIL_ADDRESS_PER,
    COMPANY_NAME_ORG,
    LAST_FUNDING_AMOUNT_ORG,
    LAST_FUNDING_DATE_ORG,
    LAST_FUNDING_TYPE_ORG
FROM RELEASES.RELEASE.VELOCITY_ENHANCED_UNLIMITED_LATEST
WHERE LAST_FUNDING_DATE_ORG >= DATEADD(month, -12, CURRENT_DATE())
  AND JOB_LEVEL_PER IN ('VP', 'Director', 'C-Suite')
ORDER BY LAST_FUNDING_DATE_ORG DESC;

​
See also