Affiliate Tracker

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.