MAHMOUD ABDELNABY
Reporting · PROJECT BLUEPRINT · 3

Client Monthly Growth Report Automation Spec & Deck PRD

Plan a monthly growth-reporting workflow and use the included executive narrative template. No time-saving outcome has been measured.

Problem it addresses

Build an open-source client monthly growth reporting system: 1) System architecture PRD detailing automated ETL data aggregation from Meta, Google, and GA4, 2) 12-slide executive deck narrative framework (Executive Summary, Blended ROAS, Channel Breakdown, Top Winning Creatives, What Worked / What Didn't, Next Month Action Plan), 3) Python summary compiler (compile_report.py).

Who it is for

PRO operating in high-growth e-commerce, digital publishing, and direct-response marketing across Saudi Arabia, UAE, and Egypt.

What is inside

Key files listed in the README repository architecture:

  • ARCHITECTURE.md
  • DATA_MODEL.md
  • LICENSE
  • MONETIZATION.md
  • prd/reporting-automation-architecture.md
  • PRD.md
  • PROBLEM.md
  • README.md
  • reports/sample_client_executive_summary.md
  • ROADMAP.md
  • sample_data/monthly_ad_exports.csv
  • src/compile_report.py

How to evaluate and use it

  1. Read the README first and confirm that the documented problem matches your use case.
  2. Inspect the listed files to find the data, tools, templates, and tests relevant to your task.
  3. Follow the repository’s Quick Start and check prerequisites before running commands.
  4. Compare outputs with documented examples and review limitations before using them in a decision or client workflow.

Quick Start from the README: python -m unittest discover -s tests · python src/compile_report.py --help

Scope and limitations

  • Multi-Source API Merging: Spec outlines programmatic ingestion and reconciliation across Google Ads, Meta Ads, TikTok, and GA4.
  • Executive Deck Generation: Mandates high-level North Star metrics (MER, Blended ROAS, Contribution Margin) before granular channel tables.
  • Currency Normalization: Formats blended reports across GCC currencies using central bank monthly exchange rate benchmarks.

This page summarizes the available documentation; it does not establish performance or business results. Verify data and prerequisites before use.

Related repositories