Affiliate Stats Dumps

From TMM Wiki
Jump to navigationJump to search
NATS 4
For Affiliates
Affiliate Adtools
Automatic Campaigns
Affiliate Payment Information
Affiliate Defaults
Linkcodes
Affiliate Stats Dumps
ASP Query String
Deep Linking
Main Program Page
NATSCode
Members Admin
The Members Admin
View Member Details
Add Member
MySQL Auth
Mod Authn DB
Multisite Access
Member Logging
Member Password Retrieval
OpenID Connect
Mod Auth OpenIDC
ID Numbers

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

For example:

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

"identid","loginid","date","raw_hits","unique_hits","qualified_hits","join_hits","join_submits","initial_count","trial_count","manual_count","rebill_count","conversion_count","void_count","credit_count","chargeback_count","insufficient_funds_count","initial_payout","trial_payout","manual_payout","rebill_payout","conversion_payout","void_payout","credit_payout","insufficient_funds_payout","chargeback_payout","total_join_count","total_join_payout","total_rebill_count","total_rebill_payout","total_other_payout","total_refund_count","total_refund_payout","total_payout","void_reversal_count","credit_reversal_count","chargeback_reversal_count","insufficient_funds_reversal_count","void_reversal_payout","credit_reversal_payout","insufficient_funds_reversal_payout","chargeback_reversal_payout","total_account_rep_payout","total_referral_payout","total_byoa_payout","total_tier_adjustment_payout","total_correction_payout","name";

"","","","740","740","0","154","7","2","2","","1","0","0","0","0","0","2548","838","","0","0","0","0","0","0","4","3386","1","0","","0","0","3386","0","0","0","","0","0","","0","0","0","0","","","1274328000"; 
"","","","834","834","0","163","15","7","2","","2","0","0","0","0","0","6532","1000","","0","0","0","0","0","0","9","7532","2","0","","0","0","7532","0","0","0","","0","0","","0","0","0","0","","","1274414400"; 

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