Prosper202 1.6 Beta Now Available (I need your feedback)
- Thread starter WesMahler
- Start date
Any plans to make a some kind of archive tool that we can port all our P202 data into before clearing the tables?
A way to easily access old campaigns for reference, kws, etc would be great. Would be like P202 but you can't run traffic through it, just sits on the desktop and lets you quickly view old data.
I know you can export the mysql tables but thats only easily readable if you put it back in P202.
What do you guys do before clearing the tables? I've been exporting good camps to excel but its annoying and not easy to reference.
I'd def pay for a tool like this and I'm sure others would too.
A way to easily access old campaigns for reference, kws, etc would be great. Would be like P202 but you can't run traffic through it, just sits on the desktop and lets you quickly view old data.
I know you can export the mysql tables but thats only easily readable if you put it back in P202.
What do you guys do before clearing the tables? I've been exporting good camps to excel but its annoying and not easy to reference.
I'd def pay for a tool like this and I'm sure others would too.
Your correct.
But I'm talking about when you have 1 Million + clicks registered and you then need to clear the tables.
Was hoping Wes can make a tool to solve that issue.
The best thing I could recommend is just archive it. Save ur mysql database and throw it on another server or something. Then you can have one p202 install that just has your old data in it.
It will still have issues with godaddy unless u tweak it alot. I'd use beyond hosting, they've been putting together custom VPS packages for our users: http://go.cleervoyance.com/aff_c?offer_id=21&aff_id=11
I installed it last night and it worked great.
However this morning when I went to check my stats, every tab except for the main overview was blank. The overview page had recorded new clicks, however no keywords are displaying now and my existing clicks are not showing in any other tab.
When I clicked on 'Group Overview" I got this doozy:
"Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SELECT COUNT(*) AS clicks, SUM(2cr.click_out) AS click_out, SUM(2c.click_lead) AS leads, 2ac.aff_campaign_payout AS payout, SUM(2c.click_payout*2c.click_lead) AS income, SUM(2c.click_cpc) AS cost FROM 202_clicks AS 2c LEFT OUTER JOIN 202_clicks_record AS 2cr ON (2c.click_id = 2cr.click_id) LEFT OUTER JOIN 202_aff_campaigns AS 2ac ON (2c.aff_campaign_id = 2ac.aff_campaign_id) LEFT OUTER JOIN 202_aff_networks AS 2an ON (2ac.aff_network_id = 2an.aff_network_id) LEFT OUTER JOIN 202_ppc_accounts AS 2pa ON (2c.ppc_account_id = 2pa.ppc_account_id) LEFT OUTER JOIN 202_ppc_networks AS 2pn ON (2pa.ppc_network_id = 2pn.ppc_network_id) WHERE 2c.user_id='1' AND 2c.click_time > 1279090800 AND 2c.click_time <= 1279781999 AND 2pn.ppc_network_id='4' AND 2c.aff_campaign_id='4'"
However this morning when I went to check my stats, every tab except for the main overview was blank. The overview page had recorded new clicks, however no keywords are displaying now and my existing clicks are not showing in any other tab.
When I clicked on 'Group Overview" I got this doozy:
"Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SELECT COUNT(*) AS clicks, SUM(2cr.click_out) AS click_out, SUM(2c.click_lead) AS leads, 2ac.aff_campaign_payout AS payout, SUM(2c.click_payout*2c.click_lead) AS income, SUM(2c.click_cpc) AS cost FROM 202_clicks AS 2c LEFT OUTER JOIN 202_clicks_record AS 2cr ON (2c.click_id = 2cr.click_id) LEFT OUTER JOIN 202_aff_campaigns AS 2ac ON (2c.aff_campaign_id = 2ac.aff_campaign_id) LEFT OUTER JOIN 202_aff_networks AS 2an ON (2ac.aff_network_id = 2an.aff_network_id) LEFT OUTER JOIN 202_ppc_accounts AS 2pa ON (2c.ppc_account_id = 2pa.ppc_account_id) LEFT OUTER JOIN 202_ppc_networks AS 2pn ON (2pa.ppc_network_id = 2pn.ppc_network_id) WHERE 2c.user_id='1' AND 2c.click_time > 1279090800 AND 2c.click_time <= 1279781999 AND 2pn.ppc_network_id='4' AND 2c.aff_campaign_id='4'"
Would be sick if we could set different time zones to different affiliate networks.
Slightly annoying when your traffic source is on the west coast and your aff network in on the east coast.
Slightly annoying when your traffic source is on the west coast and your aff network in on the east coast.
I will have a solution for you today
Unfortunately there is no real way to do this, the stats all need to compile into one timezone at the end like in prosper202.
Is it throwing errors?
Or is it completely blank? If it's blank, do u have the filtering toolbar unselected to everything? Do you have any data? Time-range setup right?
It would be awesome to have a fully-featured offer rotator. Mainly needs weighted rotation and the ability to set unique payouts for each offer.