Raw data only. Partnerize lands as raw warehouse tables, not modeled dashboards or AI analysis. Raw tables are delivered only to organizations on a dedicated warehouse, for the tables picked under Warehouse → Raw data in your SourceMedium workspace. See Foundation and Pro.
Sign in to SourceMedium, open your store, then choose Data sources → Connect data source and select the platform. You need an Admin or Editor workspace role.After you connect explains the first sync and connection statuses.
Vendor documentation
Requirements
- A Partnerize brand user (advertiser) with access to the campaign’s conversion reports. Publisher (partner) keys are not supported: they list no brand campaigns, and the connection refuses them.
- That user’s API keys: the User Application Key and the User API Key. These are API keys, not your console password, and the data they reach follows that user’s access in Partnerize.
- One campaign per store. If your brand runs several campaigns, for example one per region, connect the one this store reports on. The others are not synced.
How to connect
1
Copy your API keys
Sign in to the Partnerize console, open Settings > Account settings, and copy the User Application Key and the User API Key.
2
Find your campaigns
Find Partnerize in the connector picker and click Connect. Enter the Application key and the User API key, then click Find campaigns.
3
Select the campaign
Select the Partnerize campaign to sync, then click Connect Partnerize. Before saving, SourceMedium checks that this user can read the campaign’s conversion report.
4
Confirm it is connected
The connection reads Awaiting first data until the first sync lands, then Connected.
If account lookup is unavailable, SourceMedium saves your credentials securely and shows that account verification is pending. Choose Try again, or reopen the form and choose Use saved credentials, to continue without pasting them again. Use the same SourceMedium login that saved them.Saving credentials does not activate an unverified account selection. If you are replacing a working connection, its existing credential and sync settings stay in use until the replacement is verified.
SourceMedium only ever reads from your connected platforms. It does not create, change, or delete anything, so create the key with read-only access wherever the platform offers it. Treat it like a password: keep it confidential and avoid sharing it over email or in spreadsheets. If the credential is rotated or revoked, follow this guide’s connection method to update SourceMedium.
What data syncs
Conversions carry the conversion-level value, commission, publisher commission, status, and the currency fields as Partnerize returns them, including the original currency and conversion rate. Nothing is converted to USD. Items carry their own value, commission, status, last update, and approval time. Conversion-level amounts live only on conversions and are never repeated per item, so total items and conversions separately. Every row keeps its
campaign_id.
The shopper’s IP address is not imported.
Select the tables you want under Warehouse → Raw data in your SourceMedium workspace to receive them in your_project.sm_sources.
Refresh and history
- Refresh: every six hours. Conversion-level approvals, rejections, and commission changes are picked up by the date Partnerize last modified the conversion, with one day of overlap.
- Item changes: each sync also re-reads the last 90 days of conversions by conversion time, which picks up item-level approvals, rejections, and commission changes.
- History: the first sync loads 365 days of conversions by conversion time. Reports are requested in UTC.
Known gaps
- Item changes after 90 days. An item approved, rejected, or re-priced more than 90 days after its conversion keeps its earlier state.
- One campaign per store. Other campaigns on the same Partnerize account are not synced.
Troubleshooting
- “These Partnerize keys list no brand campaigns”? The keys belong to a publisher, or to a user without a brand campaign. Use the keys of a brand user.
- The connection says the user lacks reporting rights, or can no longer see the campaign? The keys work, but the user’s access in Partnerize does not cover the campaign. Ask your Partnerize admin to give this user access to the campaign’s conversion reports. Reconnecting with the same keys does not help.

