Marketing Analytics

Automating daily campaign audience creation in Google Ads and Facebook for MandM Direct

Summary
Datatonic designed and built an automated, production-grade pipeline in Google Cloud Platform to export customer audiences from BigQuery, loading them into Facebook and Google Ads using their respective APIs.
Key figures
  • Progressed from a manual to fully automated digital campaigns creation process.
    Scalability to 200+ custom audiences across six European markets, configured for flexibility to add new ones in the future.
    Automated logging and export history stored in Google Cloud for auditing purposes.
    Enabled our client to replicate the automated workloads in other markets through code sharing sessions and detailed technical documentation.
Project date

Overview

The Challenge

Challenge

MandM Direct was looking to automate its process for creating custom audience campaigns within Google Ads and Facebook. Their Data Science team had worked on developing new RFM customer segmentation to aid personalised targeting strategies across its digital marketing. Despite such advances, the Digital Performance team were manually uploading these audiences to Google Ads and Facebook, on a daily basis. With ever-advancing customer and marketing strategies, our client wanted to automate this process with a solution that was scalable to additional advertising platforms and markets.

Our Solution

Our Engineering team designed and built an automated, production-grade pipeline in Google Cloud Platform to export customer audiences from BigQuery and loading them into Facebook and Google Ads using their respective APIs. The solution was orchestrated and scheduled to run on a daily basis using Cloud Composer. Google Cloud security best practices were implemented to minimise access to Personally Identifiable Information (PII) data; this was delivered through service accounts designed with specific IAM permissions. Stackdriver enabled live emails alerting of any job failure, and the full logging history was stored for auditing purposes.

The deployed pipeline updates more than 200 custom audiences across six European markets, every day.

 

“Working with Datatonic on this project enabled us to create a greater variety of more complex first-party customer audiences to push into different marketing platforms. This process has helped us be much more personalised in the ad creative we are showing to our customers; helping them to discover the brands and products they will be most interested in. The fact that the audience creation is automated means our teams are not having to handle any personally identifiable information, plus the process runs daily, so our customer is more in control of their data.”

– Tom Goode, Customer and eCommerce Director

Need a data partner?
We work in a wide range of disciplines within data science and analytics. Let’s chat about your project and how we can help you.
Get in Touch
Up next
Careers
View now