Back

Report on outreach campaign results

Outreach scorecard with sends, replies, bounces, and meetings booked, sent on a schedule

SalesMarketingOpsWeekdays at 8am
Prompt

Every weekday morning, pull the results of my outreach campaign [campaign name, e.g. Q3 founder outreach] for [period, e.g. the last 24 hours]. Sources: my tracking sheet [sheet link], my sent mail and inbox in [Gmail / Outlook] for [sender accounts, e.g. both sending addresses], and my LinkedIn messages if I track LinkedIn touches. Count for the period and campaign to date: messages sent, replies, positive replies, not interested, bounces, and meetings booked. Match replies to tracker rows by email or name, listing unmatched ones separately instead of guessing. Don't edit existing rows. Add a dated row with these counts to a Summary tab. Then send the report to [recipient, e.g. me by email or a Slack channel]: a table with columns Metric, This period, To date, Change vs last report, then up to five replies needing my response and any sender account with a bounce spike or warning. If a source won't open, stop and tell me.

Works withdocs.google.commail.google.com