Automating Marketing Analytics: From Spreadsheet Chaos to an Intelligent Data Hub
I successfully migrated a business from cumbersome and error-prone Google Sheets to a centralized web application with a robust database, transforming their marketing analytics from a manual chore into a strategic advantage.
Hereβs what was delivered:
A Single Source of Truth: Engineered seamless integrations with all key platforms:
Advertising: Facebook Ads, Google Ads, TikTok.
Websites & E-commerce: Tilda (via webhook and file import) and WP/WooCommerce for order data.
CRM: Voiptime for call tracking and order attribution.
Finance: Finmap for automatic cost reporting.
Instant Calculations & Insights: The application automatically processes data using custom formulas to calculate advertising effectiveness, saving countless hours of manual work and providing real-time insights.
Automated Reporting & Export: The system aggregates all data into unified, easy-to-read reports. Users can quickly view performance and download any data set to Excel for further analysis with a single click.
Smart Permissions & Notifications:
A flexible user role system ensures each team member sees only the data relevant to them.
Convenient in-app and Telegram notifications keep the team informed about system status and critical events in real-time.
Contributed to a payment orchestration platform. Integrated payment provider connectors. Resolved bugs and implemented logic patches using ELK stack for log analysis. Improved system stability by troubleshooting issues reported through Sentry.
Symfony5PostgresqlELKSentry
Stellium (Local Web Studio)
July 2020 - April 2023 (~2 years 10 months)
Full Stack Developer
Full-cycle web development with focus on e-commerce and business systems. Developed CRM system using Symfony 5 and React/TypeScript. E-commerce development on OpenCart with performance optimization, SEO implementation, and client features.