The Math of the Marketing Funnel

We’ve been talking about the marketing funnel just about every session of Digital Marketing, but we hadn’t really brought it to life yet. So, in our mid-term (10th session) of the #DGM2 class, we focused completely on the math of the marketing funnel.

A photo posted by Kevin Sandlin (@kevinrsandlin) on Feb 26, 2015 at 6:24pm PST

It helped that this class was also our maiden voyage into the very cool new General Assembly space at Ponce City Market, so we had Willy’s and beer to help the presenting and teaching. The 18 new marketers presented in their groups of 3 or 4 from our lesson from the previous class, in which each group had the assignment to create a marketing budget to do an ad buy on Google Adwords or Facebook Ads with the goals of 1,000 new users and a 100% ROI on the spend.

Then we dug deep into the marketing funnel, because that was a challenge for most of the group. Here are the six specifics that should be considered when engaging in an early (e.g., very first spend) digital marketing buy.

  • Information is imperfect – the first time you tackle Adwords or Facebook Ads, you’re guessing. You don’t know what your CTR will be, what your best keywords are, or what your conversion rate is.
  • Social media channels want you to spend – so they make it really easy to spend a few dollars at a time to get you hooked on short term results, but their model is to get you spending a little more each time and keep you spending.
  • Finding correct keywords is difficult – trial and error are best replaced here with test & measure, because that’s how we figure out which words work for our campaigns and why.
  • The top of the funnel has to be huge – CTRs from Google and social channels are going to be small, despite “viral marketer” claims that “I got 28% CTR on my first Facebook ad!” so you need to start small, and build your own historical information, upon which you can then make more educated guesses about larger spends in the future.
  • Experiment, experiment, experiment – the first assignment I gave the class after GA so generously supplied them with $25 Visa cards (no beer or shoes!) was to go test something. Just getting used to the process of a social ad buy is a major learning event. Repetition of testing and measuring come much easier with understanding of how things work.
  • Buying the ad is the easy part. Determining the math that goes into the proper ad buy is the hard part.

In the end, the visualization and MS Excel formulas were what brought it home for the class. Marketing is all about the numbers, and it starts with that top of the funnel: total addressable market. Then the key metrics of CTR and conversion rates (into email, warm lead, trial user, user, customer) must be measured and improved to improve the bottom line.

This session was completely off-the-cuff from the students and myself. No slides, no agenda, just digging into a big, important roadblock that had to be destroyed. The beer & Tex-Mex helped a lot.

Comments

Leave a comment

More from Kevin

  • Still using Google?!?

    Still using Google?!?

    Other than a specific “Image Search”, I no longer use Google to search for anything. I use Grok. If you’re not familiar with Grok, it’s the artificial intelligence engine produced by xAI, one of Elon Musk’s businesses. Grok is fed real time data via the “firehose” that comes out of X. Why Grok? Why not…

  • Simplify Your A/V

    Simplify Your A/V

    Your conference rooms’ A/V does not have to be complicated. You should not have to “Call IT!!” to come fix your conference room’s A/V system. Ever. So why do we hear over and over and over the following mantra: “Yeah, can y’all come have a look at our conference rooms? Nothing ever works. Completely unreliable.”?…

  • Learning to Rappel

    Learning to Rappel

    More Search & Rescue (aka “SAR”) training this past weekend. This time, it was all about rappelling. For some of you, rappelling might be your weekend go-to hobby. This was my 2nd time. We spend the weekend in north Georgia learning all the basics of rappelling. We learned all the knots: bowline, square knot, figure…

  • Where’s Your 3rd Office?

    Where’s Your 3rd Office?

    Where do you work when you’re on the road? Sometimes we work at home. Sometimes we work in the office. But some other times, we get to work from our “third office”! Sounds exciting, doesn’t it? OK, maybe not “exciting”, but it could be, depending on where you go. So, your home office has a…

  • IRL vs. Virtual

    IRL vs. Virtual

    Got 47 seconds? Please watch this Gary Vaynerchuk video on Instagram:https://lnkd.in/e7mMuk5S What matters most in the processes deep inside your organization? Speed, efficiency, and effectiveness matter in business. Gary Vaynerchuk suggests that those things occur best in person, in the office, and tells a very familiar story to back it up. The common story, at…

  • ATL CRE 2025

    ATL CRE 2025

    Earlier this week, CBRE announced the complete (CBRE already owned 40%) purchase of Industrious, bringing to light the new business segment within CRE known as “Building Operations & Experience (BOE)”. See Patrick Braswell‘s analysis here:https://lnkd.in/evCBPMBM At the end of 2024, just a couple of weeks ago, the following stats were published by Commercial Edge (link:…

  • “Full RTO!”

    “Full RTO!”

    So, now that we’re 2 weeks in to 2025, who has returned to the office full time? Amazon? Anyone? Beuller? We (TRANSCEND LV) visited a very cool space today, in which the IT staff is preparing for “full RTO”. They’re updating conference rooms from old tech to new, updating WiFi access points, and otherwise preparing…

  • What’s Your Home Office Setup?

    OK, now that Atlanta has recovered from our (first?) snow of the 2025 Winter, let’s talk home office setup. Full disclosure: my home office setup consists of the following items. * Windows laptop* Bluetooth mouse* Levenger Stanley Journal* Sharpie S-Gel pen* WiFi via Amazon Eero / AT&T internet I do my very best to print…

  • No Snow Days

    It’s gonna snow in Atlanta on Friday. Currently, my weather app says 5-6″ of snow from Friday at noon through Saturday morning at about 6AM. We’ll see. I always keep my expectations low, so I don’t get disappointed by just a few flurries. I. Want. Snow! Which brings me to the real point: WFH is…