Automated Reporting Dashboards for Ads: Looker Studio, Custom Dashboards & Scheduled Reports

Manual ad reporting is the tax that every media buyer pays. You pull data from Meta Ads↗ Manager, copy it into Google Sheets, add Google Ads↗ data, format it, add commentary, export to PDF, and email it to the client. Every week. For every client.

At 5 clients, it is annoying. At 20 clients, it is a full-time job. At 50 clients, it is unsustainable.

Automated reporting dashboards eliminate 90% of this work. Here is how to build them.

The Reporting Stack: Components You Need

Every automated reporting system has four layers:

1. Data Sources: Ad platforms (Meta, Google, TikTok), analytics (GA4↗), CRM
2. Data Connectors: Tools that pull data from sources into your dashboard
3. Dashboard Layer: Where data is visualized and delivered
4. Distribution Layer: How reports reach stakeholders (email, Slack, PDF)

Common Stack Configurations

Stack	Cost	Complexity	Best For
Looker Studio + Supermetrics	$40-120/mo	Low	Agencies with 5-20 clients
Looker Studio + Funnel.io	$300+/mo	Medium	Agencies with 20-50 clients
BigQuery + Looker Studio	$50-200/mo	High	Agencies with custom metrics needs
Custom Dashboard (Next.js + Firebase)	Dev cost	Very High	Agencies wanting white-labeled dashboards
AgencyAnalytics	$75-300/mo	Low	Agencies wanting all-in-one

Google Looker Studio: The Free Powerhouse

Looker Studio (formerly Google Data Studio) is the default choice for ad reporting dashboards because it is free, integrates natively with Google products, and supports third-party connectors for Meta, TikTok, and other platforms.

Setting Up a Multi-Platform Ad Dashboard

Step 1: Connect Data Sources

Native connectors (free):

• Google Ads
• GA4
• Google Sheets (for manual data or supplementary metrics)
• BigQuery

Third-party connectors (paid):

• Supermetrics ($40/mo for 1 connector, $120/mo for unlimited): Meta Ads, TikTok Ads↗, LinkedIn Ads, Twitter Ads
• Funnel.io ($300/mo): 500+ connectors, data warehousing, transformation
• Porter Metrics ($15/mo per connector): Budget-friendly Meta and TikTok connectors

Step 2: Design the Dashboard Layout

Recommended page structure for a client-facing ad report:

Page 1: Executive Summary

• Date range selector (always at top)
• KPI scorecards: Total Spend, Revenue, ROAS, CPA, Conversions
• Month-over-month comparison arrows
• Summary chart: Daily spend and revenue trend

Page 2: Platform Breakdown

• Spend allocation pie chart (Meta vs. Google vs. TikTok)
• Platform comparison table: Spend, Impressions, Clicks, CTR, CPC, Conversions, CPA, ROAS
• Platform-specific trend lines

Page 3: Campaign Performance

• Campaign-level table with sortable columns
• Top 5 campaigns by ROAS
• Bottom 5 campaigns by ROAS (the "fix these" list)
• Campaign spend vs. conversion scatter plot

Page 4: Creative Performance

• Ad-level performance table
• Creative fatigue indicator (frequency + CTR trend)
• Top performing creatives with thumbnails (via Google Sheets image links)

Page 5: Audience Insights

• Performance by age group, gender, device
• Geographic performance map
• Audience segment comparison

Page 6: Conversion Funnel

• Impression → Click → Landing Page View → Lead/Purchase funnel
• Drop-off rates at each stage
• Funnel comparison: this period vs. previous period

Step 3: Build Calculated Fields

Looker Studio calculated fields let you create metrics that do not exist in the raw data:

// ROAS (if not directly available)
SUM(Purchase Value) / SUM(Spend)

// Cost Per Acquisition
SUM(Spend) / SUM(Conversions)

// Click-Through Rate
SUM(Clicks) / SUM(Impressions) * 100

// Cost Per Mille (CPM)
SUM(Spend) / SUM(Impressions) * 1000

// Conversion Rate
SUM(Conversions) / SUM(Clicks) * 100

// Budget Pacing
SUM(Spend) / Monthly Budget * 100

// Performance vs Target
(SUM(ROAS) - Target ROAS) / Target ROAS * 100

Step 4: Add Conditional Formatting

Make dashboards actionable with color coding:

• ROAS > target: Green background
• ROAS 80-100% of target: Yellow background
• ROAS < 80% of target: Red background
• CPA > target: Red text
• Frequency > 3.0: Red text (fatigue warning)

