The O2 Care Services marketing team worked with TrackAd to meet the following three objectives:
. Reduce the time spent on reporting and collecting advertising costs
. Analyze the ROI of each campaign on a daily basis
. Automate the generation of the internal performance analysis report
In order to meet these objectives, TrackAd has connected to various data sources via API :
. Google Analytics to have all the conversion paths and lead information
. Traffic sources to get information about campaigns (costs, clicks, …)
TrackAd has also enabled an automatic export via API of TrackAd data into Google Sheets. The destination file was created with pre-saved formulas. This way, TrackAd data integrates directly into the right cells of O2 Care Services’ internal reporting and provides the team with complete, detailed, daily campaign tracking.
. Automation of the Google Sheets report used by O2 Care Services while keeping the original format
. Daily ROI monitoring at each data level, starting at the Source level and working down to the Lead and Contract levels.