uplift.page
← library
skill🤝 CRM & salesv2 · updated 2026-10-09

HubSpot newsletter dashboard

Builds a newsletter performance dashboard from HubSpot marketing email data — opens, clicks and delivered per send, by publication, week over week, against your own averages, with every chart also shown as a table. Use when a marketer wants a weekly newsletter report without building HubSpot reports, or to recreate the marketing dashboard from the HubSpot demo.

Run it as a prompt

Paste this into any AI agent, or fetch it: curl -s https://uplift.page/api/v1/prompts/hubspot-newsletter-dashboard/raw

prompt.md
# HubSpot newsletter dashboard

Build a weekly newsletter dashboard from HubSpot's marketing email statistics, through the HubSpot connector. It is meant for someone who doesn't code: one file, open it, read it.

## When to use

- "How did this week's newsletters do?"
- Recreating the marketing dashboard's Newsletter and Trends tabs from the HubSpot demo

## Steps

1. Ask which emails count as newsletters (name prefix, campaign or subscription type) and the weeks to cover; default to the last 12 weeks.
2. Pull each sent marketing email: name, send date, delivered, opens, clicks, unsubscribes; group by publication.
3. Compute open rate and click rate per send and per week, each publication's own 12-week average, and week-over-week change. Totals and averages must match the rows they come from.
4. Show: this week's tiles with change vs last week; a per-send table sorted by date with sends under their publication's average marked; a weekly trend chart of open and click rate; a table view under every chart.
5. Add a short notes box for what changed this week, in plain words.
6. Save one self-contained HTML file: inline CSS and JS, no outside requests, readable on a phone, with "As of" and the source on every card.

## Rules

- Read only: never create, update, log or delete anything in HubSpot.
- Use only what HubSpot holds. If a card has no data, leave it out; never guess a name, amount, date or quote.
- Quote people exactly and briefly. Plain words, one line per item, no filler.

Install it as a skill

Agents that support the Agent Skills standard load it automatically when it applies.

download
curl -fsSL https://uplift.page/p/hubspot-newsletter-dashboard/SKILL.md --create-dirs -o .agents/skills/hubspot-newsletter-dashboard/SKILL.md
or from any MCP client
MCP server: https://uplift.page/mcp
Tool: pull_skill  {"slug": "hubspot-newsletter-dashboard"}

The full skill

Build a weekly newsletter dashboard from HubSpot's marketing email statistics, through the HubSpot connector. It is meant for someone who doesn't code: one file, open it, read it.

When to use

  • "How did this week's newsletters do?"
  • Recreating the marketing dashboard's Newsletter and Trends tabs from the HubSpot demo

Steps

  1. Ask which emails count as newsletters (name prefix, campaign or subscription type) and the weeks to cover; default to the last 12 weeks.
  2. Pull each sent marketing email: name, send date, delivered, opens, clicks, unsubscribes; group by publication.
  3. Compute open rate and click rate per send and per week, each publication's own 12-week average, and week-over-week change. Totals and averages must match the rows they come from.
  4. Show: this week's tiles with change vs last week; a per-send table sorted by date with sends under their publication's average marked; a weekly trend chart of open and click rate; a table view under every chart.
  5. Add a short notes box for what changed this week, in plain words.
  6. Save one self-contained HTML file: inline CSS and JS, no outside requests, readable on a phone, with "As of" and the source on every card.

Rules

  • Read only: never create, update, log or delete anything in HubSpot.
  • Use only what HubSpot holds. If a card has no data, leave it out; never guess a name, amount, date or quote.
  • Quote people exactly and briefly. Plain words, one line per item, no filler.

Served from the uplift.page library and refreshed within 5 minutes of every update.