Connectors

/

Freshdesk

/

Unhappy Freshdesk customers with BigCommerce refunds
Report
Cross-Connector

Spot unhappy Freshdesk customers who also got BigCommerce refunds

For support teams who ask their AI assistant which customers with low ratings also had refunded or cancelled orders.

Try PopdockAI free
Get a live demo
Unhappy Freshdesk customers with BigCommerce refunds
Which customers rated Freshdesk support 2 or lower in the last 30 days and also had refunds on BigCommerce orders?
8 customers rated 2 or lower in the last 30 days, and 3 also had refunded BigCommerce orders. - dana@northwindtraders.com: rating 1, ticket #4410 Wrong item sent, refunded 240.00 - sam@contoso.com: rating 2, ticket #4398 Late delivery, refunded 85.50 - No orders found: 2 customers - Ranked by refunded amount, largest first Want the full table of all 8 customers?
Freshdesk
Sample figures. Your results come from your own account.
freshdesk-get-satisfaction-ratings
freshdesk-get-tickets
bigcommerce-get-order

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Freshdesk

Freshdesk
Run it on your own Freshdesk data.

Connect Freshdesk, pick your AI tool and paste the prompt.

Try PopdockAI free

The problem

Unhappy and costly customers never show up together

Low satisfaction scores sit in Freshdesk and refunds sit in BigCommerce, so customers who are both unhappy and costly never show up together. Each team sees half the picture and the expensive complaints go unnoticed.

Without PopdockAI

  • Export low ratings from Freshdesk
  • Find the requester behind each ticket
  • Search BigCommerce for their orders and refunds
  • Add up refunds in a spreadsheet

With PopdockAI

  • Low ratings are read with the ticket and requester behind each
  • BigCommerce orders around that period are checked for refunds
  • Customers with both are named, largest refund first
  • Customers with no orders are listed, 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.

Prompt
**Objective:** List customers who left a satisfaction rating of `{max-rating}` or lower in the last `{lookback-days}` days (defaults 2 and 30) and show whether they had refunds or issues on BigCommerce orders.

**Step 1: Low ratings in Freshdesk**

Call `freshdesk-get-satisfaction-ratings` (Freshdesk server) with `rating.max` set to the maximum and `created-at.from` set to the lookback start. Collect each `ticket-id`.

**Step 2: Resolve the customer**

For each ticket call `freshdesk-get-tickets` with `ticket-id` and take `requester-email`.

**Step 3: Check BigCommerce**

For each distinct email call `bigcommerce-get-order` (BigCommerce server) with `billing-email` set to it and `date-created.from` set to the lookback start extended by 30 days. Note orders where `refunded-amount` is above zero or `status` is a cancelled, refunded or declined state.

**Step 4: Report**

A table: customer email, rating, ticket-id and subject, orders found, total refunded. Then name the customers with both a low rating and a refund, ordered by refunded amount.

**Rules & Guidelines:**

* `freshdesk-get-satisfaction-ratings` and `freshdesk-get-tickets` are on the Freshdesk server; `bigcommerce-get-order` is on the BigCommerce server.
* Do not call any write tool on either server (no freshdesk-add-*, freshdesk-update-*, freshdesk-delete-*, freshdesk-reply-to-ticket, and no bigcommerce-*-add, -update or -delete tools).

**Validation:**

* If no ratings match, say so and stop.
* If an email has no BigCommerce orders, list it as "no orders found" rather than dropping it.

Who it's for

One answer, three teams that use it

Support managers

Find the costliest complaints

Customers with both a low rating and a refund come first, ranked by amount.

Which customers rated Freshdesk 1 this quarter and also had refunded BigCommerce orders?

Ecommerce managers

Link refunds to the support experience

Refunds, cancellations and declines beside low ratings show where service problems are costing sales.

Show low Freshdesk ratings from the last 60 days with refunded or cancelled BigCommerce orders for each customer.

Finance analysts

Quantify refunds tied to unhappy customers

Total refunded per unhappy customer gives you a number to bring to the service review.

How much did we refund in BigCommerce to customers who gave poor Freshdesk ratings last month?

How it works

What PopdockAI does when you ask

You set the highest rating to include and a period, and your AI assistant checks each unhappy customer for refunds. It only reads both systems.

01

Ask

You set the highest rating to include and a lookback window.

Your AI tool

02

Find

It reads the low Freshdesk ratings and the requester behind each ticket.

freshdesk-get-satisfaction-ratings
freshdesk-get-tickets

03

Check

It looks for each customer's BigCommerce orders and notes refunds and cancellations.

bigcommerce-get-order

04

Report

You get a table and the customers with both a low rating and a refund.

Your AI tool

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.

get-data

freshdesk-get-satisfaction-ratings

Returns satisfaction ratings from Freshdesk, with filters on the fields that matter. Read-only.
get-data

freshdesk-get-tickets

Returns tickets from Freshdesk, with filters on the fields that matter. Read-only.
get-data

bigcommerce-get-order

Returns orders from BigCommerce, with filters for the fields that matter on this list. Read-only; needs a BigCommerce connection.
Read only.Nothing in Freshdesk Changes

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.

How Popdock AI secures your data

The outcome

See which unhappy customers also cost you a refund

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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.

Try PopdockAI Free
See Documentation