Loading video...
Video Failed to Load
HexClad’s #1 most powerful tool: spend, revenue, and media mix forecasting. One single spreadsheet has saved us MILLIONS by preventing inefficient spend, poor pacing, and reactive decision-making… I just built a template that automatically integrates into any brand with just 3 clicks. I was offered $1k for the spreadsheet... show more
30,377 views • 10 months ago •via X (Twitter)
38 Comments

Top-line Spend & Rev Dashboard; This is where you’ll find high level metrics like total spend, net revenue, and net MER, all with PoP and YoY (day-matched) comparisons. The 3 most important things to evaluate overarching business health, and the 3 core drivers of the spreadsheet. Be able to react FAST to DoD/PoP deltas in forecast & actualized spend/rev (just in time for BFCM). Compounded over or under spend for a long period of time can lead to ☠️ (and I’ve personally seen this happen numerous times). This tool is NOT meant to scrutinize daily performance. Starting with daily’s and moving up to periodical reporting/forecasting is a lot easier than the other way around, and it allows you to set specific goals & see incredibly clear trends before it’s too late.

Next up: Daily allocation table Find discrepancies easily within your forecasting period by understanding where you could’ve made more (or less) of an investment, and capitalize on areas of (in)efficiency. At a high level, this table shows what your daily spend & revenue contribution is, as a % of total (on specific days or periods of time). This allows you to find areas of opportunity based on that relationship. Example; Last year you spent 5% of your forecasted total on BFCM, only to realize your revenue was 45% of total. Now, imagine you can see this on a rolling daily basis for a full month, quarter, or year. This is only half of the cake, though. If you aren’t using northbeam, this might be the time to do so. Tie this with northbeams 1dc (24h) + LTV (all-time) attributed revenue from that specific day’s spend, and apply the same correlation coefficient, and you get…. (drum roll pls)…. an incredibly efficient way to take advantage of click-based channel opportunities. The only issue with looking at the relationship between total spend/rev contribution (w/o northbeam or other MTA) is that you don’t see the HALO effect of that specific day’s worth of spend (e.g. LTV attributed revenue) This gets more increasingly important as your consideration period gets longer. Example; - 7 day consideration period; use 7-day intervals - 30 day consideration period: use 30-day intervals (etc. etc.) If you don’t have northbeam, I recommend you use an interval of time that matches your consideration period (e.g. 7/14/30 days) I personally used this method to help forecast and strategize HexClad’s Q4/BFCM overall spend & rev on a daily granularity.

Media Mix Modeling/forecasting Your measurement channels (nb, tw, prescient, haus, etc) help you inform your media mix, but I’ve seen this a trillion times over where brands think they are spending the correct amounts, when in actuality, they are off by a few %’s… (or worse) Compound this over a few days, months, quarters (or even years), and you’re looking at $$$ on 🔥🔥🔥 Spend & media mix forecasting is just as (if not more) important than the learnings you gained to build it. With this section of the sheet, you can easily swap your mix to make decisions REAL-TIME. No more questions. No more over or under spend. No more last minute realizations. Give your media buyers a PLAN they can actually stick to. (bonus: custom selector to choose between forecast, prior year, previous period, or actualized— WITH custom comparisons for each). If I had this 2 months ago it would’ve made my life a hell of a lot easier…

Channel-level breakdowns; Any multi-touch attribution tool is great, but when it comes to spend forecasting, not so much. An all-in-one dashboard to help you track, forecast, and optimize any and all paid media channels (with pre-built dashboards for each!) Easily track spend compared to forecast, previous period, or previous year (with chart visuals). Added bonus: track additional metrics with pre-built custom breakdowns. A couple of additional KPI’s to track per channel; - net new visit % (how many new folks are hitting site for the first time) - net new reach (matters more at scale) - 1dc/other roas targets (to track if you are above or below benchmark performance) - new customer roas/cac - upper funnel investment

Pace

Pace

I never got this 🤧

Bro give me this

this looks awesome london

plz ser, may i have sheet

Pace

Would love to see this!

Looks awesome! Eager to see it. Thanks for sharing.

I’m in London, got my beat from freakin @londonspilker 🔥 I need this bro!

Derek Lauermann just shared on a webinar that we must all get this. Following @londonspilker Thanks!

Done, please send

Pace 🫡

hell yes yes please!

Thanks done!

Done! (Had a call with your team the other day 🤛)

Pace

plz send this to me london I am in love

yes please!

done!

Thanks!

Nice work mr @londonspilker

Thanks for sharing!

Need!!

haha it's here! you're the man

Ohhhh I want this

I want.🤤

pls sir

This is sick man. So much value here. Stoked to check it out

Hell yeah SEND IT

Wow

Please 👋

This is glorious - using supermetrics to power it all?

PACE
