Every Monday morning, the email team at a large enterprise builds a PowerPoint. Open rates, click rates, top-performing subject lines — the same slides, every week, manually assembled and emailed to a distribution list of business stakeholders who will glance at it, file it, and ask the same questions in the next meeting anyway.

This is the reporting loop most Marketing Cloud teams are stuck in. Stakeholders need performance visibility. Marketing Cloud has all the data. But the platform isn’t built for non-technical business users, and nobody wants to buy another analytics tool license.

The solution we built replaces the manual Monday email with a fully automated weekly digest and a self-service analytics Cloud Page — where every link opens a live dashboard for that specific email, populated in real time from Marketing Cloud data. No login. No PowerPoint. No manual work.

Marketing Cloud has all the data. The gap is giving non-technical stakeholders a frictionless way to access it — without a platform login or a weekly manually-built report.

How the System Works

The architecture is a two-layer system. Layer one is the weekly digest email — the entry point that lands in every stakeholder’s inbox automatically. Layer two is the dynamic Cloud Page dashboard — one page that serves analytics for any email, parameterised by Job ID.

Layer 1: The Weekly Digest Email

A Marketing Cloud automation runs every Monday morning. It queries a pre-aggregated summary Data Extension for all sends from the previous 7 days and generates a digest email listing each campaign with a clickable “View Analytics” link.

The key detail: each link passes the Job ID as a URL query parameter — ?jobid=12345678. This is what makes the single Cloud Page serve analytics for any email without needing separate pages per send.

%%[
  SET @rows     = LookupRows("WeeklySendSummary", "WeekOf", @weekStart)
  SET @rowCount = RowCount(@rows)

  FOR @i = 1 TO @rowCount DO
    SET @row       = Row(@rows, @i)
    SET @emailName = Field(@row, "EmailName")
    SET @jobID     = Field(@row, "JobID")
    SET @sendDate  = Field(@row, "SendDate")
    SET @openRate  = Field(@row, "OpenRate")
]%%
  <div class="email-row">
    <strong>%%=v(@emailName)=%%</strong> · %%=v(@sendDate)=%%
    · Open Rate: %%=v(@openRate)=%%%
    <a href="https://[cloudpage-url]?jobid=%%=v(@jobID)=%%">
      View Full Analytics →
    </a>
  </div>
%%[ NEXT @i ]%%

Layer 2: The Dynamic Cloud Page Dashboard

The Cloud Page is a single page that reads the jobid URL parameter on load. Using that Job ID, AMPscript queries the pre-aggregated performance Data Extension and populates all the dashboard metrics dynamically. Change the Job ID in the URL, and the entire dashboard updates for that email.

%%[
  SET @jobID      = RequestParameter("jobid")
  SET @metrics    = LookupRows("EmailPerformanceSummary",
                               "JobID", @jobID)
  SET @row        = Row(@metrics, 1)

  SET @emailName  = Field(@row, "EmailName")
  SET @totalSends = Field(@row, "TotalSends")
  SET @openRate   = Field(@row, "OpenRate")
  SET @clickRate  = Field(@row, "ClickRate")
  SET @bounceRate = Field(@row, "BounceRate")
]%%

<h1>%%=v(@emailName)=%%</h1>
<div class="kpi-grid">
  <div class="kpi"><span>Total Sends</span><strong>%%=v(@totalSends)=%%</strong></div>
  <div class="kpi"><span>Open Rate</span><strong>%%=v(@openRate)=%%%</strong></div>
  <div class="kpi"><span>Click Rate</span><strong>%%=v(@clickRate)=%%%</strong></div>
</div>

Visualisation: Chart.js for Graphs

AMPscript outputs data; it doesn’t render charts. For the visual elements — bar charts, click rate breakdowns, device splits — we load Chart.js via CDN and inject the AMPscript-populated values as JavaScript variables. AMPscript runs server-side; Chart.js renders client-side. Clean separation.

<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>
<canvas id="performanceChart"></canvas>

<script>
  new Chart(document.getElementById('performanceChart'), {
    type: 'bar',
    data: {
      labels: ['Open Rate', 'Click Rate', 'Bounce Rate'],
      datasets: [{
        label: 'Performance %',
        data: [
          %%=v(@openRate)=%%,   /* injected by AMPscript */
          %%=v(@clickRate)=%%,
          %%=v(@bounceRate)=%%
        ],
        backgroundColor: ['#0ea5e9', '#0a2a66', '#f97316']
      }]
    }
  });
</script>

One Cloud Page serves analytics for every email. The Job ID in the URL is the only thing that changes — the dashboard populates itself automatically.

The Pre-Aggregated Data Extension

Cloud Pages have execution time limits. Running complex Data View joins on page load for large send volumes would be too slow. The solution is to pre-aggregate all metrics nightly via SQL automation into a summary DE.

A nightly automation queries _Sent, _Open, _Click, and _Bounce Data Views, calculates rates per Job ID, and writes the results to an EmailPerformanceSummary DE. The Cloud Page reads from this DE — a simple lookup, not a complex real-time join. Page loads stay fast regardless of send volume.

Frequently Asked Questions