In your current affiliate tracking system, the issue arises with how commissions are calculated for Parent Affiliates based on their Tier 2 sub-affiliates' activity. Specifically, the commission structure is currently based on the campaign tied to the affiliate's subscription rather than the original campaign the Parent Affiliate signed them up under. Here’s a clear breakdown of the problem and the desired solution: Current Situation: Parent Affiliate Dan is signed up under "Subscription Price A" with Campaign A, earning 50% on Tier 1 and 10% on Tier 2 commissions. Dan recruits Affiliate Brian, who signs up under Subscription Price B, linked to Campaign B, where earnings are 45% on Tier 1 and 5% on Tier 2 commissions. When Brian signs up Tom (Dan's sub-affiliate), Dan earns a 5% commission on Tier 2 based on Brian’s subscription campaign (Campaign B). Problem: The current system ties Dan’s Tier 2 commissions for Tom to Campaign B, which only offers Dan a 5% commission. However, since Dan originally recruited Brian under Campaign A (where the Tier 2 commission rate is 10%), Dan should ideally earn 10% on Tier 2 commissions from Tom’s signup, not just 5%. Desired Solution: The Tier 2 commission earned by the Parent Affiliate (Dan) should be based on the campaign the affiliate (Brian) was recruited under, rather than the campaign the affiliate (Brian) is in. In this case, Dan should be earning a 10% commission on Tom’s signup, based on the 10% Tier 2 rate from Campaign A. By adjusting the tracking system to reflect this structure, Parent Affiliates will earn more consistent and fair commissions based on the original campaign they used to recruit their sub-affiliates. Notes: Due to the subscriptions each user is signed up on, the campaign they are eligible to earn on changes. Therefore, the users earn different commission structures.