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()

  • 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?

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

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

  • 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

    • 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

  • Anao

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

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