Marketing ops workflows break silently — a Zapier automation stops firing, a Marketo smart campaign skips an enrollment trigger, a Salesforce sync delays MQL routing by 48 hours. By the time you notice, you've lost a week of lead processing and nobody can explain the gap. This stack adds proactive monitoring to your ops workflow architecture. Pull execution logs from Marketo and Zapier, cross-reference against expected lead volumes from Salesforce, and run the status data through a Claude ops health prompt. You get a weekly workflow health report before anything goes visibly wrong.
The Stack
The Prompt
This stack is built around the Executive Summary Generator Prompt. Here's the abbreviated version — the full prompt with all variables and usage notes is on its own page.
You are a marketing operations specialist monitoring the health of automated B2B marketing workflows. Review the workflow execution logs from Marketo and Zapier, and the lead volume data from Salesforce provided below. Identify automations with execution gaps: workflows that should have fired but show no activity based on expected lead volume. Flag workflows with error rates above threshold or unusual latency between trigger and action. Identify the downstream impact of any gaps: MQLs not routed, sequences not triggered, CRM records not updated. Output a weekly ops health report with workflow status summary and priority issues ranked by downstream revenue impact.[ ... continued — see full prompt ]
The Workflow
-
Pull Marketo smart campaign execution logs
Export smart campaign activity logs from Marketo for the past 7 days — enrollment counts, filter matches, flow step completions, and any error notifications from the activity log.
-
Pull Zapier automation run history
Export Zapier task history for all active demand gen Zaps — run counts, error logs, and any paused automations. Compare against expected volume based on prior weeks.
-
Cross-reference against Salesforce lead volumes
Pull MQL creation volume from Salesforce for the same period. If expected MQL volume doesn't match Marketo enrollment volume, a workflow gap is likely.
-
Run the ops health diagnostic
Paste the Marketo logs, Zapier history, and Salesforce volume comparison into the Executive Summary Generator prompt adapted for ops monitoring. Claude identifies gaps, errors, and downstream impact.
-
Fix gaps and alert the team
Fix priority workflow failures immediately. Post the ops health summary to your Slack ops channel. Set up re-enrollment for any leads that missed the workflow window due to the gap.
What This Replaces
- Ops workflow failures discovered only when a rep asks why their leads stopped arriving
- Manual weekly checks of Marketo and Zapier logs that take an hour and still miss things
- No systematic view of whether your marketing automation is actually running as designed
Related Stacks
New stacks drop weekly.
Each one includes the tools, the Claude prompt, and the workflow logic. Free — built for in-house B2B demand gen managers.