See how your enriched companies distribute by size
Get a compact recurring view of company size bands, using the enriched records you already have in BigQuery.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Query
Query tool will run a sql query in bigquery. note: make sure the query being input in a single line format. for example, select * from sample dataset.sample table where column name = 'value'
Why this helps
A large prospect list can hide whether your research is concentrating on companies that fit your actual capacity and sales motion.
- Notice shifts in the size profile of researched companies.
- Review the distribution without rebuilding the analysis each time.
- Use consistent size bands for planning conversations.
Setup
Build it in a few focused steps.
- 1Connect Companyenrich and Google BigQuery to Notis once in the portal.
- 2Create an automation in the portal or ask Notis to summarize company size regularly.
- 3Describe the dataset, size bands, and summary needed in one plain-language query instruction.
- 4Choose a recurring schedule and a channel for run reports.
- 5Check one result against real records and confirm the size bands are interpreted as intended.
Questions about this workflow
Which size metric can it use?
Use the employee count or size value present in your BigQuery enrichment records.
Can the bands match my own segments?
Yes. State your preferred size bands in the plain-language prompt.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Companyenrich to Google BigQuery. A trigger fires from one place; an action lands in another.
Companyenrich triggers
Google BigQuery actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Query
Query tool will run a sql query in bigquery. note: make sure the query being input in a single line format. for example, select * from sample dataset.sample table where column name = 'value'
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Connect any two apps with Notis in the middle.
Companyenrich and Google BigQuery, 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 Google BigQuery.