Datapipe
Start free

Sales · USE CASE

Bring newsletter clicks into the sales review.

Use Mailchimp to see who clicked the selected campaign link and their current audience status. Add HubSpot contact context to separate a new-lead review from an existing-customer conversation.

Data sources
Assistant
Destination
Try it with your data Free with up to 3 data sources · No credit card
A WORKED EXAMPLE

Who needs a sales or account review after this email?

PersonCRM contextReview
MayaLead · NEWSales
AriCustomerAccount

Selected demo link · Campaign sent Nov 9 · Cumulative clicks and current records Nov 11, 18:00 UTC

Maya needs a new-lead review; Ari belongs with the account team. Keep Robin’s unsubscribed audience record in a separate preference-check group instead of turning every click into a sales task.

WHERE THE RESULT GOES

Google Sheets

Export each data source report to Google Sheets, then add your analysis or checklist to the review Sheet.

Example use case

Ask. Follow up.
Take the next step.

✦ AI assistantSample use case
MailchimpHubSpot
YOU

  1. 01
    Confirmed email match · NorthstarReview with sales

    Next

  2. 02
    Confirmed email match · CedarReview with account team

    Next

Selected demo link · Campaign sent Nov 9 · Cumulative clicks and current records Nov 11, 18:00 UTC

01 · CONNECT YOUR DATA

Your tools. One place to ask.

2 of 3 Free data sources
No credit card · Daily refresh

DatapipeYour project
Your AI assistantor a report in Sheets / Data Studio
  1. Create your free workspace

    Sign up with your company email. Your first project opens on Data sources.

  2. Add the data sources

    Choose the accounts for this use case. Authorize access and select the property or site.

  3. Bring your question

    Connect your project to a supported AI assistant, or build your source reports.

Create a free account →
Setup steps & what you need

Email/password signups confirm their email first. Use Google signup with a company account if you prefer.

  • Mailchimp: Add the intended Mailchimp account using its supported authorization or dedicated account key. Setup guide ↗
  • HubSpot: Add the intended HubSpot account using its supported sign-in or dedicated token setup. Setup guide ↗

Free includes 3 data sources across the workspace. One account/property added to one project counts as one. Extra properties or the same account in another project use another slot.

02 · ASK A USEFUL QUESTION

Start with a prompt.
Follow the evidence.

Copy these in order into your connected assistant.
Each builds on the answer before it.

01

Find the recipients behind a relevant newsletter link

Read the full prompt
Use only this Datapipe project’s authorized data. Discover the connected accounts, datasets and compatible fields first. Confirm dates, timezones, currencies and data coverage. Keep missing or unmatched rows visible; never substitute sample data. Compare the sources explicitly and explain every match. Do not change source records or send messages.

From the connected Mailchimp account, read Campaign link clicks for the sent campaign I choose. Return campaign_links.campaign_id, id, url, total_clicks and unique_clicks. Confirm the actual link URL before selecting its ID. Read link_members with the required campaign_id and url_id selectors, plus email_id, email_address, list_id, contact_status and clicks. Use the exact returned IDs in Dataset details or equality filters on those selected fields. Show the read timestamp and coverage. These are cumulative reported counters for one campaign/link; do not describe them as clicks within the report date range, human-only activity or qualified leads.
02

Add current audience and HubSpot contact context

Read the full prompt
Read Mailchimp audience_members with the selected list_id, id, email_address and status. Match a clicked member by list_id and email_id to the same audience member ID. Then read HubSpot contacts.email, firstname, company, lifecyclestage and hs_lead_status. Confirm the team’s email identity rule and how it interprets the returned CRM values. Keep unmatched, missing and ambiguous identities separate; do not invent a contact ID or infer a match from a company/name alone. Show current audience status and current CRM state with the capture time; neither is historical state at the time of the click.
03

Prepare a review list without turning clicks into a lead score

Read the full prompt
Prepare one row per member for the chosen campaign/link: email, reported clicks, current audience status, verified HubSpot match, raw lifecycle/lead status, suggested sales/account/preference-check review, and missing owner or context. Route subscribed matched contacts for human review according to the team’s CRM definitions. Keep unsubscribed or uncertain records in a separate preference/data-check group. Multiple clicks and security scanners can inflate activity; do not rank purchase intent from the count. Ask the responsible team to review the matched CRM record, communication preferences and any existing conversation before assigning a task. Draft the list in this conversation. Do not send messages, create contacts/tasks, change stages or alter subscription status.
Need to connect your assistant?Claude guide ↗ChatGPT guide ↗

03 · USE WHAT YOU FIND

Prepare the sales and account review list.

  1. 01

    Select the campaign link you want to understand.

  2. 02

    Check audience status and the CRM match.

  3. 03

    Prepare the sales and account review list.

Check the result at your next review.

Record which sales, account or preference/data reviews were completed. Re-read current audience status and the matched CRM properties before the team acts. At the next campaign review, track actual agreed next steps or CRM changes separately from click totals; a later deal does not establish that the newsletter caused it.

Implementation tips for this use case

Mailchimp supplies the selected-link evidence and current audience context; HubSpot supplies the current relationship. Keep one review row per member for the chosen campaign/link and group subscribed matched contacts by the team’s interpretation of CRM stages. Keep unsubscribed, missing-status and uncertain identities in a separate preference or data-check group. The responsible salesperson or account manager reviews communication preferences and the actual CRM record before assigning the next action. Copy the agreed review list to the team’s Sheet.

WHEN YOU NEED MORE CONTEXT

Go a little deeper.

The method and reporting checks
behind this example.

