Skip to content

Campaign Reporting Dashboard

Example prompt: "Every day pull our ad campaign data into a Google Sheet. Every Monday, calculate weekly CPA and ROAS and post a summary to our Slack channel."

How to automate campaign reporting with GloriaMundo

The Problem

Marketing teams running paid campaigns across platforms need to track performance daily, but the data lives in different dashboards with different metrics and different update schedules. Someone has to log into each platform, export the numbers, paste them into a spreadsheet, and calculate the KPIs that actually matter — cost per acquisition, return on ad spend, conversion rates. By the time the weekly summary reaches the team, it is often late, inconsistent, or missing a day's data because someone forgot to pull it. The work is not difficult, but it is tedious enough that it slips.

How GloriaMundo Solves It

We build a two-cadence workflow. Daily, an integration step pulls campaign performance data and appends it to a Google Sheet — impressions, clicks, spend, and conversions for each campaign. Weekly, on Monday mornings, a code step reads the past seven days of data from the sheet, calculates key metrics (CPA, ROAS, click-through rate, week-over-week change), and an LLM step turns those numbers into a readable summary with highlights and callouts for anything unusual. The summary is posted to Slack so the team sees it first thing. Glass Box preview shows you both the raw data pull and the calculated summary before either step writes anything.

Example Workflow Steps

  1. Trigger (scheduled — daily): Runs each evening to capture the day's campaign data.
  2. Step 1 (integration): Pull ad performance metrics (impressions, clicks, spend, conversions) and append them as a new row in the tracking Google Sheet.
  3. Trigger (scheduled — weekly): Runs every Monday morning.
  4. Step 2 (integration): Read the past 7 days of data from the Google Sheet.
  5. Step 3 (code): Calculate weekly KPIs — CPA, ROAS, CTR, and week-over-week percentage changes.
  6. Step 4 (llm): Generate a narrative summary highlighting top-performing campaigns, budget concerns, and any metrics that moved significantly.
  7. Step 5 (integration): Post the formatted weekly summary to a Slack channel.

Integrations Used

  • Google Sheets — serves as the central data store for daily campaign metrics and calculated KPIs
  • Slack — receives the weekly performance summary for the marketing team

Who This Is For

Marketing managers and growth leads who run paid campaigns and need a reliable way to track daily performance without manually pulling data from ad platforms. Especially useful for small teams where the person running campaigns is also the one reporting on them.

Time & Cost Saved

Manually pulling campaign data daily takes about 15-20 minutes. Compiling a weekly summary with calculated KPIs adds another 1-2 hours. Over a month, that is roughly 6-8 hours of data wrangling and reporting replaced. The workflow also eliminates missed days and calculation errors, giving the team confidence that the numbers are always current and correct.