Start free
Read & reportRead-only source

See your ReferralCandy numbers in Amazon Redshift.

Review ReferralCandy referrals, order totals, reward payouts and top advocates in a read-only data source.

  • Orders, products and stock in a sheet that refreshes itself
  • Sales and refunds over time without exporting from ReferralCandy
  • Ask ChatGPT or Claude about live ReferralCandy numbers in a normal sentence
ReferralCandyAmazon RedshiftAmazon Redshift

Start free Connect ReferralCandy

Updated November 2026

ReferralCandy reportSample data
Advocate emailReferred emailReferred at
alex@example.comjo@example.com2026-11-10
640640640
210210210
Refreshes on your schedule in Amazon Redshift

Who uses Datapipe with ReferralCandy

Store owners

See yesterday's orders, sales and refunds every morning.

Merchandisers

Catch low stock and messy product data before customers do.

Agencies

Report store results next to ad spend for each client.

What you can do with ReferralCandy

Read and report

Read referrals and advocates using your signed ReferralCandy API Access ID and Secret Key.

  • Referrals
  • Advocates

Explore metrics and dimensions

Read-only source

Datapipe reads ReferralCandy data for reports. It never changes anything in ReferralCandy.

Full read details

No campaign rules or reward payouts are modified.

Examples for your team

Read & report

Track referral revenue and advocate rewards

Combine completed referral orders, reward amounts and top-performing advocates in one ecommerce report.

  1. Scheduled refresh
  2. Latest ReferralCandy data
  3. Updated report

Before you connect

What you need

An API key or token from your ReferralCandy account.

Read-only

Read access only. Datapipe never changes anything in ReferralCandy.

Limits and exclusions

Read-only. Campaign rules and rewards are never changed, order totals and reward amounts are not included, and reports include customer emails.

Full details and limits

Completed and pending referrals, enrolled advocates, and reward totals from your ReferralCandy account.

Read-only reporting access using your ReferralCandy Access ID and Secret Key. Campaigns and reward payouts are never modified.

Read-only. Campaign rules and rewards are never changed, order totals and reward amounts are not included, and reports include customer emails.

Reports you can build

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

What each dataset reports
  • Referrals

    Referrals made in the report period with the referring and referred emails, campaign and whether the review period is over.

  • Advocates

    Advocates and other contacts with whether they have purchased, how many purchases, and whether they unsubscribed.

Metrics and dimensions

13 report fields across 2 datasets.

Hover or tap a field to see what it means. Custom fields from your own account appear after you connect.

Send ReferralCandy data anywhere

Ask AI about your data

Claude or ChatGPT can read the same numbers. You ask in a normal sentence, and the answer stays with your report.

Summarize completed ReferralCandy referrals, reward payouts, and top advocates.

Completed referrals generated $18,400 in order revenue with $1,840 in advocate rewards, led by alex@example.com.

Better than exporting by hand

Start from a goal

How it works

  1. Create a project and choose ReferralCandy in Data sources.

  2. Pick where it goes. This one sends the numbers to Amazon Redshift.

  3. Pick where it goes. Choose referrals or advocates and a destination.

Sample report

ReferralCandy reportSample data

Sample range Oct 1–Oct 29. Each row is one campaign.

Advocate emailReferred emailCampaign IDReferred atEmailPurchasedPurchasesUnsubscribed
alex@example.comjo@example.com20412026-11-10avery@northwind.example18181,240
640640Retargeting640jordan@harbor.example3232640
210210Brand search210sam@acme.example66210

Sample numbers, so you can see the shape. Your report uses your accounts.

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

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.

No. Name a project, add a data source, then choose a report and destination.

OAuth means you sign in with the service and grant access, without pasting an API key. Datapipe works with multiple partners to provide that sign-in. Some partners already provide it. Some integrations are API-only at present, so you paste a key or token. OAuth is coming soon for some. Some partners do not provide OAuth at all. The setup steps on each integration page say how that source connects. Signing in is only how the connection is made. It is not permission to change records. Where a source supports changes, those writes stay off until the workspace owner turns specific actions on and approves each one. We do not promise OAuth on every source, and we do not share dates.

This integration is read-only in Datapipe. You can report on ReferralCandy, send the reports to your destinations and ask an AI assistant about them. Datapipe never changes anything in ReferralCandy. Read-only reporting access using your ReferralCandy Access ID and Secret Key. Campaigns and reward payouts are never modified.

This page lists 13 report fields across 2 datasets. You pick the columns when you build the report.

Completed and pending referrals, enrolled advocates, and reward totals from your ReferralCandy account. Account permissions and the records available from the provider determine which rows can be read.

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.

Yes. The same numbers can go to a sheet, a chart, a warehouse, or an assistant.

Try ReferralCandy with sample data first

Build the report first, then add ReferralCandy when you are ready.

Start free Add data source