Start free
Read & reportRead-only source

See your PromoteKit numbers in Amazon Redshift.

Review PromoteKit affiliate partners, referred customers and Stripe-linked commissions in a read-only data source.

  • Spend, results and return by campaign in one sheet
  • Find the campaigns that cost more than they return
  • A fresh campaign report before your morning check
PromoteKitAmazon RedshiftAmazon Redshift

Start free Connect PromoteKit

Updated November 2026

PromoteKit reportSample data
EmailApprovedClicks
partner@saasweekly.iotrue860
jordan@harbor.example640410
sam@acme.example210155
Refreshes on your schedule in Amazon Redshift

Who uses Datapipe with PromoteKit

Paid media managers

Check spend and return by campaign every morning.

Ecommerce owners

See which ads actually bring orders.

Agencies

Send each client a clear ad report every month, without exporting.

What you can do with PromoteKit

Read and report

Read affiliates, referrals and commissions using your PromoteKit API key.

  • Affiliate partners
  • Referred customers
  • Affiliate commissions

Explore metrics and dimensions

Read-only source

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

Full read details

Partner payouts and referral links are never modified.

Examples for your team

Read & report

Monitor affiliate program commissions

Combine affiliate referral counts, customer signups and commission totals in one report.

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

Before you connect

What you need

An API key or token from your PromoteKit account.

Read-only

Read access only. Datapipe never changes anything in PromoteKit.

Limits and exclusions

Read-only. Payouts and referral links are never changed, and reports include affiliate and customer emails.

Full details and limits

Affiliate partners, referred customers, and earned commissions from PromoteKit.

Read-only reporting access using your PromoteKit API key. Affiliate links and commission payouts are never modified.

Read-only. Payouts and referral links are never changed, and reports include affiliate and customer emails.

Reports you can build

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

What each dataset reports
  • Affiliate partners

    PromoteKit affiliates with email, name, whether they are approved, link clicks and join date.

  • Referred customers

    PromoteKit referred customers with their affiliate, email and subscription status.

  • Affiliate commissions

    PromoteKit commissions with affiliate, commission amount, revenue, currency and payout status.

Metrics and dimensions

19 report fields across 3 datasets.

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

Send PromoteKit 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 top PromoteKit affiliates, referral counts, and commission totals.

Top 5 approved affiliates generated 184 referred customers and $4,320 in earned commissions this quarter.

Better than exporting by hand

Start from a goal

How it works

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

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

  3. Pick where it goes. Choose affiliates, referrals or commissions and a destination.

Sample report

PromoteKit reportSample data
EmailApprovedClicksCommissionCurrencyPayout status
partner@saasweekly.iotrue8601,2401,240Paid
jordan@harbor.example640410640640Pending
sam@acme.example210155210210Refunded

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

Works well with PromoteKit

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 PromoteKit, send the reports to your destinations and ask an AI assistant about them. Datapipe never changes anything in PromoteKit. Read-only reporting access using your PromoteKit API key. Affiliate links and commission payouts are never modified.

This page lists 19 report fields across 3 datasets. You pick the columns when you build the report.

Affiliate partners, referred customers, and earned commissions from PromoteKit. Account permissions and the records available from the provider determine which rows can be read.

One for each PromoteKit 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 PromoteKit with sample data first

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

Start free Add data source