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!

Attn: The 202 Support Forum will now be revised
Within the next few weeks the Tracking202 Support Forum will be revised. Some threads will be shut down or reorganized. New rules will be put in place to accommodate those who need help. The 202 team wants to make the forum a more user friendly place for new and old affiliates. We want to make this forum a place for affiliates to help each other be successful.

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: 52

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: 9

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: 9

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: 9

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: 9

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
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.