Start free

ReferralCandy connector · Referral program reports

Read & reportRead-only source

See what your ReferralCandy advocates bring in.

Bring ReferralCandy referrals and advocates into your reports and AI assistants, with order totals, rewards and the revenue each advocate generated.

  • Rank advocates by revenue generated
  • Track referred order totals and rewards
  • Ask ChatGPT or Claude which advocates to thank
ReferralCandySheetsSheetsData StudioData StudioChatGPTChatGPTClaudeClaude

Start free Explore the data

Updated November 2026

ReferralCandy reportSample data
AdvocateReferralsRevenue generated
maya@example.com8$612.00
sam@example.com5$388.50
leo@example.com2$140.00
Refreshes on your schedule in Google Sheets

ReferralCandy reporting for one store

One ReferralCandy store is the data source.

Referrals

Read each referral’s advocate, referred email, status, currency, order total and reward amount.

Advocates

See each advocate’s name, email, referral link, enrolment date, referrals and revenue generated.

Rewards

Compare reward amounts with the orders they came from.

Currencies

Each referral keeps its own currency.

Report datasets and details

Reports you can build

2 reporting datasets, each with its own fields. Pick one in the app, then choose your columns.

  • Referrals
  • Advocates
What each dataset reports
  • Referrals

    Completed and pending referrals tracked in ReferralCandy with advocate, referred customer, reward status, and order revenue.

  • Advocates

    Enrolled ReferralCandy advocates with referral link, total referrals, and revenue generated.

Metrics and dimensions

16 report fields across 2 datasets.

Search the available fields. Hover or tap a field to see what it means.

Send ReferralCandy data anywhere

Connect ReferralCandy to ChatGPT or Claude for referral questions

Use Datapipe’s MCP access as your ReferralCandy AI integration. Ask which advocates drive the most sales.

Example

Which advocates generated the most revenue this quarter, and what rewards did they earn?

Rank advocates by revenue generated and total the rewards on their referrals.

Start with ReferralCandy

What you need

Your ReferralCandy API access ID and secret key.

What to know

Read-only. Campaign rules and rewards aren’t changed. Reports include customer emails.

How it works

  1. Create your free account, then choose ReferralCandy in Data sources.

  2. Paste your ReferralCandy API access ID and secret key. Add Shopify if you want all orders beside referrals.

  3. Choose a report and destination: a sheet, Data Studio, ChatGPT or Claude.

Works well with ReferralCandy

Add both to the same project. Each keeps its own report, so you can check them side by side or ask ChatGPT or Claude a question that needs both.

Questions

Datapipe reads referrals with order totals and rewards, and advocates with their referral link, referrals and revenue generated.

No. ReferralCandy is read-only in Datapipe.

Yes. Referrals and advocates include emails, so choose who can see the report.

Yes. Add Shopify to the same project and report on both together.

Free to start. Paid plans add more data sources and refresh faster.

Free and Starter refresh once a day. Pro refreshes every hour. Agency refreshes every 15 minutes on the first 50 data sources.

One for each ReferralCandy account you add to a project. Adding the same account to another project counts again. Reports and destinations do not use extra data sources.

See what word of mouth is worth.

Start free, add ReferralCandy and bring your referral data into the tools you already use.

Start free See setup requirements