This affiliate tracking doc was born out of the need for a structured brand ambassador program for a CPG product. Spinning up a dedicated afiliate/influencer-oriented software subscription wasn't yet justifiable, and the program needed flexibility.
This doc provides the following:
- Affiliate application form/table with Accept/Deny function.
- New affiliate onboarding.
- Affiliate table that tracks status, rank, total sales, discounts, and commissions.
- Codes table to generate and track discount and affiliate codes along with their associated discount and commission parameters.
- Orders table to track actual sales made utilizing discount and affiliate codes.
- Commission Payout table to track payments made to affiliates and outstanding commissions owed.