# Reporting & Insights Tasks

Module scope: pulling platform performance data in, reconciling it against internal records, and surfacing it back to users as chat-driven insights. See `docs/TASKS.md` for the full-program index.

| Tasks | Hours |
|---|---|
| 3 | 108 |

---

## Id: 21
- **Phase:** MVP
- **Priority:** P0
- **Area:** Data Ingestion
- **Task:** Scheduled ingestion of platform metrics into normalized MySQL tables with idempotency
- **Description:** Build the scheduled jobs that pull performance metrics from every connected platform into normalized MySQL tables, written so re-running a job never creates duplicate or corrupted data.
- **Primary Role/Assignee:** Unassigned
- **Estimated Hours:** 40

## Id: 22
- **Phase:** MVP
- **Priority:** P0
- **Area:** Internal Data Reconciliation
- **Task:** Compare platform data with MySQL/internal data, detect discrepancies and flag source confidence
- **Description:** Cross-check ingested platform metrics against internal records, flag discrepancies (e.g. spend mismatches, missing events), and surface a confidence score for which source to trust when they disagree.
- **Primary Role/Assignee:** Unassigned
- **Estimated Hours:** 32

## Id: 28
- **Phase:** Insights
- **Priority:** P0
- **Area:** Insights in Chat
- **Task:** Natural-language campaign Q&A, KPI summaries, comparisons, trends, root-cause analysis and recommendations
- **Description:** Let users ask questions about their campaigns in the chat interface ("why did CTR drop last week?") and get back KPI summaries, comparisons across campaigns/platforms, trend analysis, root-cause explanations, and next-step recommendations.
- **Primary Role/Assignee:** Unassigned
- **Estimated Hours:** 36

---

## Current implementation status

Not started — depends on `docs/platform-tasks.md` adapters existing to pull metrics from.