06-15-2004, 08:19 AM
|
|
|
Too lazy to set a custom title
Industry Role:
Join Date: Jul 2001
Posts: 59,204
|
Quote:
Originally posted by swedguy
The stats query for MPA2
select site, ROUND(sum(partner_uniques)*partner_paid),fm from mpa2.stats where date>='2004-06-15' and date<='2004-06-15' and webmaster='xxxxxx' group by site,date,referrer,uniques_paid,uniques_p,signup_p aid,partner_paid,date,webmaster,fm order by site
To me the part that I put in bold is sketchy.
Lets say partner_uniques sums up to 1000 and partner_paid = 0.8
ROUND(1000*0.8) = 800
Now there's 800 uniques instead of 1000.
I could be wrong that it's used like that, but it sure seems possible 
|
Where you found that? |
|
|