Referrals incrementally
The object that grows resumes on last updated rather than rereading.
Rewardful
Polytomic connects Rewardful to your data warehouse, databases, and SaaS tools for affiliate program ETL. Replicate affiliates, referrals, commissions, and payouts into your data warehouse and other systems so affiliate performance can be measured against real revenue, without writing code.
Commissions and payouts
What was earned and what was actually paid, tracked separately.
Links and coupons
Affiliate links and coupons, so you can trace how a referral arrived.
Example workflows
Replicate Rewardful affiliates and referrals into your data warehouse
What you can sync
Rewardful is supported as a source. Read affiliate program data, then land it in your data warehouse, databases, or SaaS tools.
From Rewardful
Affiliates, affiliate links, and affiliate coupons
Referrals, synced incrementally
Commissions and payouts
Campaigns
To your destinations
Data warehouses including Snowflake, BigQuery, and Databricks
Databases including PostgreSQL and MySQL
Cloud storage including Amazon S3 and Google Cloud Storage
SaaS tools including Salesforce, HubSpot, and spreadsheets
How it works
Connect Rewardful and Polytomic reads your affiliate program into your data warehouse: affiliates with their links and coupons, the referrals they produced, the commissions those referrals earned, the payouts made, and the campaigns behind them.
Commissions and payouts being separate objects matters for reconciliation, since what an affiliate has earned and what has actually been paid to them are different questions your finance team will ask separately.
- Connect Rewardful with an API secret
- Read affiliates, affiliate links, and affiliate coupons
- Read referrals incrementally on their last updated time
- Read commissions and payouts for financial reconciliation
- Read campaigns to segment program performance
- Monitor sync health, record volume, and failures from one interface
How to set up
Authentication uses your Rewardful API secret. Once connected and tested, the affiliate, referral, commission, payout, and campaign objects appear for selection.
How to get connected
- 1In Rewardful, obtain your API secret
- 2In Polytomic, navigate to Connections, then Add Connection, then Rewardful
- 3Enter the API secret
- 4Test the connection
- 5Select affiliates, referrals, commissions, payouts, and campaigns
- 6Choose a destination, set a schedule, and click Save
See the documentation for full setup details.
Frequently asked questions
Why teams choose Polytomic
No engineering required
Set up and manage syncs without writing code.
Flexible data modeling
Use SQL to define exactly what data gets synced.
Handles scale automatically
Supports large datasets with incremental syncs and bulk APIs.
Start syncing your data with Rewardful in minutes
No credit card required. Free trial available.