73% profitability increase of Ceneo.pl

Challenge

• Creation of an effectiveness report for Ceneo.pl. The aim was to integrate cost and sales data in order to automatize auctions by stocks, attractive price as well as margin levels. 

Sollution

• Data integration from 3 report systems: internal ERP system, Google Analytics and Ceneo.pl cost panel
• For this purpose we used VBA scripts in MS Excel and Python.
• Regular campaign optimization 

Result

• 73% profitability increase on Ceneo.pl in Jan-July 2020*

*Profitability change results from comparing Jan-July 2020 to Jan-July 2019 periods. Report based on retail data from Google Analytics and from Ceneo.pl cost calculation table.