Step 5: Schedule Email Delivery

Looker Studio supports scheduled email delivery:

1. Click the dropdown menu (top right) and select "Schedule email delivery"
2. Set frequency: Weekly (Monday 8 AM) or Daily
3. Add recipients (client emails)
4. Choose format: PDF or link to live dashboard
5. Add custom subject line: "Weekly Ad Performance Report - [Client Name]"

Limitation: Scheduled emails send the full report. You cannot send different pages to different recipients. For customized distribution, use a Make.com workflow that generates PDF screenshots and emails specific sections.

Custom Dashboard Architecture

For agencies that want full control, white-labeled dashboards, or real-time data beyond what Looker Studio offers, custom dashboards are the answer.

Architecture Overview

Ad Platforms (Meta, Google, TikTok APIs)
    ↓ (Scheduled Cloud Functions - every 4 hours)
Firestore / BigQuery (Data Storage)
    ↓ (Real-time listeners)
Next.js Dashboard (Client-Facing UI)
    ↓ (Scheduled exports)
PDF Reports / Email Summaries

Data Sync Layer

Use Firebase Cloud Functions (or AWS Lambda) to pull data from ad platforms on a schedule:

// Pseudocode for daily Meta Ads sync
Schedule: Every day at 4:00 AM Asia/Taipei

1. For each client in /clients collection:
   a. Get client's Meta access token from Firestore
   b. Call Meta Ads API: /act_{ad_account_id}/insights
      - Fields: spend, impressions, clicks, actions, action_values
      - Date range: yesterday
      - Level: campaign
   c. Transform response to standardized schema
   d. Write to /clients/{clientId}/dailyStats/{date}
   e. Write campaign-level data to /campaigns/{campaignId}/dailyStats/{date}
   f. Log sync result to /syncLogs

This is exactly the pattern used in the RedClaw platform, where dailySyncMeta and dailySyncGA4 Cloud Functions run daily to keep client dashboards current.

Dashboard Components

Build reusable chart components:

KPI Scorecard Component:

• Current value, previous period value, percentage change
• Color-coded arrow (green up, red down)
• Sparkline for 30-day trend

Time Series Chart:

• Line chart with dual Y-axis (spend on left, ROAS on right)
• Date range selector
• Comparison period toggle

Campaign Table:

• Sortable, filterable, paginated
• Inline performance indicators
• Click-through to campaign detail view

Alert Banner:

• Triggered when KPIs breach thresholds
• "Budget pacing 120% -- review by end of day"
• "Creative fatigue detected on 3 campaigns"

Real-Time vs. Batch Updates

Approach	Latency	Cost	Complexity
Real-time API polling	Minutes	High (API rate limits)	High
Batch sync (every 4h)	4 hours	Low	Medium
Daily sync	24 hours	Very low	Low
Webhook-driven	Seconds	Medium	Medium

For most ad reporting, daily sync is sufficient. Clients check reports once per day. Real-time is only necessary for high-spend accounts ($10K+/day) where budget alerts need to fire within minutes.

Scheduled Report Automation

Weekly Client Report Template

Structure your automated weekly report:

Subject: Weekly Performance Report | [Client] | [Date Range]

EXECUTIVE SUMMARY
- Total Spend: $X,XXX (vs. $X,XXX prev. week, +/-X%)
- ROAS: X.Xx (vs. X.Xx prev. week)
- Conversions: XXX (vs. XXX prev. week)
- CPA: $XX.XX (vs. $XX.XX prev. week)

TOP PERFORMERS
1. [Campaign A] — ROAS X.Xx, $X,XXX revenue
2. [Campaign B] — ROAS X.Xx, $X,XXX revenue
3. [Campaign C] — ROAS X.Xx, $X,XXX revenue

NEEDS ATTENTION
1. [Campaign D] — ROAS below target (X.Xx vs X.Xx target)
   Recommendation: Refresh creative, narrow audience
2. [Campaign E] — Frequency 4.2, CTR declined 30%
   Recommendation: Rotate creative, test new hook

UPCOMING ACTIONS
- [ ] Refresh creative for Campaign D
- [ ] Launch lookalike audience test
- [ ] Increase budget on Campaign A (+20%)

DASHBOARD LINK: [Live dashboard URL]

Automating Report Generation

Option 1: Looker Studio + Email (Free)

• Schedule email delivery of PDF report
• Limited customization

Option 2: Make.com + Google Slides (Low Cost)

• Pull data via Make.com scenario
• Populate Google Slides template with data
• Export as PDF
• Email to client
• Cost: $16/mo (Make.com Pro)

