The Marketing Operations Strategist - The 9 Marketing Reports That Actually Matter

(And How to Pull Them Without Losing Your Mind)

Hey! 👋

Hope you’re doing well!

So….every CMO wants dashboards.
Every exec wants a narrative.
Finance wants insights into marketing performance.

And, of course, everyone wants everything right away. So, where do you start? Which reports are table stakes vs. vanity metrics? 🤔

There are (at least) nine reports I build in every org.

I’ll break them down for you, after a quick word from our sponsors:

Automate your deal rooms. Seriously.
Default just rolled out a slick new way to set up Slack channels automatically when a new account hits your funnel. It pulls company info, invites internal and external stakeholders, and drops a summary message—so your sales team can focus on closing, not setup. Check it out here.

ABM just got a whole lot easier!
With Clay x Webflow, you can now build custom landing pages for every target account, automatically. Pull in company logos, headlines, personalized CTAs, even dynamic case studies — all powered by your data and logic in Clay. See how it works in Clay.

1. Funnel Conversion by Stage

What it shows: Where leads stall or drop off
Why it matters: You want to run a tight ship or you risk losing leads and revenue

How to pull it:
- Count leads at each lifecycle stage: MQL, SQL, Opp, Closed Won
- Calculate the conversion rates between each stage

Conversion Rate (%) =
(Number of conversions ÷ Number of people at previous stage) × 100 

Example:

  • MQLs: 5,000

  • SQLs: 3,000 (60% convert from MQL)

  • Opps: 1,300 (43% convert from SQL)

  • Closed Won: 500 (38% of Opps convert)

Use this to spot where handoffs, integration, automation, or targeting are breaking down. If SQL to Opp is weak, sales might not agree with your definition of qualified, or they may not know which playbook to run on a new lead source! If you can catch issues early in these reports, you can fix before they start to really impact the business.

🕵️‍♂️ Pro Tip: If you have HubSpot MAP, there is a native lead lifecycle functionality. While this comes with some drawbacks (namely, records can’t go backwards/go back through the lifecycle more than once), it’s really nice to quickly set it up and already have all of the tracking fields built for you. In other platforms, you tend to have to set up a bunch of custom fields and automation logic to implement the same capability.

2. Marketing-Sourced Revenue

What it shows: Pipeline or revenue that came from marketing
Why it matters: This is the metric that gets marketing into the boardroom

How to pull it:
- Filter opportunities where campaign source or lead source is marketing
- Sum closed-won revenue from those opps
- Compare to total revenue for the period

Formula:
(Marketing-Sourced Revenue ÷ Total Revenue) x 100

Example:
$2.5M sourced by marketing
$10M in total revenue
= 25% contribution

This one is pretty self-explanatory, but I do want to add a note — you want to have these numbers in your back pocket, and if they look great, brag about them — but you don’t want to be in a position where your CMO is having to justify Marketing’s existence via this metric. Having all of these reports handy and resolving issues early will help prevent Marketing getting put in that precarious position.

3. Pipeline Velocity

What it shows: How long it takes for a lead to become revenue
Why it matters: If you don’t know your cycle length, you can’t forecast pipeline coverage or see if there are slowdowns

How to pull it:
- Use created date and stage change timestamps in your CRM
- Calculate average time between MQL, SQL, Opp, and Closed

Example:

  • MQL to SQL: 12 days

  • SQL to Opp: 26 days

  • Opp to Closed: 72 days

  • Total cycle: 110 days

If you want deals to close in Q4, this report tells you when you need to generate them. This will also help you see any slow-downs (or hey, we can be positive — speed-ups?) early so you can try to mitigate or set expectations with execs or the Board.

4. Channel ROI

What it shows: How efficient each marketing channel is
Why it matters: This is your go-to when budget conversations start — and a way to defend your best investments

How to pull it:
- Match revenue to each channel using attribution or campaign source
- Subtract spend from revenue
- Divide by spend, multiply by 100

Formula:
((Revenue - Spend) ÷ Spend) * 100

Example:
Webinars: $15K spend, $75K revenue = 400% ROI
Paid media: $40K spend, $128K revenue = 220% ROI

Many orgs go way too complex with attribution — this report is a great place to start, without going overboard. Do you typically see high ROI from webinars? That can help you prioritize channels, especially if budgets get cut.

5. Cost per SQL

What it shows: How much you’re spending to generate real pipeline
Why it matters: MQLs are cheap. SQLs are where the buying starts

How to pull it:
- Calculate total spend per campaign or vendor
- Divide by number of SQLs generated

Example:
LinkedIn Ads: $20K spend, 80 SQLs = $250 per SQL
Content Syndication: $8K spend, 10 SQLs = $800 per SQL

This will help you cut underperformers and double down on what works — HOWEVER, with all of these reports, remember that Marketing is both an art and a science. Don’t make a decision based on only one of these reports, make sure you look across reports for trends and context.

6. Lead Source Performance

What it shows: Which sources actually create pipeline and revenue
Why it matters: Simple, reliable, and easier to explain than complex attribution models

How to pull it:
- Group opportunities by lead source
- Sum total opps and revenue for each

Example:

Source

Opps

Revenue

Paid Search

30

$1.1M

Organic

24

$850K

Webinars

16

$600K

