PROBLEM STATEMENT - Impression, click and cost data must be collected and processed manually and by the entire affiliate team once a week. This very time-consuming process allows reports to be prepared on a weekly basis only. Sub-weekly control of dynamic marketing campaigns is not possible without additional effort.

SOLUTION - An automated tool (affiliator) collects the required data from the partners on a daily basis and links it to the internal KPIs. Daily updated reports are generated. It informs about budget overruns and conspicuous campaign developments.

TECHNOLOGY - Ubuntu Linux, Cronjobs, Password-Manager, Python, SQLite, HTML, Javascript and different APIs (XML, REST)

PROCESS OPTIMIZATION - The goal was to automate 80 percent of the data collection. The goal was achieved. As a result, the time required for data collection and preparation was reduced from 1-1.5 days by the entire team to just a few hours. Campaigns could then be managed on a daily basis with performance data updated daily. This had a positive impact on performance KPIs and ROAS. 

PARTNERS - The affiliator tool collected data (on daily basis) from: Affilinet, Billiger.de, Criteo, Facebook, Heureka, Kelkoo, Le Guide, ShopALike, Shopzilla, Smatch, Sociomantic, Zanox (Awin).

FUNCTIONS - The collected data has been normalized to the internal reporting standard. Standardized partner data was combined with internal sales and revenue data for further analysis. Automatic preparation of performance marketing reporting for camping management on daily and aggregated weekly basis. Notifications on budget overruns and conspicuous campaign developments are sent to the responsible managers.