Analytics & Reporting

What Gets Tracked

For every affiliate link on the platform, three metrics are tracked:

• Clicks — How many times the link was visited (someone from the creator's audience clicked it)
• Conversions — How many completed actions resulted (sign-ups, account openings, applications)
• Earnings — Commission earned from those conversions

→ DB: All three are stored per-link, per-provider, per-day in affiliate_analytics (affiliateLinkId, providerId, date, clicks, conversions, earnings)

How Data Gets In

The platform does not track clicks in real-time. Instead, a background job (called a "cron") runs every day at 2am UTC and pulls the latest data from each affiliate network's reporting API. That data is then stored in the platform's database. → DB: Cron writes to affiliate_analytics (affiliateLinkId, providerId, date, clicks, conversions, earnings)

This means analytics data is typically 1 day behind — what you see today reflects activity through yesterday.

Each affiliate network reports data differently:

• Impact — Reports by creator slug on their Actions API → DB: Matched via AffiliateLink.slug
• PartnerStack — Reports via their click report endpoint, matched by creator slug → DB: Matched via AffiliateLink.slug
• Money.com / RedVentures — Reports via their API, matched by creator's tracking sub-ID
• Bankrate / QuinnStreet — Similar sub-ID matching

Creator View

Dashboard (30-day summary) Creators see a summary of the past 30 days on their main dashboard:

• Total clicks
• Total conversions
• Total earnings
• A small trend chart

→ DB: Reads from affiliate_analytics filtered by userId and date range (last 30 days)

Analytics Page (365-day detail) Clicking into Analytics shows the full picture:

• Data going back up to 365 days
• Broken down by day
• Separated by individual link

→ DB: Reads from affiliate_analytics joined to AffiliateLink for the selected time range

Admin View

Links section The admin Links page shows aggregate stats for all creators — organized by creator, then by link. Useful for a quick overview of who's active and who's driving results. → DB: Reads from affiliate_analytics joined to AffiliateLink

Crons section If data for a specific date is missing or wrong, admins can manually trigger a sync for that date. The page shows a live log as the sync runs, so you can see which providers are being pulled and whether any errors occur.

Earnings & Creator Rate

The earnings figure shown to creators reflects their share after the agency's cut. The platform applies a rate multiplier to display the creator's portion of the commission. The raw numbers in the database are the full commission amounts; what creators see is their calculated share. → DB: affiliate_analytics.earnings stores the gross commission. Displayed creator value = earnings × 0.8 (applied display-only, not stored separately).

Data Freshness

If a creator reports that their stats look wrong or outdated:

1. Check the Crons page to confirm the last analytics run completed successfully
2. If needed, manually trigger a sync for the affected date(s) from the admin Crons page
3. Allow a few minutes for the sync to complete, then have the creator refresh their page