If you’re getting $850K from organic without paid support, that’s typically a signal to invest more in SEO. Keep an eye out for which sources are low cost and high ROI — they could serve you well in a down market.

7. Average Deal Size by Segment

What it shows: Which industries or account types bring in the biggest contracts
Why it matters: Helps focus ABM, outbound, and content by segment

How to pull it:
- Group closed-won opps by industry, account tier, or region
- Calculate average revenue per deal

Example:

  • Enterprise: $200K

  • Mid-Market: $120K

  • SMB: $60K

  • Healthcare: $220K

  • Tech: $160K

Everyone loves ABM nowadays, but the budget isn’t unlimited, so this report can help you decide where to spend each dollar. If some segments close way bigger deals than others, you could justify spending more on acquiring those customers.

8. Meetings or Demos by Channel

What it shows: Which programs are creating real conversations
Why it matters: Revenue starts with meetings, not MQLs

How to pull it:
- Track campaign source or UTMs tied to meeting bookings
- Group by channel and count

Example:

Channel

Meetings

Events

45

Paid Media

51

Organic

32

Webinars

40

MQLs are great, but request-a-demos tend to be even better in terms of spend and close rate. This one gets ignored too often…but when you show the CMO/CRO/CEO which events or ads created sales conversations, they will take you more seriously as an advisor. The conversation becomes less about territorialism and more about everyone winning together.

9. Churn Risk by Segment

What it shows: Which customer groups are starting to slip
Why it matters: Retention is more cost-effective than acquisition. Marketing should have a seat at that table too

How to pull it:
- Export churned or canceled accounts
- Group by industry or customer type
- Compare churn rate quarter over quarter

Example:

  • Tech: 18%

  • Healthcare: 6%

  • Finance: 12%

  • SMB: 10%

  • Enterprise: 3%

Now you can build marketing win-back campaigns, onboarding content, or educational programs targeted by risk level! You can build a relationship with customer success, and it usually makes a big difference for the overall business because it is more cost effective to retain/land-and-expand than it is to churn and constantly have to get new customers.

Sara, Are These Really the Most Important Reports?

In my opinion, yes. They overlap what CMOs care about, what RevOps trusts, and what Sales actually uses.

You could layer in attribution models or campaign influence tracking...but if someone asked, “What reports should every marketing org be able to explain, defend, and take action on?” it’s these. Of course, there are many more you can add in, don’t accuse me of oversimplifying! 😅 We all have to start somewhere.

Here’s how they map to who typically cares:

Report

CMO

RevOps

Sales

CS

Funnel Conversion

Sourced Revenue

Velocity

Channel ROI

Cost per SQL

Lead Source

Deal Size

Meetings

Churn Risk

This isn’t about building reports, it’s about showing up with answers before someone asks the question. This helps us feel confident in our work and builds trust!

What I’m up to/what I’m studying 💭

I’m ramping up to take an immersive Clay course, and super stoked about it! I also just saw Nikki Glaser live the other night — she is so funny! Lastly, I’m pulling together some plans to revamp my old website, saramcnamara.com (there’s nothing there yet, but hopefully soon! 🤞). Oh, and who else saw the finale of White Lotus?! SO GOOD!

Dear Sara ✍️

New to marketing operations? On a team of one at your company? Shy/introverted? Wish you could ask a question to an experienced marketing operations professional, without them knowing who you are? Here’s your chance! Submit an anonymous question to me here and I’ll answer a new question in every issue.

Here’s my answer to a question from last week:

I haven't pursued certifications myself, and I haven't witnessed anyone being negatively impacted by not having them. Is my experience unusual? How important are certifications really in today's job market?

Ooohhh, this is a GREAT question. As always, the answer is — it depends. BUT! I can provide a bit of wisdom here.

If you want to work at a large enterprise org: certifications still matter. Many enterprise orgs won’t let you become an admin in a tool like, say, Salesforce, without a Salesforce Administrator certification. It’s their “insurance policy” in case you break something — they can point to others to say “well how did they become certified/they were certified by the vendor!” to avoid liability. 🙃

If you want to work at a smaller org: certifications don’t matter as much as they used to. Why, you ask? Well, to be blunt — a bunch of people put answer “dumps” online, and others are just really good test takers — and they were able to pass the certifications without spending as much as a day inside the actual tool. Companies started to get burned by relying on certifications only, so now they look more closely for real life experience running said platform.

For me, I still like to get a certification — either to familiarize myself with a platform I can’t get access to yet, or as a reinforcement of what I’ve learned after I’ve spent time working in the platform. But I wouldn’t advertise myself as “being certified” if I haven’t actually delivered any work in the tool.

What has your experience been? Curious to hear if folks are seeing the same thing out in the market, or if I seem off-base here!

How can you support this newsletter? 🤔

1. Share this newsletter with friends, they can sign up here.

2. Post about the newsletter on social media, with a link to register!

3. Respond with your thoughts and suggestions on the newsletter!

4. If you are interested in purchasing one of my recommended tools, use the affiliate link in this newsletter to purchase it. It helps boost my content creation efforts, so I can do more cool free stuff for this community!

5. Run marketing at a brand? Respond to this email to inquire about sponsoring this newsletter in the future.

Thanks for reading,

❤️ Sara

Reply

or to participate.