Datapipe

Email marketing · USE CASE

Build a newsletter-to-website dashboard.

Compare Mailchimp campaign clicks with tagged website sessions in GA4. Keep their scopes separate while building a custom two-source dashboard in Looker Studio.

Data sources
Assistant
Destination
Set up the source report →Source permissions and destination setup apply
Your task, worked throughIllustration · no live reads or changes
Mailchimp + GA4 → ChatGPT
YOU

Build a dashboard for our newsletter and website review.

Choose the Mailchimp campaign and GA4 property. Read campaign statistics and the explicitly tagged website traffic for a defined window.

Keep explicit
Mailchimp campaign metrics · tagged GA4 sessions
Mailchimp campaign metrics · tagged GA4 sessions
1 / 4Read both sources

Illustrated use case. Save the actual report, dashboard and schedule settings in the indicated app.

MAKE THE TASK CONCRETE

Newsletter & website engagement dashboard

  1. 01

    Read both sources

    Choose the Mailchimp campaign and GA4 property. Read campaign statistics and the explicitly tagged website traffic for a defined window.

  2. 02

    Build the dashboard

    Save separate reports and Sheet exports. Build independent source panels in Looker Studio; use validated campaign tags for comparison and avoid an assumed user-level join.

  3. 03

    Review the result

    Compare the campaign and landing-page evidence without treating the gap as proven tracking failure. Recommend the next tagging, content or landing-page check; no campaign is sent or edited.

KNOW WHERE EACH STEP HAPPENS

One use case across the tools you use.

ChatGPT
Read authorized data, agree on the questions and prepare the report, charts or review checklist.
Datapipe
Save source reports, authorize the destination, export the data and review any refresh or email settings.
Google Sheets + Looker Studio
Save a supported prepared copy or build the custom charts described above. Check each source and its freshness settings.

START WITH YOUR ASSISTANT

Give it the task. Follow up with the next step.

Copy these in order into the assistant connected to your Datapipe project.

Read both sources

Read the prompt
Use only the intended Datapipe project. Discover the account, datasets and compatible fields first. Use actual returned dates and filters; preserve empty or missing results and never substitute sample data for a failed read.

Build a Mailchimp + GA4 newsletter dashboard with ChatGPT.
Campaign statistics may be cumulative while GA4 uses selected dates. Validate tags; do not equate clicks with sessions or infer person-level attribution.

Align the scope

Read the prompt
Show whether campaign clicks led to engaged website visits.
Keep cumulative campaign clicks distinct from GA4 sessions for selected dates. Check UTM conventions, consent and attribution limits; clicks are not unique matched visitors.
Prepare the checklist without claiming completion. Save reports, destination authorization, schedules and recipients in Datapipe; build custom native charts in Looker Studio. The AI tools do not perform those setup steps.

Review the result

Read the prompt
What should we improve before the next newsletter?
Compare the campaign and landing-page evidence without treating the gap as proven tracking failure. Recommend the next tagging, content or landing-page check; no campaign is sent or edited.
Campaign statistics may be cumulative while GA4 uses selected dates. Validate tags; do not equate clicks with sessions or infer person-level attribution.
Prepare the checklist without claiming completion. Save reports, destination authorization, schedules and recipients in Datapipe; build custom native charts in Looker Studio. The AI tools do not perform those setup steps.

A FEW USEFUL ANSWERS

Before you start.

Will the dashboard match every click to a website visitor?

No. Platform definitions, cumulative scope, date windows, consent and tagging differ. The custom view compares source panels; it does not promise a user-level attribution join.

Does the assistant complete the setup automatically?

Prepare the checklist without claiming completion. Save reports, destination authorization, schedules and recipients in Datapipe; build custom native charts in Looker Studio. The AI tools do not perform those setup steps.

Does this example read or change my data?

No. The conversation and output are labeled illustrations. Review the actual source account, permissions, fields and destination before doing the task. Campaign statistics may be cumulative while GA4 uses selected dates. Validate tags; do not equate clicks with sessions or infer person-level attribution.

YOUR NEXT STEP

Start with a specific reporting task.

Choose your source in Datapipe and review the setup before saving.

Set up the source report →