Datapipe
Start free

Email marketing · USE CASE

See what happens after the newsletter click.

Read Mailchimp link clicks, GA4 campaign behavior and Shopify product availability to decide what to investigate before the next send.

MailchimpGoogle AnalyticsShopify
Try it with your data Free with up to 3 data sources · No credit card
A WORKED EXAMPLE

Which email links get clicks but few purchases?

Email linkUnique link clicksGA4 purchases
Desk organizer3202
Everyday tote21013

Sent Nov 1 · Read Nov 8, 00:00 UTC · Current stock

Investigate the organizer link before repeating the promotion. The tote provides a useful comparison with more purchase events and more stock.

EXAMPLE WORKFLOW

Ask. Follow up.
Take the next step.

✦ AI assistantSample workflow
MailchimpGoogle AnalyticsShopify
YOU

  1. 01
    Mailchimp campaign + GA4 UTM match + ShopifyReview first

    Next

  2. 02
    Same sent campaign · Matched product pageCompare the journey

    Next

Sent Nov 1 · Read Nov 8, 00:00 UTC · Current stock1 / 3

01 · CONNECT YOUR DATA

Your tools. One place to ask.

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

MailchimpGoogle AnalyticsShopify
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 workflow. 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 ↗
  • Google Analytics: Authorize Google Analytics and select the GA4 property for the same website. Setup guide ↗
  • Shopify: Enter your shop, authorize it, and add that store to the project. 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

Read the sent email’s product links

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.

Read Mailchimp Campaign link clicks for the sent campaign I select. Return campaign ID, destination URL, total clicks, unique clicks and read timestamp. Retain UTM parameters for matching. Explain the cumulative reporting window and automated-click caveat; do not sum unique clicks across links as unique people.
02

Follow up across your data sources

Read the full prompt
Use only this Datapipe project’s authorized data sources. Discover the connected accounts, datasets, and fields first. If the right account or required data is missing, ask me rather than substituting sample data. Show the actual dates, filters, coverage, and any partial results.

Check current stock before we repeat the newsletter. What should change in the plan? Read the actual current records behind the shortlist. Show which source supports each observation, distinguish causes from hypotheses, and propose one specific next step.
03

Use the result

Read the full prompt
Prepare the next-send checklist. Use the actual returned evidence and retain source dates, attribution and grain. Prepare a concise, usable result in this conversation with owners or unanswered checks where needed.
Need to connect your assistant?Claude guide ↗ChatGPT guide ↗

03 · USE WHAT YOU FIND

Check the promoted products in Shopify.

  1. 01

    Choose one sent campaign and capture its links.

  2. 02

    Match tagged traffic to GA4.

  3. 03

    Check the promoted products in Shopify.

Check the result at your next review.

Use consistent campaign tagging on the next send, inspect GA4 purchase tracking, and review product availability before launch. Compare like-for-like campaign windows without claiming causal attribution.

Implementation tips for this use case

Match product URLs to current handles and inventory. Investigate stock, variants and the page experience where the journey needs attention. A current stock snapshot does not establish the cause of historical campaign performance.

WHEN YOU NEED MORE CONTEXT

Go a little deeper.

The method and reporting checks
behind this example.

How to review the journey from email click to product page

  1. Choose one sent campaign and capture its links.

    Read Mailchimp Campaign link clicks for an explicit campaign ID. Retain each destination URL and cumulative unique/total clicks at the read timestamp. Unique counts are not additive across links and can include automated activity.

  2. Match tagged traffic to GA4.

    Confirm the UTM campaign, source/medium and landing page. Query compatible GA4 session and purchase-event reports for the send-to-review window. Validate tracking and attribution scope before comparing results.

  3. Check the promoted products in Shopify.

    Match product URLs to current handles and inventory. Investigate stock, variants and the page experience where the journey needs attention. A current stock snapshot does not establish the cause of historical campaign performance.

See the complete example report
EXAMPLE REPORTFictional sample data

Which email links get clicks but few purchases?

Sent Nov 1 · Read Nov 8, 00:00 UTC · Current stock

Which email links get clicks but few purchases? · fictional sample data
Email linkUnique link clicksGA4 purchases
Desk organizer3202
Everyday tote21013
WHAT TO LOOK ATInvestigate the organizer link before repeating the promotion. The tote provides a useful comparison with more purchase events and more stock.

Check the promoted products in Shopify.

Illustrative report output · no live query or source change

Mailchimp reports 320 unique clicks on this link. The matched GA4 campaign/landing-page view has 260 sessions and 2 purchase events. Shopify currently shows 3 product units. The link has 210 unique Mailchimp clicks. GA4 records 180 sessions and 13 purchase events for the matched campaign/page, while current product inventory is 80.

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

Read Mailchimp Campaign link clicks for an explicit campaign ID. Retain each destination URL and cumulative unique/total clicks at the read timestamp. Unique counts are not additive across links and can include automated activity. Confirm the UTM campaign, source/medium and landing page. Query compatible GA4 session and purchase-event reports for the send-to-review window. Validate tracking and attribution scope before comparing results. Match product URLs to current handles and inventory. Investigate stock, variants and the page experience where the journey needs attention. A current stock snapshot does not establish the cause of historical campaign performance.

The sent campaign ID and cumulative read timestamp are explicit. UTM campaign and landing-page matches are verified. GA4 purchase events are not presented as all Shopify orders.

  • The sent campaign ID and cumulative read timestamp are explicit.
  • UTM campaign and landing-page matches are verified.
  • GA4 purchase events are not presented as all Shopify orders.
  • Access to the intended Mailchimp account or property.
  • Access to the intended Google Analytics account or property.
  • Access to the intended Shopify account or property.
  • The sent campaign ID and cumulative read timestamp are explicit.

For blended reports, align dates, normalized URLs, and reporting grain. Query-level search rows must not duplicate page-level sessions. This is an illustrative workflow; live accounts and destinations need their own setup.

Mailchimp Google Analytics tracking ↗Google Analytics campaign and traffic-source scopes ↗Shopify inventory states ↗Report starting points ↗

A FEW USEFUL ANSWERS

Before you start.

Why do Mailchimp clicks and GA4 sessions differ?

They are different measures with different tracking and reporting rules. Automated clicks, repeat visits, consent, tagging and session definitions can all affect the comparison.

Can this show every Shopify order caused by an email?

Not from these totals alone. GA4 attribution and order-level matching need their own validated identifiers and scope. This workflow prepares a product and tracking investigation.

YOUR NEXT STEP

Try it with your own data.

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

Start free →