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.