Connect Your POF Data to P202 or CPVLab Data to Calculate Creative ROI

February 10, 2012 12 Comments by Tom Fang

POF Campaign Viewer

April 15, 2012, UPDATE: added the ability to sort the data in the resulting report! Download the latest version below.

March 25, 2012, UPDATE: the Campaign Viewer now supports the ability to analyze data from multiple campaigns in the same spreadsheet!

This is a simple Excel spreadsheet that we made to help you better analyze your POF ad data by combining the data from POF and your tracking software into one report.  It supports both Prosper202 and CPVLab.  Being able to see your ROI and profit data per creative is, in my opinion, crucial to your success, and I found that most people weren’t doing it.

Note that everyone has different tracking codes.  While this Campaign Viewer will be suitable for most people out of the box, please contact us directly if it’s not working for you, and we will make it custom to your tracking links.  Unfortunately, the free Viewer is not currently compatible with dynamic tags used in POF click-through URLs.

This should really help people new to POF get started pretty quick!  Be sure to checkout our other free tools as well.

Download Free:

Compatibility:
Requirements:
File Size: 		Prosper202 or CPVLab
Microsoft Excel
764.7 KB

This tool is available for subscribers only. If you haven’t subscribed, simply join our mailing list on the right hand sidebar. If you have subscribed and cannot locate your password, please contact us directly.

Here is a screenshot of a sample report it generates:

iPyxel Basic Campaign Viewer

  • Pingback: Connect Your POF Data to P202 or CPVLab Data to Calculate …

  • Pingback: Aggregating Creative Data Across Multiple POF Campaigns | iPyxel Creations | Straight-to-the-point internet marketing services and software

  • http://Website Tony

    Hey Tom, thanks for this tool.

    I’ve followed your instructions to the letter, but can’t get it to work. The “output” sheet never updates and I don’t see any of my numbers. Any suggestions?

    • http://www.ipyxel.com/ Tom Fang

      Currently, the model doesn’t support dynamic tokens in click through URLs. Once you take that out you should be good. Or else, send it over and I’ll fix it for you custom.

    • http://www.ipyxel.com/ Tom Fang

      Since the update, the tool does now support dynamic tokens in click-through URL’s.

  • http://Website robin

    Hey Tom, looks very cool. But is not working for me yet.

    My P202 reports/analyze/keywords is empty…(or [no keywords])
    What should I pass with &t202kw=?
    Maybe {creativeid:}?

    Also, just need Your advise, how do You setup custom variables in P202?
    My looks like that now: &c1=US&c2={state:default}&c3={age:default}&c4={creativeid:}&t202kw=
    But I still looking for optimal structure…

    Thanks in advance

    • http://www.ipyxel.com/ Tom Fang

      Hey Robin,

      Yes I would pass through the creative ID dynamic token if you’re relatively new. It should show up as number codes in your P202. Get that right first before you mess around with other stuff.

      -Tom

  • Pingback: New Theme, POF Changes, Updated POF Tools, Mobile Uploader | iPyxel Creations | Straight-to-the-point internet marketing services and software

  • bizbiz

    Hey Tom…trying to use this tool but PoF’s daily creative opens in 1 single cell on Excel…Unlike p202 which has a seperate cell for each component(campaign name, creative, clicks, etc…)

    Therefore i can’t use the tool…Have you encountered this and found a solution?

    thanks in advance

    • http://twitter.com/thmp Thales Prado

      I’ve had the same problem, there are three solutions for it:

      1st Solution:

      You can find here http://www.paessler.com/knowledgebase/en/topic/2293-i-have-trouble-opening-csv-files-with-microsoft-excel-is-there-a-quick-way-to-fix-this.

      2nd Solution:

      Open Excel. Go to File –> Open. Search for the csv file, ‘change file of type’ to ‘all files’ if necessary. When you select the file and open it, you should run the text import wizard. Select “Delimited” and Next, change the delimiters to “Comma” and Next. Click finish.

      3rd Solution:

      Save the csv file from POF as “txt”, and open it with Excel, then just follow the steps above… 

      I’ve done the first step, and it worked for me..
      Good luck!

  • Anao

    Does this work wit Excel Mac 2011? I tried it but it never finishes loading.

    • http://www.ipyxel.com/ Tom Fang

      This should since there are no macros so it should be compatible across all Excel 2007 and later.  If it never finishes loading it could mean that the program crashed before completing calculations.  The workbook does take quite a bit of power to do all those calculations.