Challenge

• Reducing company expenses connected with regular analysis
• Creating a full analytical ecosystem and data visualization based on a few marketing and web activity tracking tools

Solution

• Advanced marketing tools configuration: Google Analytics, Adobe Analytics and social media monitoring tools
• Creating a data structure model
• Ordering various format data using VBA and Python
• Data export to data warehouse based on Amazon Redshift
• Creating interactive dashboards monitoring KPIs and creating a campaign result comparing tool in Tableau

Result

30% savings connected with ongoing reporting and improving e-marketing optimization