Daily reporting automation for digital campaigns at O2 Care Services
Location : France
The challenges
The marketing team at O2 Care Services collaborated with TrackAd to achieve the following three objectives:
- Reduce the time spent on reporting and collecting advertising investments
- Analyze the ROI of each campaign on a daily basis
- Automate the generation of internal performance analysis reports
Campaign Manager
TrackAd successfully automated our internal report, which is essential for analyzing our digital campaigns. The report updates with just one click and provides comprehensive information both at a global level and for each individual campaign. This allows us to analyze our sources and campaigns on a day-to-day and week-to-week basis. The time previously spent collecting data and updating the report is now dedicated to analyzing and optimizing our campaigns. Kudos to the TrackAd team for this solution!
The solutions
To meet these objectives, TrackAd connected to various data sources via API:
- Google Analytics to access all customer journeys and lead-related information.
- Traffic sources to retrieve campaign-related data (costs, clicks, etc.).
Additionally, TrackAd enabled an automatic API export of TrackAd data into Google Sheets.
The destination file was designed with pre-recorded formulas, ensuring that TrackAd data is seamlessly integrated into the correct cells of O2 Care Services’ internal report. This setup provides the team with a comprehensive, detailed, and daily monitoring of their campaigns.
The results
of the Google Sheets report used by O2 Care Services while maintaining the original format
Discover more case studies
