Affiliate Stats Dumps

Getting Affiliate Stats Dumps

NATS 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 NATS install directory.

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

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

Replace <NATS 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

NATS 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

<NATS install address>.toomuchmedia.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:

 <_1260939600 name="1260939600"> <_1261026000 name="1261026000"> <_1261112400 name="1261112400"> <_1261198800 name="1261198800"> <_1261285200 name="1261285200"> <_1261371600 name="1261371600"> <_1261458000 name="1261458000">...

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.

For example:

 <nats install directory>.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. These figures can be directly exported to Excel or any software that handles CSV dumps.