Edit
Contact us
Salocin Group Leaders in data and AI-enabled connected customer experiences
Edit Engineers of connected customer experiences
Join the Dots Independent, data-led media thinking for sustainable growth
Wood for Trees Optimisers of future fundraising performance
  • Home
  • Our services
    • Cloud solutions
    • Data science
    • Modern Data Platform
    • Privacy and AI compliance
  • Our partners
    • Microsoft
    • Apteco
    • Salesforce
  • Our insights
    • Blog
    • Case studies
    • Reports
    • Webinars
    • Whitepapers
  • About Salocin Group
    • Careers
  • Contact Salocin Group
  • Home
  • Who we are
    • B Corp
    • Careers
  • Our work
  • What we do
    • Intelligent data
    • Marketing technology
    • Transformational CRM
    • Our technology partners
    • Privacy review
  • Our insights
    • Blog
    • Case studies
    • Reports
    • Webinars
    • Whitepapers
  • Contact Edit
  • Home
  • Broadcast media
  • Digital media
  • Print
    • Direct mail
  • Data
    • Our work with Herdify
    • EPiC
  • Media agency
  • Our insights
    • Blog
    • Case studies
    • Reports
    • Webinars
    • Whitepapers
  • About Join the Dots
    • Careers
  • Contact Join the Dots
  • Home
  • Services
    • Actionable insight
    • Data discovery
    • Data engineering
    • Data hygiene
    • Privacy review
  • Products
    • InsightHub
    • Apteco
    • Microsoft
    • Data management
    • Consent and preference management
  • Our insights
    • Blog
    • Case studies
    • Reports
    • Webinars
    • Whitepapers
  • About Wood for Trees
    • Operating principles
    • Careers
  • Contact Wood for Trees
Blog

Measuring real campaign value with Power BI and causal impact analysis

By Edit | 12 Nov 2020

You only know how well your campaign is working if you can ask the data to prove its impact. For when a typical control sale method doesn’t work, we’ve developed a way to measure the real-world success of your campaigns using causal impact analysis combined with Microsoft Power BI.

And it works. Having run many B2B campaigns for a leading energy provider operating in global markets stretching from the UK to the Far East, this causal impact analysis showed where and how much value these campaigns added. Vital knowledge to help our client plan and target campaigns better for the future. Here’s how we do it. It could help your marketing campaigns too.

What is causal impact analysis?

Causal impact analysis is a data science tool that uncovers the real-world value of your marketing by considering the effects that outside factors can have. Originally developed by Google largely to test the impact of website changes, our data scientist Andy Aldersley took the methodology and adapted it as a means of analysing how sales are affected by email campaigns for this leading energy provider.

When you’re running several campaigns in tandem and cannot use methods such as A/B testing, causal impact analysis gives you an overview of how much of an impact your campaigns have had. This was the case for our client. As a B2B provider, where account managers maintain close links to their customers, they could not afford to withhold campaigns from certain customers as would be required with an A/B test.

Also, there are many external factors that can affect sales for a complex, global organisation like our client’s. To truly measure the impact of campaigns for a client like this, you need a solution that can account for all these factors.

That’s what causal impact analysis can do. It allowed us to measure the true impact of campaigns while still sending them to the relevant customers and still giving us an overview of various external factors within the market.

How we analyse the data

So, how does causal impact analysis work? Essentially, we’re trying to find out if a marketing campaign has worked based on an external piece of data that reveals outside factors in the market – for example, if a pandemic or changes in the political landscape have affected customers’ spending.

To do this, we build a model of the past behaviour of what we’d like to measure, namely sales, up until the point a campaign went out. This would be based on a mixture of data sources that wouldn’t have been targeted by the campaign. In our client’s case, the data tends to come from other companies from the same or other markets.

From there, we can predict what would have happened if we hadn’t sent the campaign – this is called the counterfactual model. When we compare the results of the counterfactual model against what we observed from the campaign, we can work out the campaign’s true impact.

To put all this into practice and present our findings back to clients in an understandable way, we turn to Microsoft Power BI.

Why use Power BI?

When monitoring the outputs of multiple counterfactual models, Power BI gives you an efficient way to report on their results and test what other aspects should influence your reporting. When running this kind of model, we run a very granular segment based on the profile of the customer.

This means we can easily say which campaigns work for certain types of customers and which work better for others. What that means for you is that we can quickly and easily find out which attributes are important for your campaigns and how to improve your targeting moving forward.

In our client’s case, we sit over the top of all the transactional data going through one of their refuelling solutions, including where the programme’s cards are being used, how much fuel is being bought and what service products are going through particular accounts. So, we could see how campaigns around products were being targeted.

By building our models, we could see exactly how much influence a campaign was having on product sales. With so much data to work through, putting it through Power BI reduces the time spent on this analysis by several hours. Power BI also produces the visual analytics to help us understand what causes customers to respond to a campaign and drive revenue, as well as which markets the campaign worked best in.

How will this benefit your business?

Using causal impact analysis and Power BI together reveals the real-world effect of your campaigns, finding out the true cause of effects to your KPIs and, ultimately, sales. With this information, you can determine how to change your campaigns and who to target better to improve your sales.

In our client’s case, one of their 2021 goals in working with us is to take the lessons learned from our analysis and use it to tailor their marketing activity. Thanks to our work, they were able to see the relevancy of different campaigns and how to reduce the number of sends – this could eventually lower the costs of their marketing and increase return on investment.

Like this leading energy provider, this approach is best applied to clients working with a high volume of transactional activity – for example, in the retail or hospitality industries. With this large amount of data, as well as any third-party datasets or groups of controls that you’ve got, we can model the expected behaviour of your clients and determine the effectiveness of your campaigns and their targeting.

However, while our approach to causal impact analysis has been designed to be easily adapted to many different clients, this combined with Power BI isn’t for everyone. We can find what’s best for you. Our data science team works with clients to uncover what solution will suit their needs and help them make the best marketing decisions.

Contact us to see what we can do for you.

1.0.0.20

Share this

  • Email
  • WhatsApp
  • LinkedIn
  • Facebook
  • X (Twitter)

More insights

AI isn’t going to take your job (unless you really want it to) 
Blog

AI isn’t going to take your job (unless you really want it to) 

By Edit | 18 Jun 2024
Customer relationship marketing: How generative AI is revolutionising engagement  
Blog

Customer relationship marketing: How generative AI is revolutionising engagement  

By Edit | 4 Apr 2024
Personalisation as a process
Blog

Personalisation as a process

By Edit | 8 Mar 2024
  • Privacy policy
  • Cookie policy
  • Ts&Cs
  • Report a concern

© 2025 Edit, part of Salocin Group Ltd. All rights reserved. Company no.: 0362​4881. VAT no.: 4208​34911.

Salocin Group Certified B Corporation | Cyber Essentials Certified | British Assessment Bureau, ISO 27001 Information Security Management
Salocin Group
Your cookie preferences

We use cookies to ensure this website functions properly, to analyse website traffic and for marketing purposes.

Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage {vendor_count} vendors Read more about these purposes
View preferences
{title} {title} {title}