/
/
Find unhappy Freshdesk customers still in Drip campaigns
For support and marketing teams who ask their AI assistant which customers with poor ratings are still being emailed.
On this page
Connector
Connect Freshdesk, pick your AI tool and paste the prompt.
The problem
Promotions keep landing on unhappy customers
A customer who just gave a poor Freshdesk rating can keep receiving Drip promotions, because the two tools are never cross checked. The next promotion lands on someone already unhappy.
Without PopdockAI
- Export recent low ratings from Freshdesk
- Look up each customer's email
- Search Drip for active campaigns
- Send the promotion anyway
With PopdockAI
- Recent low ratings are read with each customer's email
- Active Drip campaigns and lead score are found per email
- Repeat raters appear once with the lowest score
- A count of customers needing a pause closes the report, 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:** List customers who rated support `{max-rating}` or lower (default 2) in the last `{lookback-days}` days (default 30) and show which Drip campaigns they are still in, using Drip account `{drip-account}`.
**Step 1: Find poor ratings**
Call `freshdesk-get-satisfaction-ratings` (Freshdesk) with `rating.max` set to `{max-rating}` and `created-at.from` set to the start of the lookback window. Keep `user-id`, `ticket-id`, `rating` and `feedback`.
**Step 2: Get their emails**
For each distinct `user-id`, call `freshdesk-get-contacts` (Freshdesk) with `contact-id` set to it and take the `email`. Skip people with no email.
**Step 3: Check Drip**
For each email call `drip-get-campaign-subscriber` (Drip) with `email` and `company` set to `{drip-account}`. Keep rows whose `campaign-status` is active. People with no rows are not in Drip; list them separately.
**Step 4: Report**
A table of customer, email, rating, feedback, ticket, and active campaigns with `lead-score`. Sort by lowest rating, then by number of active campaigns. End with the count of customers who need a marketing pause.
**Rules & Guidelines:**
* Freshdesk tools (freshdesk-*) read the help desk; Drip tools (drip-*) read the email marketing account. Both servers must be connected.
* Read-only: never call any Freshdesk action (`freshdesk-add-ticket`, `freshdesk-update-ticket`, `freshdesk-add-ticket-note`, `freshdesk-reply-to-ticket`, `freshdesk-update-contact`, `freshdesk-delete-contact`) or any Drip action (`drip-add-subscriber`, `drip-update-subscriber`, `drip-add-subscriber-tag`, `drip-remove-subscriber-tag`, `drip-unsubscribe-subscriber`, `drip-add-subscriber-to-campaign`, `drip-remove-subscriber-from-campaign`, `drip-remove-subscriber-from-all-campaigns`).
* Match people on email address, case-insensitive. Do not guess matches on name alone.
**Validation:**
* If no ratings match, say so and stop.
* Deduplicate customers with several ratings and show the lowest.Who it's for
One answer, three teams that use it
Support managers
Protect customers you are still helping
A table of unhappy customers in active campaigns gives you a list to pass to marketing.
Which customers who rated Freshdesk 1 in the last 14 days are still in active Drip campaigns for our Fabrikam account?
Lifecycle marketers
Know who needs a marketing pause
A count and names of customers needing a pause tell you exactly who to hold back.
How many recent low Freshdesk raters are still active in Drip campaigns? Use the Contoso Drip account.
Customer success managers
Spot high value unhappy customers
Lead score next to each low rating shows which unhappy customers matter most to recover.
Show unhappy Freshdesk customers from the last 60 days with their Drip lead score and active campaigns.
How it works
What PopdockAI does when you ask
You set the lowest rating, a period and your Drip account, and your AI assistant checks each unhappy customer in Drip. It matches by email, never by name.
01
Ask
You set the lowest rating, a lookback window and your Drip account.
02
Find
It reads the low Freshdesk ratings and the customers' emails.
03
Check
It looks up each email in Drip for active campaigns and lead score.
04
Report
You get one table, people not in Drip listed apart and a count needing a pause.
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-satisfaction-ratings
freshdesk-get-contacts
drip-get-campaign-subscriber
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
Pause promotions before they annoy anyone
Related use cases
More ways to put this data to work
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
Freshdesk contacts missing from Drip
Ask your AI to compare recent Freshdesk contacts with Drip and it lists who is missing, matched on email, with unsubscribed people shown as opt-outs, not gaps.
Learn More
Freshdesk escalations still receiving Drip campaigns
Ask your AI which requesters of open urgent Freshdesk tickets are still in active Drip campaigns. It lists them with their campaigns and changes nothing.
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
Check unhappy Freshdesk customers on Constant Contact lists
Ask your AI which customers gave low Freshdesk ratings and are still on Constant Contact lists. It flags who can still receive marketing. Nothing is changed.
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.