SquidSupport
Product reference / Reports

NPS report

In the app: Reports → NPS

Needs the 'View Reports' permission.

Shows your Net Promoter Score: how likely customers say they are to recommend the store, from 0 to 10, measured with a survey that is sent some time after an order. It is about the store as a whole, not about one support conversation; for that, see the "CSAT" tab. Whether and when the survey is sent is set under Settings → NPS.

Period, store and trend steps

  • Period: two date fields for the first and last day, both included, or "30d", "90d" and "1y". The page opens on the last 30 days. The end date cannot be after today.
  • Store filter: appears when you have more than one store. It can include or exclude several stores. With no store chosen, the page shows the whole organization.
  • Trend steps: "Daily", "Weekly" or "Monthly" sets the size of the steps in "NPS over time".
  • "Refresh" reloads everything.

Days start and end in the organization's "Report timezone" from Settings → Organization; the line "Times shown in …" names it. Test sends and test answers are never counted. A teammate whose access is limited to certain stores only sees those stores' answers.

Net Promoter Score

Customers answer on a scale from 0 to 10. A 9 or 10 is a promoter, a 7 or 8 a passive, and 0 to 6 a detractor.

The score is the percentage of promoters minus the percentage of detractors, over all answers. Passives count in the total but in neither group. The score therefore runs from −100 to +100 and is not a percentage: +42 means there are 42 points more promoters than detractors.

  • The card counts the answers submitted in the period, whenever the survey was sent.
  • The bar under the score shows the number of promoters, passives and detractors.
  • A score needs enough answers. Below 30 answers, or the number set for the store, the card shows "Not enough responses yet — 12 of 30" instead of a score. With so few answers, one more answer moves the score by several points, so Squid does not publish it anywhere: not on this card, not in the chart and not in the export. The counts are still shown. With several stores included, the strictest of their minimums applies. An exclusion filter also keeps the default minimum of 30 in consideration.
  • For the whole organization the score is worked out again from every answer. It is not the average of the store scores, so a small store does not weigh as much as a large one.

Response rate

How many of the surveys sent in the period were answered, whenever the answer came in.

  • "Of surveys delivered": answers divided by surveys that were sent and did not bounce. Squid gets no delivery receipt, so "delivered" means "not reported as bounced".
  • "Of surveys sent": answers divided by all surveys sent.

Neither rate leaves out people who unsubscribed. This card counts answers by the period their invitation was sent in, while the score card counts answers by the day they were submitted, so the two cards do not show the same number of answers.

NPS over time

The score per day, week or month, by when the answers were submitted. A step with fewer answers than the minimum is left out and drawn as a gap, not as a point. The line at zero marks where promoters and detractors are equal. When too many steps are gaps, choose a longer period or larger steps.

Comment themes

What customers wrote about. Each comment is read by an AI model, which sorts it into a fixed list of themes and marks it positive, neutral or negative.

  • Each theme shows its share of the comments that have been read, with the split between positive, neutral and negative.
  • A comment can have up to three themes, so the shares can add up to more than 100%.
  • Themes are an interpretation, not a count. Use a large theme as a place to look, then read the comments.
  • Click a theme to filter the "Responses" list to it; "Clear theme filter" undoes it. The theme filter only applies to the answers on the page you are on.
  • Comments that have not been read yet are mentioned as still waiting.

Contacted support

Compares the score of customers who had opened a conversation with the store before they answered the survey ("Had contacted support") with the score of those who had not ("Had not contacted support"). A customer counts as having contacted support when a ticket exists for the same email address and the same store that was created at any time up to the moment of the answer. Tickets with another of your stores, tickets opened after the answer, and deleted, merged or example tickets do not count when this is established. Squid normally records this at the time of the answer and keeps that result; older answers without a recorded result are checked against the conversations still on record. When both groups have a score, a sentence below the two cards states the difference in points.

Each half needs the minimum number of answers of its own before it gets a score, so this comparison takes about twice as long to fill as the main score. Answers from customers who can no longer be identified, usually because their data was erased, are in neither half.

A difference here does not show that contacting support changed how customers feel. Customers who contact support often had a problem with their order to begin with.

By store

Shown when no store filter is set. One row per store that received an answer in the period: "Store", "NPS", "Responses", "Promoters", "Passives" and "Detractors". Each store has its own minimum, so one store can show a score while another shows "12 of 30". The rows do not average to the organization score.

Responses

Every answer behind the numbers, newest first. Each row shows the score and whether it is a promoter, passive or detractor, the customer's email address ("Recipient erased" when their data was erased), the store when no store filter is set, the comment and its themes, and whether the customer had contacted support. Expand a row to read the exact question that version of the survey asked and the customer's answers to the follow-up questions.

Filters above the list:

  • Band: "All bands", "Promoters (9–10)", "Passives (7–8)" or "Detractors (0–6)".
  • Support: "Everyone", "Contacted support" or "Did not contact support".
  • "Only with a comment": hides answers without a written comment.

The times in the list are in your own timezone.

Export CSV

Needs the 'Export Reports' permission.

"Export CSV" downloads the answers in the period and store filter: Submitted At, Brand, Order, Recipient Email, Locale, Score, Category, Comment, Themes, Contacted Support, Survey Version, Question and Follow-up Answers.

One file holds at most 5,000 answers, the newest first. With more than that, the older answers are left out, and neither the file nor the page says so. A file with exactly 5,000 rows is most likely incomplete: choose a shorter period and export again.

The file contains customers' email addresses and their own words, so it needs the 'Export Reports' permission on top of 'View Reports'. Without it the button is disabled and says why.