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.
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.
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.
“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.”
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.
For more information, check out our article on automating audience creation.
If there’s data, we can optimise, innovate with and automate it to drive business value. Find out how we’ve supported the biggest brands across industries.
Know exactly where and how to start your AI journey with Datatonic’s
three-week AI Innovation Jumpstart *.
* Duration dependent on data complexity and use case chosen for POC model
With your own data sets, convince your business of the value of migrating your data warehouse, data lake and/or streaming platform to the cloud in four weeks.
With your own data, see how Looker can modernise your BI needs
with Datatonic’s two-week Showcase.