/
/
Know a customer's value and support effort from one profile
For support agents who want Freshdesk tickets and Shopify spend, orders and refunds for one email, just by asking their AI assistant.
On this page
Connector
Connect Freshdesk, pick your AI tool and paste the prompt.
The problem
Big spenders and high effort customers look the same
Knowing whether a customer is valuable or high effort means checking Freshdesk for tickets and Shopify for orders and refunds, then merging both in your head. A big spender with many tickets looks no different from a small one.
Without PopdockAI
- Search Freshdesk for tickets and ratings
- Look up the Shopify customer, orders and refunds
- Line up dates across both by hand
- Treat every customer the same
With PopdockAI
- Tickets and ratings are read from Freshdesk
- Spend, orders and refunds are read from Shopify
- One timeline interleaves orders, refunds and tickets
- A short read weighs value against effort, with nothing changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Build a combined support and purchasing profile for the customer with email `{email}`, covering the last `{lookback-days}` days (default 180).
**Step 1: Freshdesk side**
Call `freshdesk-get-contacts` with `email` set to `{email}`. Note `contact-id`, `company-id` and `csat-rating`. Then call `freshdesk-get-tickets` with `requester-email` set to `{email}` and `created-at.from` at the lookback date. Call `freshdesk-get-satisfaction-ratings` with `user-id` set to the `contact-id` if a contact was found.
**Step 2: Shopify side**
Call `shopify-get-customer` with `email` set to `{email}`. If found, call `shopify-get-order` with its `customer-id` and `created-at.from` at the lookback date, and `shopify-get-refund` with the same `customer-id`.
**Step 3: Report**
Give: identity (name, phone, tags from each system), Shopify totals (`total-spent`, `orders-count`, refunds count and `total-adjustments`), ticket totals (open versus closed, priorities, average rating), and a timeline interleaving orders, refunds and tickets by date. Finish with two sentences on the relationship: is this a valuable customer having problems, or a low-spend high-effort one.
**Rules & Guidelines:**
* `freshdesk-get-contacts`, `freshdesk-get-tickets` and `freshdesk-get-satisfaction-ratings` are on the Freshdesk server; `shopify-get-customer`, `shopify-get-order` and `shopify-get-refund` are on the Shopify server.
* Read-only. Do not call `freshdesk-add-contact`, `freshdesk-update-contact`, `shopify-add-customer` or `shopify-update-customer`.
**Validation:**
* If the email exists in only one system, say so plainly and report that side only.
* If names differ between the systems, show both and do not pick one.Who it's for
One answer, three teams that use it
Support agents
Know how much the customer spends
Total spent and order count sit beside the ticket list, so you can set priority and tone with confidence.
How much has ruth@contoso.com spent in Shopify, and how many Freshdesk tickets has she opened?
Ecommerce managers
Find valuable customers having problems
A two sentence read flags high spenders with support trouble before they stop ordering.
Is jay@fabrikam.com a valuable Shopify customer having problems, or a low spend high effort one?
Customer service leads
Decide on goodwill with the facts
Refunds and tickets on one dated timeline help you decide what a fair gesture looks like.
Show me the Shopify refunds and Freshdesk tickets for sam@northwindtraders.com in date order.
How it works
What PopdockAI does when you ask
You give an email and a period, and your AI assistant joins the support and order history into one profile. If the email is in only one system it says so.
01
Ask
You give a customer email and how many days to look back.
02
Support
It reads the Freshdesk contact, tickets and satisfaction ratings.
03
Orders
It finds the Shopify customer and reads orders and refunds.
04
Profile
It gives totals, a dated timeline and a read on value against effort.
What PopdockAI provides
The tools behind the answer
Ready made tools for Freshdesk and one secure connection to your AI tool. No code, no exports.
freshdesk-get-contacts
freshdesk-get-tickets
freshdesk-get-satisfaction-ratings
shopify-get-customer
shopify-get-order
shopify-get-refund
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
Judge value and effort from one profile
Related use cases
More ways to put this data to work
Freshdesk support load for top Shopify customers
Ask your AI to rank top Shopify customers by spend and show each one's Freshdesk tickets, open and escalated. Matched on email, read-only.
Learn More
Summarize a Freshdesk customer account
Ask your AI to summarize a Freshdesk company: contacts, tickets, time spent, satisfaction and renewal risk signals in one read-only account view.
Learn More
Find unhappy Freshdesk customers in Granola meetings
Ask your AI which customers gave low Freshdesk ratings and what came up in their Granola meetings. It flags anyone with no recent contact. Read-only.
Learn More
Freshdesk and Constant Contact customer profile
Ask your AI about a customer email and it joins Freshdesk tickets and ratings to Constant Contact lists and email activity in one read-only profile.
Learn More
Freshdesk and Drip customer view by email
Ask your AI about an email address and it joins Freshdesk tickets and ratings to the Drip subscriber, tags and campaigns, flagging tension between them.
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.