TV202 Prosper202 Tracking202 Export202 WorldProxy202 Meetup202 | Blog Forum Newsletter Twitter | Advertise
Login · Register
Home About Docs Scripts Blog Forums Hosting Donate Download
Before Posting, Have You Read the FAQ? And Have You Searched? If Not Please Do!

GetAds Double Commission

Post new topic Reply to topic Prosper202 Forum Index » Stats202 Support
New Posts Search Forum
Author Message
Jake
Skype AIM


Joined: May 14th, 2008
Posts: 63

Post Posted: Oct 27th, 2009 at 12:38pm Post subject: GetAds Double Commission Reply with quote

Is anyone else getting double the commission on Getads? Meaning - I get 1 conversion and the payout is $15, but it shows up as $30 in p202.

This only happens some of the time.

Thanks!

Jake

ps. I have the correct payout entered into p202. :)

Back to top
bumblebee
Skype AIM


Joined: May 21st, 2009
Posts: 20

Post Posted: Nov 9th, 2009 at 9:56pm Post subject: Re: GetAds Double Commission Reply with quote

It happens to me too. I notice that it only happens with Networks using the Linktrust platform - http://www.linktrust.com/, such as Epicenter, Advertise.

Stats202 does capture the number of leads correctly. But the income is doubled. For example, if I have 1 lead at $5.85, the income is $11.70. Basically it exaggerates the ROI.

Back to top
bumblebee
Skype AIM


Joined: May 21st, 2009
Posts: 20

Post Posted: Nov 9th, 2009 at 10:11pm Post subject: Re: GetAds Double Commission Reply with quote

I have had a closer look at this. I think it is actually a Tracking202 script problem rather than Stats202. In Tracking202, "income" is a value calculated from "number of leads" x "payout". So, an example MySQL statement is:

$click_sql = "SELECT COUNT(*) AS clicks, SUM(click_out) AS click_throughs, AVG(click_cpc) AS avg_cpc, SUM(click_lead) AS leads, SUM(click_lead * click_payout) AS income FROM 202_clicks LEFT JOIN 202_clicks_record USING (click_id) LEFT JOIN 202_clicks_advance USING (click_id) LEFT JOIN 202_clicks_site USING (click_id) ";

$click_sql_add = " $click_filtered AND landing_page_id='".$mysql['landing_page_id']."' GROUP BY landing_page_id";

So, I haven't investigated in depth, but I think the problem is that sometimes the SQL statements fail in calculating SUM(click_lead * click_payout), due to some particular conditions.

I am suggesting the above so that the programmers can have a look sometime.

Back to top
bumblebee
Skype AIM


Joined: May 21st, 2009
Posts: 20

Post Posted: Nov 9th, 2009 at 10:28pm Post subject: Re: GetAds Double Commission Reply with quote

Further investigation tells me that it may be a Stats202 problem after all, at least in conjunction with the Linktrust system.

Stats202 is pulling in subids that are not conversions. That may somehow cause the SQL statements to breakdown (with all the JOINs that are in them).

So, I think to solve the problem, the programmers have to figure out whether it is Stats202 or Linktrust system that is causing Stats202 to have all the non-conversions subids.

Back to top
bumblebee
Skype AIM


Joined: May 21st, 2009
Posts: 20

Post Posted: Nov 9th, 2009 at 10:33pm Post subject: Re: GetAds Double Commission Reply with quote

About Subids that are pulled into Stats202, if it's from a Linktrust system, the "actions" are duplicated or even triplicated for some converted subids. This is the problem.

I don't know how to solve it though.

Back to top
T202Aaron
Website Twitter AIM


Joined: Sep 9th, 2008
Posts: 985

Post Posted: Dec 21st, 2009 at 3:46pm Post subject: Re: GetAds Double Commission Reply with quote

I'll bring this issue up with our coders.

Back to top
Post new topic Reply to topic Page 1 of 1

Creative Commons License This work (Prosper202, Tracking202 and Export202) is licensed under a
Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.