/
/
See whether Constant Contact clicks turned into Shopify orders
For email marketers who want to know if a Constant Contact campaign drove Shopify sales, by asking their AI assistant.
On this page
Connector
Connect Shopify, pick your AI tool and paste the prompt.
The problem
You cannot tell whether a campaign click became a sale
A Constant Contact campaign promotes a sale, and you want to know whether clickers bought in Shopify. Matching click dates to orders by email, skipping canceled orders and not counting repeat clickers twice is fiddly spreadsheet work.
Without PopdockAI
- Export campaign clicks from Constant Contact
- Export Shopify orders for the same weeks
- Match emails and dates by hand in a spreadsheet
- Double count repeat clickers or include canceled orders
With PopdockAI
- Clicks are grouped by email with each first click date
- Shopify orders placed after that click are matched in your window
- Voided and canceled orders are left out and none counted twice
- Results are labelled as correlation, 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:** For the Constant Contact campaign `{campaign-id}`, find the people who clicked it and the Shopify orders they placed within `{attribution-days}` days (default 7) of their first click.
**Step 1: Confirm the campaign**
Call `constant-contact-get-campaign` with `campaign-id` set to `{campaign-id}`. If nothing comes back, stop and say the campaign was not found. Note its name, last-sent-date, sends, opens and clicks.
**Step 2: Collect the clickers**
Call `constant-contact-get-campaign-click` with `campaign-id` set to `{campaign-id}` and `max-records` 500. Group by email address (lower-case, trimmed) and keep each person's earliest click date and the links they clicked. If 500 rows come back, say the results may be incomplete.
**Step 3: Find their orders in Shopify**
For each clicker, call `shopify-get-order` with `email` set to their address, `created-at.from` set to their first click date and `created-at.to` set to `{attribution-days}` days after it. Keep orders whose financial-status is not voided and that are not cancelled (cancelled-at blank).
**Step 4: Report**
* Header: campaign name, last-sent-date, sends, clicks, unique clickers.
* Totals: clickers who ordered, number of orders, sum of total-price by currency, and the share of clickers who ordered.
* Table: email, first click date, order-number, order date, total-price, financial-status.
* Add one line saying this is click-then-order correlation within the window, not proven causation.
**Rules & Guidelines:**
* `constant-contact-get-campaign` and `constant-contact-get-campaign-click` are on the constant-contact server. `shopify-get-order` is on the shopify server.
* Do not count an order twice when a person clicked more than once.
* This prompt is read-only. Do NOT call `constant-contact-resend-campaign-to-non-openers`, `constant-contact-update-campaign`, `shopify-update-order` or any other tool whose name starts with shopify-add-, shopify-update-, constant-contact-add-, constant-contact-update- or constant-contact-resend-.
**Validation:**
* If the campaign has no clicks, say so and stop.
* If no clicker placed an order in the window, report zero attributed orders rather than widening the window.
* Never add amounts in different currencies together.Who it's for
One answer, three teams that use it
Email marketers
Know which sends led to orders
See orders, revenue and the share of clickers who bought for a campaign, measured the same way every time.
How many people who clicked our Black Friday preview in Constant Contact ordered in Shopify within five days?
Marketing managers
Report campaign revenue you can defend
Revenue is shown per currency and labelled as correlation, so the number in your report is honest about what it means.
Give me revenue per currency from Shopify orders that followed clicks on the Spring Collection campaign in Constant Contact.
Ecommerce managers
Judge whether a promotion paid off
Compare the buyers a promotion email drew in with the effort behind it, without asking anyone for a spreadsheet.
Did the Free Shipping Weekend email in Constant Contact actually bring in Shopify orders? Use a seven day window.
How it works
What PopdockAI does when you ask
You name the campaign, and your AI assistant matches each clicker to the Shopify orders they placed afterwards. It only reads both systems and reports zero rather than widening the window.
01
Ask
You give the campaign and optionally a window, seven days by default.
02
Collect
It groups clicks by email with each person's first click date.
03
Match
It finds Shopify orders placed after that click, leaving out canceled ones.
04
Report
You get orders, revenue per currency and the share of clickers who bought.
What PopdockAI provides
The tools behind the answer
Ready made tools for Shopify and one secure connection to your AI tool. No code, no exports.
constant-contact-get-campaign
constant-contact-get-campaign-click
shopify-get-order
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
A consistent answer on what each campaign drove
Related use cases
More ways to put this data to work
Add missing Shopify customers to a Constant Contact list
Ask your AI to add missing Shopify customers to Constant Contact and it finds opted-in buyers not already there, skips anyone who unsubscribed and adds them after you confirm.
Learn More
Log Shopify refunds as Constant Contact notes
Ask your AI to log Shopify refunds in Constant Contact and it matches each refund to a contact, skips ones already noted and adds notes after you confirm.
Learn More
Check top Shopify customers' reach in Constant Contact
Ask your AI to check your top Shopify customers in Constant Contact and it sorts them into missing, unsubscribed, quiet or engaged, with the spend in each group.
Learn More
Add missing Shopify customers to a Mailchimp audience
Ask your AI to add missing Shopify customers to Mailchimp and it checks each against the audience and unsubscribe history, then adds the rest after you confirm.
Learn More
Add missing Shopify customers to Drip
Ask your AI to add missing Shopify customers to Drip and it finds opted-in buyers Drip does not have, adds them with your tag after you confirm and checks each one.
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.