Referrals incrementally
The object that grows resumes from a date rather than rereading.
UpPromote
Polytomic connects UpPromote to your data warehouse, databases, and SaaS tools for affiliate program ETL. Replicate affiliates and referrals into your data warehouse and other systems so your Shopify affiliate program can be measured against real customer value, without writing code.
Sales, commission, refunds
Order attribution with commission earned and refunds against it.
Affiliate detail
Links, coupons, custom fields, and payment settings per affiliate.
Example workflows
Replicate UpPromote affiliates and referrals into your data warehouse
What you can sync
UpPromote is supported as a source. Read affiliate program data, then land it in your data warehouse, databases, or SaaS tools.
From UpPromote
Affiliates with identity, contact, and social details
Program, link, and coupon data per affiliate
Referrals with order and customer attribution
Sales, commissions, refunds, and tracking type
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 and spreadsheets
How it works
Connect UpPromote and Polytomic reads two objects into your data warehouse: your affiliates, with their links, coupons, custom fields, and payment settings, and the referrals they generated with order and customer attribution.
Referrals carry refunds alongside sales and commission, which matters more than it sounds. An affiliate programme judged on gross referred sales looks very different once returns are netted off, and in ecommerce that gap is often large.
- Connect UpPromote with an API key
- Read affiliates with links, coupons, and custom fields
- Read referrals with order and customer attribution
- Get sales, commission, refunds, and tracking type per referral
- Referrals sync incrementally from a date checkpoint
- Monitor sync health, record volume, and failures from one interface
How to set up
Authentication is an API key used as a bearer token. Once connected and tested, the affiliate and referral objects appear for selection and can be pointed at any destination.
How to get connected
- 1In UpPromote, obtain your API key
- 2In Polytomic, navigate to Connections, then Add Connection, then UpPromote
- 3Paste the key
- 4Test the connection
- 5Select affiliates and referrals
- 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 UpPromote in minutes
No credit card required. Free trial available.