cumulative history of purchases by referrals



I am looking for a query for a report that will give me the number of each
specific product model which have been purchased by any and all referrals of
an affiliate.

I have among other fields, fields in my affiliates table for affiliate number,
affiliate name, referred by, referral number, referral name, purchased model,
purchase date.

Each affiliate can make multiple referrals and typically referrals will only
buy one product although they could buy more than one.

The idea is that the commission owed to an affiliate will increase depending
on which level they have reached in sales purchased of any particular product
made by their referrals. Thanks

.



Relevant Pages

  • RE: cumulative history of purchases by referrals
    ... Customers table with the Affiliate ID. ... purchase date. ... Each affiliate can make multiple referrals and typically referrals will only ...
    (microsoft.public.access.queries)
  • 4shared Affiliate Program
    ... member of 4shared affiliate program and start earning money by ... Joining the Affiliate Program ... You will get 20% of each purchase, ... subscription types allow recurring payments to automatically extend ...
    (sci.econ)
  • Re: Referral Link
    ... them so often while learning ASP. ... >> coding' the QueryString returns the value of the id or the name of the ... The whole process of tracking referrals is quite unreliable for ... >> If you are operating an affiliate program with money involved and you are ...
    (microsoft.public.frontpage.programming)
  • Re: [PHP] Affiliate system
    ... I am reviewing an affiliate system that I created a while ago. ... At purchase, we check if that cookie still is there, if so, we register ... What should I do if they do not allow cookies? ... Maybe I can also create a SESSION that stores the affiliate information so ...
    (php.general)
  • RE: [PHP] Affiliate system
    ... read the information I first check if cookie exist and if it doesn't I ... I am reviewing an affiliate system that I created a while ago. ... At purchase, we check if that cookie still is there, if so, we register ...
    (php.general)