CRM
Land Zoom Webinar Engagement Signals in BigQuery for Attribution
On a schedule, exports completed Zoom webinar participation data into a BigQuery table so analysts can model watch-time signals against pipeline and revenue.
How it runs
The automated pipeline, trigger to output.
- TriggerDaily schedule
- ActionList webinars ended in last 24hZoom
- ActionFetch participant reportsZoom
- LogicFlatten and de-duplicate to row schema
- ActionStream rows into BigQueryBigQuery
- OutputReport rows inserted and skips
What it does
This workflow builds the analytics backbone for webinar attribution. On a daily cadence it pulls participation reports for recently completed Zoom webinars, normalizes per-attendee watch-time and interaction fields, and appends them to a BigQuery table keyed by email and webinar.
When to use it
Use it when marketing ops needs durable, queryable engagement history, joining watch time to opportunities and closed-won, rather than relying on the rolling 30-day window Zoom keeps.
How it works
- 1A daily schedule trigger starts the run.
- 2An action lists Zoom webinars that ended in the last 24 hours.
- 3An action fetches each webinar's participant report with join/leave, minutes, polls, and Q&A.
- 4A logic step flattens and de-duplicates rows into a clean per-attendee schema.
- 5An action streams the rows into the BigQuery engagement table.
- 6An output reports rows inserted and any webinars skipped for missing data.
Set it up
What you configure once, before turning it on.
- 1Connect ZoomMeetings, recordings, transcripts.
- 2Connect BigQueryDatasets, queries, schemas.
- 3Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 4Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 5Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More CRM workflows
Dormant Account Check-In Call Scheduler
On the anniversary of an account's last touch, books a tentative check-in call on the owner's Google Calendar and emails the contact a scheduling invite.
Weekly Dormant-Anniversary Cohort Digest
Every week, groups dormant Attio accounts by which last-touch anniversary they hit that week, builds a prioritized digest.
AI-Personalized Dormant Account Win-Back
On a dormancy anniversary, an agent researches the account's history and recent public signals, drafts a genuinely personalized win-back email.
Backfill Intercom conversation topics onto stale HubSpot contacts
Finds HubSpot contacts with no recent Intercom topic, pulls their conversation history from Intercom, classifies the dominant topic with OpenAI.
Daily orphaned-opportunity sweep with manager Slack digest
Each morning this scans Salesforce for open opportunities owned by inactive users and posts a per-manager digest in Slack listing the orphaned deals that need a new owner.
Tag closed Intercom conversations onto Salesforce contacts in real time
On each Intercom conversation close, classifies the topic with OpenAI and appends it to the matching Salesforce contact's activity timeline so the topic never goes stale…
Run it inside a business
This workflow drops into a full company template. Import the org, and this is one of the playbooks its agents run.
Run this workflow in your colony.
14-day trial. No DevOps. No Sales call. Provisioned in under a minute.