Evaluating social media activities across multiple platforms often requires consolidating various data sources. To standardize this process and make it more accessible, I developed an interactive reporting dashboard based on Python and Streamlit.
Structure and Functionality
The goal of the dashboard is to provide a clear, browser-based overview of key metrics without relying on complex BI tools. The data foundation consists of two simple CSV files: an export of the social media data and a reference file for benchmarks.
Core features include:
- Filters: Timeframes and platforms can be filtered directly in the browser.
- KPI Overview: A direct comparison of performance data against predefined benchmarks.
- Ranking: A color-coded overview of top and underperforming posts per platform.
- Visualization: Time series and platform distributions are visualized graphically.
Technical Implementation
The project is written in Python and uses Streamlit for the frontend. This enables quick local execution or straightforward hosting on servers. Setup is limited to cloning the repository, installing the dependencies, and starting it via a terminal command.
Availability
The complete source code and setup instructions are available on GitHub. The project is published under the Creative Commons BY-NC 4.0 license.
Link to code: Social-Media-Report Repository
← Back to Overview