Difference between revisions of "Affiliate Stats Dumps"
From TMM Wiki
Jump to navigationJump to searchTMMStephenY2 (talk | contribs) |
TmmStephen (talk | contribs) |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
{{NATS4 Manual | {{NATS4 Manual | ||
| − | | | + | | show_for_affiliates_section = true |
}} | }} | ||
== Getting 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. | + | [[NATS]] offers the ability to get dumps of [[Ct#Affiliate|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: | + | To get to this URL, type in your [[NATS]] install directory: |
| − | <pre> <NATS install address> | + | <pre> <NATS install address>/internal.php?page=dump&period=<value> </pre> |
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: | 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: | ||
| Line 26: | Line 26: | ||
* 9 = Unix Timestamp | * 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 | ** 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 | + | ** You can use the same format as [[NATS4 Freeform Date|free form dates]], except with Unix values |
**For example, <pre>&start=1274068800&end=1276056000</pre> | **For example, <pre>&start=1274068800&end=1276056000</pre> | ||
== XML Dumps == | == 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]] 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: |
| − | <pre><NATS install address> | + | <pre><NATS install address>/internal.php?page=dump&period=<value></pre> |
and set a value for a time period to be displayed. | 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: | Once you navigate to the XML dump, you should see numeric values that look like: | ||
| − | <pre> < | + | <pre> <_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...</pre> |
| − | 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. | + | These are your XML dumps of [[Ct#Affiliate|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 Dumps == | ||
| Line 47: | Line 47: | ||
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. | 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: <pre> < | + | For example: <pre> <NATS install address>/internal.php?page=dump&period=7&format=csv </pre> |
| − | 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. | + | 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: |
| + | |||
| + | <pre>"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"; </pre> | ||
| + | |||
| + | These are your CSV dumps. These figures can be directly exported to Excel or any software that handles CSV dumps. | ||
| + | |||
| + | [[Category:NATS4 Affiliate Information]] | ||
Latest revision as of 10:59, 18 November 2011
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.