Option 3: Custom Cloud Function + PDF (Medium Cost)

• Firebase Cloud Function generates report data
• Puppeteer renders HTML template to PDF
• Cloud Storage hosts the PDF
• Automated email via SendGrid or Mailgun
• Cost: Firebase usage + email service ($5-20/mo)

Option 4: AgencyAnalytics or Whatagraph (All-in-One)

• Pre-built report templates
• Multi-platform data connections
• Automated scheduling
• White-labeled
• Cost: $75-300/mo depending on client count

Building an Alert System

Dashboards are passive. Alerts are active. You need both.

Critical Alerts (Immediate)

Condition	Alert Channel	Action
Campaign spend > 150% of daily budget	Slack + SMS	Pause campaign
ROAS drops below 1.0 for 2 consecutive days	Slack	Review campaign
Ad account error/rejection	Email + Slack	Fix immediately
Zero conversions for 24+ hours	Slack	Diagnose tracking
CPM spikes >50% vs. 7-day average	Slack	Check auction competition

Warning Alerts (Daily Digest)

Condition	Frequency	Channel
Frequency > 3.0 on any ad	Daily	Email digest
CTR declined >20% week-over-week	Daily	Email digest
Budget pacing >110% or <80%	Daily	Email digest
Landing page load time >3 seconds	Daily	Email digest

Implementation in Firebase

// Simplified alert evaluator (Firestore trigger)
exports.alertEvaluator = functions
  .region('asia-east1')
  .firestore.document('clients/{clientId}/dailyStats/{date}')
  .onCreate(async (snap, context) => {
    const data = snap.data();
    const clientId = context.params.clientId;

    // Check ROAS threshold
    if (data.roas < 1.0) {
      await admin.firestore().collection('alerts').add({
        clientId,
        type: 'roas_below_threshold',
        severity: 'critical',
        message: `ROAS dropped to ${data.roas}`,
        createdAt: admin.firestore.FieldValue.serverTimestamp(),
      });
    }

    // Check budget pacing
    if (data.spend > data.dailyBudget * 1.5) {
      await admin.firestore().collection('alerts').add({
        clientId,
        type: 'budget_overspend',
        severity: 'critical',
        message: `Spend ${data.spend} exceeded budget ${data.dailyBudget} by ${((data.spend / data.dailyBudget - 1) * 100).toFixed(0)}%`,
        createdAt: admin.firestore.FieldValue.serverTimestamp(),
      });
    }
  });

Dashboard Best Practices

For Client-Facing Dashboards

1. Lead with outcomes, not activity. Revenue and ROAS first. Impressions and clicks later.
2. Use plain language. "Return on ad spend" not "ROAS." "Cost per sale" not "CPA." Not every client knows the acronyms.
3. Show context. Numbers without context are meaningless. Always show vs. previous period and vs. target.
4. Include recommendations. Data without insight is just noise. Add "What this means" and "What we're doing about it" sections.
5. Keep it to one page for executives. Detail pages exist for those who want to dig deeper.

For Internal Dashboards

1. Optimize for speed. Media buyers check dashboards 10+ times per day. Sub-2-second load times are mandatory.
2. Enable drill-down. Overview → Platform → Campaign → Ad Set → Ad → Creative
3. Show anomalies prominently. Anomaly detection beats threshold alerts for experienced buyers.
4. Include pacing data. How much of the monthly budget has been spent? Are we on track?

ROI of Automated Reporting

Metric	Before Automation	After Automation
Hours per week on reporting	12-15 hours	1-2 hours
Report accuracy	85-90% (human error)	99%+
Report delivery consistency	70% on-time	100% on-time
Client satisfaction (reporting)	6/10	9/10
Capacity (clients per manager)	5-8	15-25

The math: if you save 10 hours per week at $50/hour effective rate, that is $2,000/month in saved time. A Looker Studio + Supermetrics stack costs $120/month. That is a 16:1 ROI.

Key Takeaways

• Automated reporting dashboards are table stakes for any agency managing more than 3 clients
• Looker Studio + Supermetrics is the best value stack for most agencies ($40-120/month)
• Custom dashboards (Next.js + Firebase) offer white-labeling and real-time data but require development investment
• Pair dashboards with an alert system for proactive anomaly detection
• Schedule weekly PDF reports for executives who will not log into a dashboard
• Lead with outcomes (revenue, ROAS) not vanity metrics (impressions, reach)
• The ROI of automated reporting is typically 10-20x the tool cost within the first month

---

Explore our marketing automation services →