Prompt Almanac

Create beginner Works with: Any AI

HubSpot Weekly Marketing Report From Exports

Structured brief Has example

Summarise performance with calculations.

Open in ChatGPTOpen in Claude

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

Rate this prompt

Loading ratings…

Write a weekly marketing report from HubSpot exports. Metrics: [METRICS]. Last week's figures: [LAST_WEEK]. Campaigns running: [CAMPAIGNS]. Audience: [AUDIENCE].

Let the first three lines carry the message: what moved, why we think so, and what we do next. Present a table with this week, last week, change and percent change, with each division shown (48 leads against 40 last week is +8, or +20 percent), and conversion rates as contacts reaching a stage divided by contacts in the earlier stage. Cover top performing content, underperforming items, leads generated and sales-qualified, and actions for next week. Identify one campaign to scale and one to fix or stop, using the figures provided.

Separate facts from interpretation (label interpretation as a hypothesis), do not claim causes, flag any metric whose definition changed, and list data caveats such as a tracking change. Keep the language plain, highlight one decision needed, and give a three-line version for a chat.

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

See an example result (fictional data)
Invented week. New contacts 48 (last week 40, +20 percent). Marketing qualified 11 (9). Meetings booked 4 (3). Email click rate 3.1 percent (2.8). Best content: pricing guide, 22 downloads. Weakest: webinar page, 9 registrations from 400 visits (2.3 percent).
Summary: 'Leads are up 20 percent, mostly from the pricing guide. The webinar page converts poorly; we will shorten the form. Decision: none.' Hypothesis label: guide promotion on social caused the rise; test by repeating the post next week. Check: 48 new contacts less 40 last week is +8, or 20 percent. Keep the report under 200 words and send it on Monday morning.

Illustrative only, made-up data. Your results will differ and must be reviewed.

Related prompts