Allison Loehman’s Post

View profile for Allison Loehman

VP, Growth Marketing & Underwriting @ Allied

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

  • No alternative text description for this image
Allison Loehman

VP, Growth Marketing & Underwriting @ Allied

1y

Here’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

Jamie Pagan

Director of Content Marketing @ Dealfront

1y

Allison Loehman, when you say cohorted and uncohorted, what do you mean? Not sure if it’s a difference in UK / US terms 🫠

Like
Reply
Grant Duncan

VP of Marketing at HST Pathways (a Bain Capital company)

1y

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?

🔗 Keegan Brown

Turning callers into positive WOM | Using music, voice, and tech to impress callers in store and on hold.

1y

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

Harsh J.

Founder | Analytics for SaaS and Tech Scaleups | Ex: Airwallex ( Unicorn, 10x Growth)

1y

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.

Joe M.

Marketing Manager @ SaaS Academy

1y

Allison this is beauitful. Thank you! My data nerd brain is firing on all cylinders. Synapses are lit. I have so many questions. Probably the silliest one I’ll ask now: can someone explain “cohorted” vs “uncohorted”? Thanks in advance!!

Brendan Yong (PMP)

MarOps | Marketing Automation Expert

1y

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.

Blake Strozyk

Marketing @ Guard1 | B2B Marketing

1y

Allison this is an AMAZING breakdown!

Ami Bensman

Chief Marketing Officer + Chief Experience Officer at Sifted | Driving Growth & Improving CX...using #AI to accelerate both.

1y

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.

See more comments

To view or add a comment, sign in

Explore topics