Full Stack Developer (Symfony + React)
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.
PHP 8.4Symfony 7.2API-Platform 4React 18React-admin 5Redis 7 (cache & queue)MariaDb 10DockerCI/CD