Social Media Analytics Dashboard

The Project

For a German media company, we developed an analytics platform that centrally connects Facebook pages and Instagram business accounts and automatically evaluates their performance data. Clients connect their social media presences via OAuth and receive a clear dashboard with trends, comparison periods, and export functions — without having to work with the Meta API themselves.

Challenge

Manual evaluation of social media metrics through the native Meta interface is time-consuming and confusing — especially when managing multiple pages and accounts. Additionally, Meta regularly changes API versions and deprecates old interfaces. The goal was a solution that collects data automatically, works version-safely, and can serve multiple clients on a single platform.

Core Features

• OAuth Integration: Clients connect their Facebook pages and Instagram business accounts through a guided authorization process — passwordless login via magic link.
• Automated Data Collection: Daily synchronization of performance metrics via scheduled background jobs — without manual intervention.
• Insights Dashboard: Interactive charts with 30-day trend analyses and comparison to the previous period for all relevant metrics (reach, engagement, follower growth, and more).
• Instagram Integration: Separate analysis of Instagram business accounts with dedicated metrics and follower statistics.
• Multi-Version Support: The system supports multiple API versions simultaneously and automatically warns about upcoming deprecations — upgrades can be performed with a single click.
• CSV Export: All insights data can be exported for external processing.
• Admin Area: Client management with approval workflow, dynamic configuration of OAuth permissions without code deployment, and comprehensive activity logging.
• Automatic Token Management: Access tokens are renewed regularly — expired or invalid connections are detected and reported.

Technical Highlights

• Multi-tenant architecture with client-isolated data storage and integration with an external partner system
• Dynamic API version management — supports multiple Meta Graph API versions in parallel with automatic deprecation detection
• Encrypted token storage for all external API credentials
• Complete REST API with token authentication for programmatic access to all insights data
• Comprehensive test suite with feature and unit tests including mocked API responses
• Seamless activity logging with error tracking and notifications for sync issues

Result

The platform enables the media company and its clients to monitor social media performance centrally and automatically. The manual effort for data collection and reporting is almost entirely eliminated. Dynamic version management ensures that API changes from Meta are detected early and can be migrated without downtime.