Keyword Analysis ERROR - No Stats Shown :(

bradman905 · Joined: Oct 9th, 2008 Posts: 8

For the last week now i havent been able to display more then 1 days worth of stats in the keyword analysis section. Therefore i really cant see what is bringing in the dough. Can someone please help with this?

Thanks ahead!

SELECT COUNT(*) AS clicks, AVG(click_cpc) AS avg_cpc, SUM(click_lead) AS leads, SUM(click_lead * click_payout) AS income FROM clicks LEFT JOIN clicks_advance USING (click_id) LEFT JOIN clicks_site USING (click_id) WHERE clicks.user_id='12527' AND click_time > 1243666800 AND click_time < 1246345199 AND keyword_id='22924' GROUP BY keyword_id

Got error 134 from storage engine

T202Aaron · Joined: Sep 9th, 2008 Posts: 985

Try it again to see if it works for you. If it doesn't let me know

bradman905 · Joined: Oct 9th, 2008 Posts: 8

Nope.. Doesn't work. :(

Same problem.

T202Aaron · Joined: Sep 9th, 2008 Posts: 985

How big is your campaign?

bradman905 · Joined: Oct 9th, 2008 Posts: 8

Not big dude.

1444 keywords

About 100$ a day adspend.

dmac · Joined: Mar 14th, 2009 Posts: 8

I have the same problem. Since Sunday, Keywords will only display for "today" and "yesterday". The error message says to contact you if the problem persists. The problem does in fact persist and sent you an email as requested in the error message.

My campaign has fewer than 20 keywords.

I really appreciate the tracking software your have developed and the effort you put into this forum.

I look forward seeing Keyword tracking up and running again soon.

T202Aaron · Joined: Sep 9th, 2008 Posts: 985

Are you using Prosper202 or Tracking202?

bradman905 · Joined: Oct 9th, 2008 Posts: 8

Tracking202 here

T202Aaron · Joined: Sep 9th, 2008 Posts: 985

Do you mind if I take a look at your account

bradman905 · Joined: Oct 9th, 2008 Posts: 8

Please do man!

PM'ed you

T202Aaron · Joined: Sep 9th, 2008 Posts: 985

I took a look at your account and I defiantly see the error. This error happens when you try to take a look at all the data from 7 days to 30 days. When you look at Today and yesterdays stats, it shows up fine. I've shown this error to Wes, so he is going to take a look at your account too. Wes will see if he has a solution to fix the problem. Wes or myself will post back here soon to let you know if we have a solution.

bradman905 · Joined: Oct 9th, 2008 Posts: 8

Thanks so much Aaron, really appreciate it!

Yea, i found i was able to view today, and yesterdays data.

All i really used was the 30 day view so i could print out a conversion report and scale the kws.

Is there any other way to view converted keywords over 30 days?

Greatful for the help guys!

dmac · Joined: Mar 14th, 2009 Posts: 8

HI,

I'm using Prosper 202 Self Hosted.

And yes, you may look at my account.

Thanks for working on this.

T202Aaron · Joined: Sep 9th, 2008 Posts: 985

dmac wrote:

HI,

I'm using Prosper 202 Self Hosted.

And yes, you may look at my account.

Thanks for working on this.

We are doing a big update to Prosper202, so the update should clear up this issue.

dmac · Joined: Mar 14th, 2009 Posts: 8

Things seem to be working now. Thank you so much.

T202Aaron · Joined: Sep 9th, 2008 Posts: 985

ok cool

bradman905 · Joined: Oct 9th, 2008 Posts: 8

Really? Things still arent working for me using Tracking202.

Still getting the same DB error

T202Aaron · Joined: Sep 9th, 2008 Posts: 985

Sorry Bradman905,

Wes is trying to fix the problem for you.

bradman905 · Joined: Oct 9th, 2008 Posts: 8

No worries Aaron,

Thanks for keepin tabs!

T202Aaron · Joined: Sep 9th, 2008 Posts: 985

No problem, take care

bradman · Joined: Jul 14th, 2008 Posts: 2

You guys are fucking studs!!

Thanks for fixin the problem Wez and Aaron!

T202Aaron · Joined: Sep 9th, 2008 Posts: 985

No problem, take care