AdBrief – Automated Marketing Reports

Transform Excel & JSON data into professional, interactive HTML reports

Stop sending boring spreadsheets to clients. This R & Quarto-based system takes your raw marketing metrics and generates beautiful, client-ready HTML reports with interactive visualizations and automated performance insights.

---

🚀 Why use this? (For Agency Owners & Marketing Managers)

• Professional Presentation: Move beyond Excel. Provide your clients with interactive, high-end HTML reports.

• Zero Manual Design: Your charts, tables, and KPIs are formatted automatically.

• Flexible Data Input: Use the tools you already know—just fill out an Excel template or export a JSON file.

• Automated Insights: The system calculates growth, ROI, and efficiency (CPA, CPM, etc.) for you.

🛠 Custom Implementations & Consulting

Need this tool connected directly to your Google Ads, Meta, or CRM? I offer custom services to tailor this project to your specific workflow:

• Direct API Integration: Skip Excel and pull data directly from marketing platforms.

• Custom Brand Design: Tailor the report’s look and feel to your agency’s corporate identity.

• Advanced Analytics: Custom attribution models and deeper funnel tracking.

Contact me: robin.andreas.schmid@gmail.com

---

⚙️ Technical Overview

This project uses R and Quarto to bridge the gap between data processing and professional document rendering.

Key Features

• 📊 Performance Visualizations: Time-series analysis with automated trend detection.

• 💰 Efficiency Tracking: Automated calculation of CPM, CPC, CPL, and CAC.

• 📝 Executive Summary: Programmatic growth analysis and commentary generation.

• 📂 Multi-Format Support: Seamlessly handles both .xlsx and .json inputs.

---

🚀 Quick Start

1. Prerequisites

Ensure you have R and Quarto installed.

2. Setup

Bash

# Install required R dependencies
Rscript setup.R

3. Generate a Report

You can provide your data as an Excel file or JSON.

Using Excel:

Bash

Rscript generate_report.R --file ./data/client_data.xlsx --output jan_2026_report.html

Using JSON:

Bash

Rscript generate_report.R --file ./data/client_data.json

Testing with Dummy Data:

Bash

Rscript generate_report.R --test

---

📊 Data Structure

The generator expects data in four main categories:

1. Client Info: Name, period, and high-level ROI.

2. Daily Stats: Time-series data (Date, Clicks, Cost).

3. Channel Performance: Breakdown by platform (Spend vs. Revenue).

4. Funnel Data: Conversion stages (Impressions → Sales).

Note: See data/test/dummy_data.xlsx or data/test/dummy_data.json for exact formatting examples.

---

🛠 Tech Stack & Requirements

• Engine: R 4.0+ & Quarto 1.4+

• Key Libraries: ggplot2 (Viz), gt (Tables), openxlsx (Excel), dplyr (Logic).

• Output: Standalone, self-contained HTML (perfect for email attachments).

---

📄 License

This project is licensed under the MIT License. Feel free to use and modify it for your own projects.