Case Study
Optimizing Email Marketing with Custom Data Pipeline
CHALLENGE:
Our client, a leading e-commerce brand, was struggling to keep track of their email campaign performance on Klaviyo, their email marketing platform. Despite having a wealth of data, they were unable to efficiently analyse and visualise their email campaign data to make informed business decisions.
APPROACH:
Our team developed a customised data pipeline using Klaviyo API, Google Sheets, app script, and bigquery to capture all the required metrics of each campaign on a daily basis. The data was stored in Google Sheets, and technical queries were run daily to move the data to BigQuery and delete the Google Sheets to avoid storage limitations.
RESULTS:
The dashboard enabled our client to make data-driven decisions and optimise their email marketing campaigns, resulting in increased engagement, higher conversion rates, and improved ROI. Our solution not only saved time and effort but also provided the client with valuable insights that helped them achieve their marketing goals.