Bring county industry statistics into opportunity reviews
Add a grounded view of local establishments and employment to opportunity reviews with County Business Patterns for the county and industry you specify.
Trigger
New or Updated Opportunity
Triggers when a Salesforce Opportunity is created or updated.
Action
Get County Business Patterns
Tool to retrieve county business patterns (cbp) data for a specified year. use when you need county-level business establishment and employment statistics filtered by industry and geography.
Why this helps
Opportunity reviews often require separate research into how concentrated or active a local industry is.
- Retrieve county-level establishment and employment statistics.
- Tie an opportunity update to an explicit county and industry.
- Get a short summary for review without manual Census browsing.
Setup
Build it in a few focused steps.
- 1Connect Salesforce and Census bureau once in the Notis portal.
- 2Create an automation with a name and report channel.
- 3In one instruction, specify how to identify the opportunity county and industry, the CBP year, and the statistics to summarize.
- 4Choose New or Updated Opportunity as the trigger, then test with one real opportunity example.
Questions about this workflow
What if the opportunity has no county or industry?
The Census request needs those details. Include them in the opportunity data used by the instruction or provide them as part of the request.
Does this measure an individual company's performance?
No. County Business Patterns provides county-level business establishment and employment statistics filtered by industry and geography.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Salesforce to Census bureau. A trigger fires from one place; an action lands in another.
Salesforce triggers
Census bureau actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Get ACS 1-Year Estimates
Tool to retrieve 1-year american community survey (acs) estimates for a specified geography. use when you need the most recent annual acs data for a given area.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get ACS 5-Year Estimates
Tool to retrieve 5-year american community survey estimates for a specified year. use when detailed acs data by geography and variables is required.
Account Created or Updated
Triggers when an Account is created or updated in Salesforce. Uses LastModifiedDate high-watermark to capture both creations and updates.
Get American Business Survey
Tool to retrieve annual business survey (abs) data for a specified year and endpoint.
Contact Updated
Triggers when an existing Salesforce Contact record is modified. Emits changed fields alongside relevant timestamps.
Get Community Resilience Estimates
Tool to retrieve community resilience estimates for a specified year. use after selecting variables and geography to get cre data for analysis.
Record Updated (Generic SObject)
Triggers when monitored fields change on any Salesforce SObject. You specify the SObject type and which field values should be returned in the payload. The trigger uses SystemModstamp to detect changes regardless of which specific field changed.
Get County Business Patterns
Tool to retrieve county business patterns (cbp) data for a specified year. use when you need county-level business establishment and employment statistics filtered by industry and geography.
New Contact Trigger
Triggers when a new Contact is Created in Salesforce.
Get Decennial Census Data
Tool to retrieve decennial census data for a specified vintage and dataset. use when you need census variables for a given geography.
New Lead Trigger
Triggers when a new Lead is created in Salesforce.
Get Population Estimates
Tool to retrieve population estimates program (pep) data for a specified vintage and dataset. use when you need population or demographic estimates for specific geographies.
New or Updated Opportunity
Triggers when a Salesforce Opportunity is created or updated.
Get Variable Details
Tool to retrieve metadata for a specific variable in a census dataset for a given year. use when you need the label, concept, data type, attribute codes, and valid-value constraints.
Connect any two apps with Notis in the middle.
Salesforce and Census bureau, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Census bureau.