1. Home
  2. Blog
  3. Measuring Influencer campaigns with Marketing Mix Modeling
Measurement

Measuring Influencer campaigns with Marketing Mix Modeling

by Ilaria Di Lecce
In short

Marketing Mix Modeling (MMM) is a statistical model that matches spikes and dips in sales to spend on each marketing channel and to external factors, without needing any user-level data. Applied to influencer marketing, it ties the budget of each post to the day it went live and estimates how many incremental sales it drove, including those promo codes miss. The output is an incremental CPA you can compare with your promo code CPA.

Cover image for the Strategy & ROI category: a slice of pumpkin and mushrooms on a green stone surface
Table of contents3 sections · 7 min
  1. 01Measuring the impact of influencers
  2. 02Marketing mix modeling explained
  3. 03Marketing mix modeling tutorial

Brands keep investing more in influencer marketing, but they still struggle to measure the impact of all those dollars spent.

Measuring the ROI of influencers was something we spent a lot of time thinking about when building Roundabout, so we know how hard it can be. We quickly found you can’t rely on promo codes alone: too many customers forget to use them, and less reputable affiliates are tempted to share codes through coupon exchange portals to earn more clicks.

Instead promo codes need to be part of a wider, more holistic approach to measurement, that integrates digital tracking and Marketing Mix Modeling (MMM), working together to eliminate wasted media spend on campaigns that aren’t driving incremental sales.

We’ll start by covering the measurement issues you might be finding with your influencer marketing campaigns. Next we’ll give a brief introduction to Marketing Mix Modeling, what its strengths and limitations are, and why modern DTC brands have adopted it.

Measuring the impact of influencers

Influencer marketing is one of the less measurable digital channels, because it’s “off-book” – rather than paying a platform like Meta (Facebook & Instagram) for advertising, you’re typically contacting individual influencers and working with them directly.

Results often vary, as a great deal of campaign success comes down to:

  1. how relevant your product is to an influencer’s audience
  2. if the influencer is passionate about your product
  3. the creative execution of your campaign

There’s also the problem of fraud: fake followers and inflated engagement, which leads to marketers having to check how reliable a profile is. The FTC and social media platforms are also cracking down on proper disclosure of adv posts by influencers.

One of the primary methods for measurement most brands use is the tried and true promo codes. This technique dates back to the 1920s, during the Great Depression when coupon usage was at its height. Early scientific marketers like Daniel Starch and Claude Hopkins pioneered the practice of assigning unique promo codes to different ad copy variations in order to test their effectiveness.

This simple but effective technique unfortunately has significant flaws when used in today’s digital economy.

  • Browser extensions like Honey or Rakuten auto-fill promo code form fields with whatever offers the greatest discount
  • Savvy shoppers have been trained to Google for "[brand] promo codes" on reaching checkout, to see if they can get any money off their order
  • Affiliate fraudsters practice “cookie stuffing” to tag as many people as possible with their affiliate code, taking a rake on whatever they purchase

In none of these scenarios are the sales recorded “incremental” – they still would have happened if you didn’t have a promo code form field – so any money paid out to affiliates or discounted from the price of the product was wasted.

On the other side of the ledger, many customers just simply forget to use their promo codes! Or perhaps they didn’t notice the code buried in the text of the post. Either way, any marketer with experience running influencer campaigns will tell you they see spikes in sales when influencer campaigns have gone live, over and above what they could explain with tracking.

Marketing mix modeling explained

Marketing Mix Modeling (MMM) was introduced in the 1960s to match spikes and dips in sales to actions taken in marketing (and external factors). When done well, it can tell you the incremental impact of each part of your marketing strategy, so you can make data-driven decisions on where to allocate your marketing budget.

Historically,  it was primarily used by large advertisers, the kind spending millions on SuperBowl ads, but has been adopted by modern DTC brands in the wake of Apple iOS14 privacy changes, GDPR/CCPA and ad blockers limiting marketers' ability to track users. MMM works without needing any user-level data, so it’s perfect for hard to track channels like TV, Podcasts, and Influencers.

Once you’ve built a model you’ll be able to determine how much to spend on each marketing channel, re-allocating budget from poor performing channels to those with more room to scale. It serves as a second-opinion to your digital tracking and analytics, often being the tiebreaker between what Google Analytics, your promo code tracking, and the “how did you hear about us” survey says about what channels deserve credit for sales.

Marketing Mix Models can be difficult to get right, and sometimes require advanced statistical knowledge, for example familiarity with Bayesian algorithms. They offer more of a top down, channel by channel view of overall impact, rather than being able to drill down into individual campaigns, creative/message, or tactics. That said, if you get it right, MMMs are a valuable part of the modern attribution stack.

Marketing mix modeling tutorial

To follow along, check out the template from this post, based on data for a fictional ecommerce company, taken from the marketing mix modeling courses at Vexpower:

> Influencer MMM Template

For a small and medium-sized businesses, a Marketing Mix Model can be a complex project, taking multiple people months to complete, and ongoing work to maintain. However you can get to a “good enough” model in an afternoon using nothing but Excel or Google Sheets.

Step 1: gather data

Spreadsheet with the model’s weekly data: product sales, Instagram followers, influencer campaign spend, press reach and Amazon rank
Figure 1Open full resolution ↗

You need data from across your marketing mix, anything you pay money for that drives sales, so that the model can separate the impact of influencers from everything else. It needs to be in tabular format as shown, which means one row for each day or week, and one column for each channel or campaign.

Note: When you’re working with channels like YouTube, you’re unlikely to get all the results on the day or week the content is posted. If you’re expecting long term ongoing traffic, this model will not attribute those long-term benefits.

