Project: Development of a system to analyse the influence of coupons on sales in the context of total traffic

Problem: The customer actively used marketing traffic channels to promote their services and goods. Data on channels is presented in Google analytics (GA), Big Query (BQ), and in offline databases without integration with GA. The functionality offered by GA didn’t permit full analysis of the data through the sales channels.

Superimposition of offline channels with online channels produced misleading data sets. For marketing expense optimization, the customer decided to expand and modify its analytical tools to be able to deal with complex data structures – integrating more sophisticated attribution algorithms such as Markov chains was a top priority.

Solution: Create a web solution with rich functionality.

Create an infrastructure for interaction between the BQ and the data warehouse for attribution and implemented mathematical models of channel attribution. In the web interface, the user can choose from a wide range of parameters (time interval, channel aggregation type, type of “multi-channeling”, attribution method, etc.) to build multi-channel report.

The generated report is exported in MS Excel format.

Outcome:

  • With the help of the custom reports, the customer can now choose a specific multi-channel attribution model
  • Reduced budget for marketing and increased its effectiveness of marketing campaigns
  • Optimised return on expenditure due to corrected data flows
  • Our client was happy to endorse the quality of our work

Technological stack: Python 2.7, Python 3, Django, PostgreSQL, SQLite, Big Query, Google Analytics.

 

Testimonial

We thank Maxilect for developing the software solution for analyzing the chain of channels when making a purchase by the user. The task was done well. It was a pleasure to oversee the conscientiousness, efficiency and competent attitude to the work of the company’s employees during the whole period of our cooperation.

myToys, Russia

Leonid Olipa, Web Analyst

Tell us how we can help