{"repo":"AmirhosseinHonardoust/Content-KPI-Monitor","free":true,"listed":false,"github":"https://github.com/AmirhosseinHonardoust/Content-KPI-Monitor","clone":"git clone https://github.com/AmirhosseinHonardoust/Content-KPI-Monitor.git","description":"A Streamlit + SQLite + Python dashboard for monitoring content performance KPIs. Tracks impressions, clicks, conversions, CTR, and conversion rates across categories and time. Includes an automated ETL from CSV → SQL view, interactive charts, and filters for data-driven content optimization.","language":"Python","stars":23,"topics":["analytics-dashboard","business-intelligence","content-analytics","dashboard","data-analysis","data-driven-decisions","data-visualization","etl-pipeline","kpi-tracking","marketing-analytics"],"license":"MIT","category":"dashboards-admin","readme_excerpt":"Mini Content KPI Monitor (SQL + Python + Streamlit) A compact, production‑quality analytics project for tracking content performance . It ingests a single CSV of daily metrics into SQLite , computes KPIs in a SQL view, and serves a Streamlit dashboard to explore CTR , Conversion Rate , Dwell Time , and Bounce Rate with filtering and drill‑downs. --- Highlights - Simple data model ( content daily ) with a derived SQL view v content kpi that calculates ctr and conversion rate . - One‑command ETL from CSV → SQLite (idempotent, safe upserts). - Streamlit dashboard with: - KPI tiles - CTR trend over time - Conversion Rate by category - Top content table (sortable, filterable) - Future‑proofed UI : st.plotly chart(..., config=...) (no deprecated args). --- Architecture Folders --- Data Model & KPIs Table: content daily - date (YYYY‑MM‑DD), content id , title , category - impressions (int), clicks (int), conversions (int) - avg dwell sec (float), bounce rate (0 – 1) View: v content kpi (defined in sql/schema.sql ) Formulas - CTR = clicks / impressions - Conversion Rate (CR) = conversions / clicks --- Quickstart 1) Create & activate a virtual env 2) Install dependencies 3) Generate example data (optional) Creates data/raw metrics.csv for 30 days across a few demo articles. 4) Ingest CSV → SQLite 5) Launch the dashboard Open the URL shown in the terminal (usually http://localhost:8501 ). --- Dashboard Guide KPI Tiles - Impressions , Clicks , Conversions , Avg Dwell (s) , Bounce Rate -","default_branch":null,"files":null,"tree":[],"storefront":"/r/AmirhosseinHonardoust","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/AmirhosseinHonardoust/Content-KPI-Monitor/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}