—

Pro  Tip for Modeling Influencers:

Match spend to your posting schedule

The trick is to match up what you spent on each post with when that post went live. Otherwise the model will be looking in the wrong place for impact. Allocating spend to the day the deal was closed is a common misstep, as is grouping spend to the calendar week or month.

—

Ideally with every media channel, you want to measure the effect of spend: how many dollars do you get back for every $1 spent? Meaning, if possible, you should model the actual cost of your campaigns, not the reach, impressions, followers, or other easy to game metrics.

You may also want to control for impactful external variables, like in this case your Amazon Ranking or PR, though you should be careful how you incorporate them.

Step 2: build model

LINEST output in Google Sheets: coefficients for Amazon rank, press reach, influencer spend and Instagram followers, with MAPE, R squared, incremental CPA and promo code CPA
Figure 2Open full resolution ↗

This inscrutable pile of numbers is the result of the LINEST function, available in both Excel and GSheets. The top line are the coefficients (note: they come out in backwards order), which tell you the impact of each marketing activity (presuming the model is correct).

You can interpret the coefficients as follows. For Roundabout Influencer Campaigns the coefficient is about 0.025, meaning that for every $1 of budget you got about 0.025 sales. If you divide 1 by the coefficient you get the incremental Cost Per Acquisition (CPA), which in our model is about $40. You can compare this to the number your promo code tracking gives you, which may be higher or lower.

The multiplier is the ratio between these two numbers, which you can use as a rule of thumb when estimating the ‘true’ ROI of your campaigns going forward. In our example promo code tracking shows a CPA of about $64, so the multiplier is 0.63. If you run a new campaign that shows a $50 CPA by way of promo code tracking, you can be reasonably confident the “true” CPA was closer to $32 (50 x 0.63 ≈ 32).

Step 3: validate model

Model validation charts: actual versus predicted product sales week by week, and absolute percentage error for each week
Figure 3Open full resolution ↗

In our case we can see that the model tracks past sales well. The MAPE – a measure of accuracy/error – is sitting at 13.4% overall, with some weeks much more accurate than others. This is a good start but it’s not sufficient!

Next up we should check that our model can predict new data accurately that it hasn’t seen yet: for example the next 4 weeks worth of sales.

It’s also important that the model is plausible: if it had told us our influencers were driving sales at $5 not $50, that would be hard to believe, and a sign there’s something wrong with the model. In any event these models should be validated and calibrated against what you’ve learned from other marketing attribution methods, including and especially randomized controlled experiments (A/B tests).

As you push for higher accuracy and statistical validity you’ll start to want to adopt more advanced techniques like Bayesian MMM, as well as measuring the lagged impact of your influencer campaigns (how long after the post do sales still occur?) and the diminishing returns (how much can you spend before it gets saturated?), and a number of other important features of a good Marketing Mix Model. This is where you need to start learning advanced MMM techniques, getting a data scientist on hand, or hiring a vendor like Recast that can handle this complexity and make sure your model is accurate.

Frequently asked questions

Why aren't promo codes enough to measure an influencer campaign?

Many customers forget to use the code or don't notice it in the post, so part of the sales a campaign drives never gets recorded. On the other hand, browser extensions, coupon sites and affiliate fraud attach codes to purchases that would have happened anyway. That's why promo codes need to be part of a wider approach that integrates digital tracking and Marketing Mix Modeling.

What data do I need to build a Marketing Mix Model?

You need data from across your marketing mix in tabular format: one row for each day or week and one column for each channel or campaign, plus sales. For influencers, model the actual spend rather than reach or followers, and assign it to the day the post went live. You can also control for external variables like Amazon rank or press coverage, carefully.

Can you build a Marketing Mix Model in Excel or Google Sheets?

Yes: you can get to a "good enough" model in an afternoon with the LINEST function, available in both Excel and Google Sheets. The coefficients show the impact of each activity, and dividing 1 by the influencer spend coefficient gives you the incremental CPA. For higher accuracy you'll need more advanced techniques like Bayesian MMM.

How do you validate a Marketing Mix Model?

First check how well the model reproduces past sales, for example with MAPE, then whether it accurately predicts weeks it hasn't seen yet. The result also has to be plausible, and it should be calibrated against other attribution methods, especially randomized controlled experiments (A/B tests).

Keep reading

Data & Method →Measure a campaign without reachCampaigns →from shortlist to report, we run itCreator Analysis →understand a creator before you pick them

Keep reading

All articles →
Hand raising a glass of rosé wine against a sunlit orange wall, with the label “Strategy & ROI”
Measurement8 min

30 Influencer Marketing KPIs that drive focus & action

KPIs vs metrics, how to choose them from your goals, and ready-to-use examples for influencer management, content, sales, conversions and awareness.

Cover with the label “Strategia & ROI” over a close-up texture of cosmetic cream
Measurement19 min

How to measure influencer marketing ROI: 7 proven tracking methods, boss-proof

7 ways to measure influencer campaign ROI: promo codes, UTMs, unique landing pages, creator insights, surveys and marketing mix modeling. Formula included.

Woman with curly hair applying cream to her face while holding the jar, with a Strategy & ROI label
Measurement12 min

Influencer Marketing ROI: How to Measure & Understand that Influencer Marketing is a Valuable Channel for your Brand

How to measure influencer marketing ROI and prove the channel is worth it: direct ROI, indirect impact, conversion paths and content savings.

From the guide to the campaign, in one place

Analyse creators and build a quote on the Free plan, with no expiry. If you would rather start with a conversation, talk to a specialist.

No credit card · Free never expires