Difference between revisions of "Affiliate Stats Dumps"

Revision as of 10:50, 3 January 2012

Getting Affiliate Stats Dumps

Offerit offers the ability to get dumps of affiliate stats through two languages, XML and CSV. To get access to these dumps, you must use a direct URL in your Offerit install directory.

To get to this URL, type in your Offerit install directory:

 <Offerit install address>.offerit.com/internal.php?page=dump&period=<value> 

Replace <Offerit install address> with your directory, and replace <value> with a number from 0-9 depending on what time period you want the dumps to reflect:

• 0 = Current Period
• 1 = Last Period
• 2 = Today
• 3 = Yesterday
• 4 = Past Week
• 5 = Past Month
• 6 = Past Year
• 7 = All Time
• 8 = Free Form Date
  • Free form dates must be specified in the URL in the order of year, month, day
  • The format for free form dates is <...>period=8&start=<start date>&end=<end date>
  • For example,

    &start=2010-05-12&end=2010-06-09

• 9 = Unix Timestamp
  • This is useful because it does not require dashes and other formatting to specify your date, insted using raw Unix Timestamps when getting dumps
  • You can use the same format as free form dates, except with Unix values
  • For example,

    &start=1274068800&end=1276056000

XML Dumps

Offerit is configured so that XML is the default dump when you get them through a direct URL. To get XML dumps, go to your URL:

<Offerit install address>.offerit.com/internal.php?page=dump&period=<value>

and set a value for a time period to be displayed.

Once you navigate to the XML dump, you should see numeric values that look like:

 <_1275883200 name="1275883200"> 165 21 799 799 0 15 3 1 1 0 0 0 0 34274 3338 0 0 0 0 0 0 18 37612 2 0 3255 0 0 40867 0 0 0 0 0 0 0 3255 0 <_1275969600 name="1275969600"> 236 23 877 877 0 13 5 1 3 0 0 0 0 23517 9338 0 3822 0 0 0 0 18 32855 4 3822 1778 0 0 38455 0 0 0 0 0 0 0 1778 0 <_1276056000 name="1276056000"> 89 8 339 339 0 5 1 2 10081 3000 1274 6 13081 2 1274 450 14805 0 450 0...

These are your XML dumps of affiliate stats. To get a cleaner list of values, right click and select "View Page Source." This will give you the raw XML code for the data requested.

CSV Dumps

CSV is short for Comma-Seperated Values, another language for organizing database information. The process of getting CSV dumps is similar to the process of attaining XML dumps, with an exception in the URL.

Since XML is the default language for dumping through direct URL access, you must specify that you are requesting a CSV code in the URL. To do this, go to the same directory as you would for an XML dump, but at the end of the URL add &format=csv.

 <Offerit install address>.offerit.com/internal.php?page=dump&period=7&format=csv 

If you get a list of various values that are seperated by commas, the values are your CSV dumps. Once you have navigated to the CSV dump, you should see numeric values that look like this:

"","Page Views","Unique Visitors","Conversion Rate","EPC","SubAff","Fraud","Sales","Payment";

"1319688000","0","0","0:0","$0.00","","","0","$0.00";
"1319774400","0","0","0:0","$0.00","","","0","$0.00"; 

These are your CSV dumps. These figures can be directly exported to Excel or any software that handles CSV dumps.