How to review newsletter link activity with current CRM context

  1. Select the campaign link you want to understand.

    Add the intended Mailchimp and HubSpot accounts to one project. Choose a sent campaign, read Campaign link clicks and confirm the actual destination URL before selecting its link ID. Then read Members who clicked a link using that exact campaign ID and link ID. These counters are cumulative as available at read time; a report date filter does not turn them into clicks that happened today.

  2. Check audience status and the CRM match.

    Read the corresponding Mailchimp Audience members with the returned audience ID. Match list_id and the member hash before checking the current status. Read HubSpot contacts separately with email, first name, company, lifecycle stage and lead status. Use an email identity rule your team confirms, retaining aliases, shared addresses, duplicate and unmatched rows for review. HubSpot provides current accessible contact properties, rather than the contact’s stage when the click happened.

  3. Prepare the sales and account review list.

    Mailchimp supplies the selected-link evidence and current audience context; HubSpot supplies the current relationship. Keep one review row per member for the chosen campaign/link and group subscribed matched contacts by the team’s interpretation of CRM stages. Keep unsubscribed, missing-status and uncertain identities in a separate preference or data-check group. The responsible salesperson or account manager reviews communication preferences and the actual CRM record before assigning the next action. Copy the agreed review list to the team’s Sheet.

See the complete example report
EXAMPLE REPORT

Who needs a sales or account review after this email?

Selected demo link · Campaign sent Nov 9 · Cumulative clicks and current records Nov 11, 18:00 UTC

Who needs a sales or account review after this email?
PersonCRM contextReview
MayaLead · NEWSales
AriCustomerAccount
WHAT TO LOOK ATMaya needs a new-lead review; Ari belongs with the account team. Keep Robin’s unsubscribed audience record in a separate preference-check group instead of turning every click into a sales task.

Prepare the sales and account review list.

Mailchimp reports three clicks on the selected demo link and the current audience record is subscribed. The matching HubSpot contact has lifecycle stage lead and lead status NEW. Mailchimp reports eight clicks on the same link and the current audience record is subscribed. HubSpot identifies the matched contact as a customer, with lead status CONNECTED.

Try the example with sample CSVs

Fictional rows matching the example above. Attach these files to your assistant for a sample analysis.

Data method, reporting checks & sources

Add the intended Mailchimp and HubSpot accounts to one project. Choose a sent campaign, read Campaign link clicks and confirm the actual destination URL before selecting its link ID. Then read Members who clicked a link using that exact campaign ID and link ID. These counters are cumulative as available at read time; a report date filter does not turn them into clicks that happened today. Read the corresponding Mailchimp Audience members with the returned audience ID. Match list_id and the member hash before checking the current status. Read HubSpot contacts separately with email, first name, company, lifecycle stage and lead status. Use an email identity rule your team confirms, retaining aliases, shared addresses, duplicate and unmatched rows for review. HubSpot provides current accessible contact properties, rather than the contact’s stage when the click happened. Mailchimp supplies the selected-link evidence and current audience context; HubSpot supplies the current relationship. Keep one review row per member for the chosen campaign/link and group subscribed matched contacts by the team’s interpretation of CRM stages. Keep unsubscribed, missing-status and uncertain identities in a separate preference or data-check group. The responsible salesperson or account manager reviews communication preferences and the actual CRM record before assigning the next action. Copy the agreed review list to the team’s Sheet.

The selected campaign and link URL are confirmed, and cumulative clicks stay separate from current audience and CRM state. A Mailchimp audience/member identity is checked before an agreed email match to HubSpot; unmatched does not mean absent from every CRM record. One clicked member remains one review row. Repeat clicks, multiple links and bot activity do not become extra leads. Current audience status is a review input, rather than a complete record of every channel’s communication preferences.

  • The selected campaign and link URL are confirmed, and cumulative clicks stay separate from current audience and CRM state.
  • A Mailchimp audience/member identity is checked before an agreed email match to HubSpot; unmatched does not mean absent from every CRM record.
  • One clicked member remains one review row. Repeat clicks, multiple links and bot activity do not become extra leads.
  • Current audience status is a review input, rather than a complete record of every channel’s communication preferences.
  • Access to the intended Mailchimp account or property.
  • Access to the intended HubSpot account or property.
  • The selected campaign and link URL are confirmed, and cumulative clicks stay separate from current audience and CRM state.

For blended reports, align dates, normalized URLs, and reporting grain. Query-level search rows must not duplicate page-level sessions.

Mailchimp clicked-link subscribers ↗Mailchimp current audience members ↗Mailchimp bot activity and click reporting ↗HubSpot contact properties and lifecycle stages ↗Report starting points ↗

A FEW USEFUL ANSWERS

Before you start.

Why do I need both Mailchimp and HubSpot?

Mailchimp identifies the recipients reported against the selected link and provides current audience status. HubSpot shows the existing contact relationship. Together they help the team choose a sales, account or preference review rather than assign the same follow-up to everyone.

Does a high click count mean someone wants a sales call?

No. Repeated clicks, link previews and security scanners can create activity. Read the actual link context and current relationship, then have the responsible team decide whether a follow-up is appropriate.

Can I compare these click counts with this week’s CRM changes?

Keep their time meanings explicit. The selected-link report is cumulative as returned, while these CRM fields are current values. A report date range does not supply click-event dates or historical contact stages.

What happens to unsubscribed or unmatched members?

Keep them in a separate preference or data-check group. An unsubscribe is not a reason to create a sales task, and a missing CRM match needs identity/coverage checks. Confirm the relevant communication preferences and record before deciding on any contact.

YOUR NEXT STEP

Try it with your own data.

Start free with up to 3 data sources. No credit card.

Start free →