/
/
Get an honest read on a HubSpot email campaign
For marketers who want unique open and click rates, top links and drop reasons for one email, by asking their AI assistant.
On this page
Connector
Connect HubSpot, pick your AI tool and paste the prompt.
The problem
The summary screen hides how an email really performed
A marketing email's real performance is buried in recipient events: sends, deliveries, opens, clicks, bounces and drops. Working out unique rates, top links and why messages were dropped takes more than the summary screen shows.
Without PopdockAI
- Export recipient events for the campaign
- Deduplicate opens and clicks by recipient
- Group bounces and drops by reason
- Work out rates in a spreadsheet
With PopdockAI
- The campaign's recipient events are read
- Each recipient is counted once per event type
- Bounces and drops are grouped by reason, with top links and geography
- Privacy inflated opens are noted, and nothing is changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Measure how the marketing email campaign `{campaign}` performed over the last `{lookback-days}` days (default 30).
**Step 1: Find the campaign's events**
Call `hubspot-get-email-event` with `campaign.contains` = `{campaign}` and `created.from` set to the window start. If the events span more than one `email-campaign-id`, list the campaigns with their subjects and event counts and stop so the user can pick.
**Step 2: Count by event type**
Count distinct recipients for each `type` (SENT, DELIVERED, OPEN, CLICK, BOUNCE, DROPPED, SPAMREPORT, UNSUBSCRIBED and so on).
* Delivery rate = delivered / sent
* Open rate = unique openers / delivered
* Click rate = unique clickers / delivered
* Click-to-open = unique clickers / unique openers
**Step 3: Detail**
* Top 10 clicked `url` values with unique clickers.
* Bounces and drops grouped by `drop-reason`.
* Opens by `location-country` (top 5) and `browser-name` (top 5).
**Step 4: Report**
Subject, campaign, a metrics table, the detail tables, and the recipients who reported spam or unsubscribed.
**Rules & Guidelines:**
* This prompt is read-only. Do NOT call any write tool: `hubspot-add-contact`, `hubspot-add-company`, `hubspot-add-deal`, `hubspot-add-ticket`, `hubspot-update-contact`, `hubspot-update-company`, `hubspot-update-deal`, `hubspot-update-ticket`, `hubspot-add-contact-note`, `hubspot-add-company-note`, `hubspot-add-deal-note`, `hubspot-add-ticket-note`.
* Count each recipient once per event type; repeated opens are not extra openers.
* Say plainly that opens are inflated by mail privacy proxies.
**Validation:**
* If no events match, say so and suggest checking the campaign name.
* If events hit `max-records`, say the rates are based on a sample.Who it's for
One answer, three teams that use it
Email marketers
Report real open and click rates
Get unique rates and click to open rate with the privacy caveat, not inflated totals.
How did our November newsletter perform in HubSpot? Give me unique open and click rates.
Content marketers
See which links people clicked
Find the top clicked links so the next email leads with what readers want.
What were the top clicked links in the Contoso product launch email in HubSpot?
Marketing operations
Find out why messages failed
Bounces and drops are grouped by reason, with the people who reported spam or unsubscribed.
Why were messages dropped or bounced on our September webinar email, and who unsubscribed?
How it works
What PopdockAI does when you ask
You name a campaign and your AI assistant counts its recipient events properly. You get rates, links and failures, and nothing is changed.
01
Ask
You name the campaign and a lookback period.
02
Read
It reads the campaign's recipient events.
03
Count
It counts each recipient once per event type and groups bounces and drops by reason.
04
Report
You get rates, top links, geography and unsubscribes, changing nothing.
What PopdockAI provides
The tools behind the answer
Ready made tools for HubSpot and one secure connection to your AI tool. No code, no exports.
hubspot-get-email-event
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
An honest read on every email you send
Related use cases
More ways to put this data to work
Add a new HubSpot contact
Ask your AI to add a contact to HubSpot and it checks the email for duplicates, matches the company by name and domain, and saves only after you confirm.
Learn More
Add HubSpot list members to a Constant Contact list
Ask your AI to add HubSpot list members to a Constant Contact list and it finds who is missing, excludes anyone opted out, and adds people only after you confirm.
Learn More
Add HubSpot list members to a Mailchimp audience
Ask your AI to add HubSpot list members to a Mailchimp audience and it skips opt-outs and existing members, then adds the rest as pending after you confirm.
Learn More
Check a HubSpot contact's email consent
Ask your AI whether a HubSpot contact can receive marketing email and it checks subscriptions, lists and delivery history for a verdict with dated evidence.
Learn More
Check a HubSpot list's coverage in Drip
Ask your AI to check a HubSpot list against Drip and it groups members as active, unsubscribed, not in Drip or no email, with counts for each.
Learn More
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.