FirstPromoter
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.
Connect FirstPromoter to PostHog to sync your data into the PostHog data warehouse for analysis and modeling.
Import promoters, referrals, commissions, payouts and promo codes from your FirstPromoter affiliate program.
Find your API key and account ID in FirstPromoter under Settings > Integrations > Manage API keys.
Configuration
| Option | Type | Required |
|---|---|---|
API key | password | Yes |
Account ID | text | Yes |
Linking FirstPromoter to PostHog
- Go to the Data pipeline page in PostHog
- Click New source and select FirstPromoter
- Fill in the required configuration fields
- Click Next, select the tables you want to sync, and then press Import
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
commissions | Commissions earned by promoters, including sale amount, payout status and fraud checks. | Incremental, Full refresh | created_at | — |
payouts | Payouts owed to or already paid to promoters, grouped by payout period. | Full refresh | — | — |
promo_codes | Promo/coupon codes attached to promoter campaigns. | Full refresh | — | — |
promoter_campaigns | A promoter's participation in one campaign, with its referral link, coupon and stats. | Full refresh | — | — |
promoters | Affiliates and referral partners, with their profile, campaign stats and balances. | Full refresh | — | — |
referrals | Leads and customers referred by promoters, with their state and attribution. | Full refresh | — | — |