I’m excited to dive into the world of #demandgeneration reporting with you all. But in order for us to get started, I actually have to back up first. Because the key to executing successful reporting is understanding how to organize data to be used in a consistent, effective and scalable way. Enter the Master Reporting Doc. For me, this is a Google Sheet comprised of 6 Pillar Tabs: - Inbound Business Performance - Inbound Pacing - Monthly Cohorting Analysis - Budget Pacing - Demand Capture Analysis - Demand Creation Analysis Additional tabs use API connections to pull in raw data from ad platforms and CRM systems to feed these pillars. 𝘗𝘳𝘰 𝘵𝘪𝘱: 𝘍𝘰𝘤𝘶𝘴 𝘰𝘯 𝘴𝘦𝘵𝘵𝘪𝘯𝘨 𝘶𝘱 𝘵𝘩𝘦 𝘐𝘯𝘣𝘰𝘶𝘯𝘥 𝘉𝘶𝘴𝘪𝘯𝘦𝘴𝘴 𝘗𝘦𝘳𝘧𝘰𝘳𝘮𝘢𝘯𝘤𝘦 𝘵𝘢𝘣 𝘧𝘪𝘳𝘴𝘵. The metrics housed in this tab allow me to create 𝟯𝟬+ 𝘃𝗶𝘀𝘂𝗮𝗹𝗶𝘇𝗮𝘁𝗶𝗼𝗻𝘀 to help analyze and share business performance related to investment in demand generation. To get started, in the first column, list out your time periods. Create a section for MoM and QoQ. I typically limit my data set to the current and previous fiscal year. Then, in the first row, list all of the different metrics you want to track. I use over 40! 𝘚𝘦𝘦 𝘤𝘰𝘮𝘮𝘦𝘯𝘵𝘴 𝘧𝘰𝘳 𝘧𝘶𝘭𝘭 𝘭𝘪𝘴𝘵! A few things to remember when you are building the reports that feed these metrics: 1) You should be measuring Inbound holistically. Do not limit your reporting analysis to paid channels only. Include data for leads, opportunities and deals that are generated from high-intent form submissions commonly attributed to Direct, Organic, Paid Search, Paid Social and Organic Social channels. 2) Include multiple date field properties so you can report in both cohorted and un-cohorted views. At a minimum you will want to include: Form Submission Date, Demo Scheduled Date, Demo Completed Date, Opportunity Create Date and Close Date. 3) Include fields that allow you to calculate Pipeline Velocity: Total Opps Created, Total Closed Deals, Total Closed-Lost Deals, Total Closed-Won Deals, Days to Close, Total ARR. And that’s how you can begin setting up the data collection for your Business Performance Tab! Later this week I plan to show and analyze different charts we can create with this data. I’ll also show a preview of what this sheet actually looks like and how I do some of the calculations over on TikTok! Questions? Drop them below! #demandgeneration #demandgenallison
Allison Loehman, when you say cohorted and uncohorted, what do you mean? Not sure if it’s a difference in UK / US terms 🫠
How do you have 5 dates when column A is only showing Period as the Date? Are there other sheets that have the data by each type of date or do you have some kind of date selector / slicer?
Epic stuff Allison, thanks for sharing. Though my analytical compass is getting a bit thrown off by the quarterly math toward the right. Are you just summing percentages and cost per demo? I figured the Lead:Demo % and cost/demo would be in similar ranges as MoM. As an absolute novice that can't access much of this data given our current stack, I can promise you that GDS will be easy for you to pick up. But I like seeing the numbers, visualization isn't life-changing for me -- I'd have started in Sheets too lol
Great set of metrics for tracking demand generation effectiveness. I think it will be even more beneficial to see visualizations e.g. trends and heatmaps to quickly identify areas of optimization. Boutique data analytics consultancy Gyanalytics.com.au helps companies with similar dashboards for customer acquisition and retention.
Allison Loehman what's the plan of getting that sheet updated with the latest figures all the time, without doing manual updating of the sheet.
Allison this is an AMAZING breakdown!
I’ve followed HIRO modeling and gone thru a journey. Started with ‘we need to do this’ to ‘we’re kinda doing this’ to ‘we are doing this.’ It is really about what happens after the pipeline is created* that matters.
VP, Growth Marketing & Underwriting @ Allied
1yHere’s the list of metrics I track in my columns. Head over to TikTok later this week to learn more! Facebook Ad Spend LinkedIn Ad Spend Google Search Ad Spend Total Ad Spend Form Subs Cost Per Form Sub Demos Sched (Cohorted) Demos Sched (Uncohorted) Demos Sched (Cohorted, Any Period) Form Subs To Demo Sched CR (Cohorted, Any Period) Cost Per Demo Sched (Cohorted, Any Period) Demos Completed (Cohorted) Demos Completed (Uncohorted) Demos Completed (Cohorted, Any Period) Form Subs to Demo Completed CR (Cohorted, Any Period) Demo Scheduled to Demo Completed CR (Cohorted, Any Period) Cost Per Demo Completed (Cohorted, Any Period) Won (Cohorted) Total Inbound ARR (Cohorted) ACV (Cohorted) Won (Uncohorted) Total Inbound ARR (Uncohorted) ACV (Uncohorted) Won (Cohorted, Any Period) Total Inbound ARR Won (Cohorted, Any Period) ACV (Cohorted, Any Period) Ad CAC (Cohorted, Any Period) Ad CAC Payback (Cohorted, Any Period) ROAS (Cohorted, Any Period) Form Subs to Closed Won CR (Cohorted, Any Period) Demo Completed to Closed Won CR (Cohorted, Any Period) Total Opps. Created (Uncohorted) Total Closed (Uncohorted) Total Lost (Uncohorted) Total Won (Uncohorted) Win Rate Sales Cycle Length Total ARR (Uncohorted) ACV (Uncohorted) Pipeline Velocity