NATS For Networks Affiliate Stats Dumps

From TMM Wiki
Jump to: navigation, search
NATS For Networks
For Affiliates
Automatic SubIDs
Affiliate Stats Dumps
Linkcode
Affiliate Custom Pixels
Affiliate Host and Post
Affiliate Area
Affiliate Account Details
Affiliate Account Change Log
Affiliate Creatives
Affiliate Creatives Search
Affiliate Settings
Affiliate Custom Pixels
Affiliate Linkcodes
Affiliate Linkcode Settings
Affiliate Login History
Affiliate Messages
Affiliate Dashboard
Dashboard Key Statistics
Dashboard Statistics Summary
Affiliate Payment History
Quick Links
Affiliate Referrals Report
Affiliate Referring URL Report
Affiliate Remote Login
Affiliate Signup
Affiliate Statistic Filters
Affiliate Statistic Views
Affiliate SubIDs
NATS For Networks Setup
Creating Admin Accounts
Tracking Domain
Edit Affiliate Text
Edit CSS Colors
Getting Started Admin
Quick Start Guide
Tracking in NATS For Networks
Pixel Builder
Postback Examples
Replacement Variables
Currency Exchange Rates

Admin Dashboard
The Admin Dashboard
Reporting Admin
The Reporting Admin
Track and Strack
  Report Breakdowns
Profit and Loss Report
Subscription Report
Transactions Reports
Affiliate Ratios Report
Affiliate Managers Report
Referral Tier Payouts Report
Referral Signup Payouts Report
Additional Commissions Report
Graphical Affiliate Comparison Report
The Single Day Comparison Report
Actual Affiliate Payments Report
Offers Admin
The Offers Admin
Offers
Offer Setup
Affiliate Referrals
Tracking Domain
Commissions
Commission Changes
Suppression Lists
Pixel Builder
ID Numbers
Offer Partner
Offer/Landing Page Redirection
Setting Rules
Admin Host and Post
Offer Goals
Affiliates Admin
The Affiliates Admin
ID Numbers
Affiliate Managers
Affiliate Referrals
Affiliate Activation
Admin-Only Settings
Affiliate Overrides
Creating Admin Accounts
In-House Accounts
Add Manual Sale
Manual Invoice
Affiliate Documents
Affiliate Enabled Offers
Change Affiliate Status
Account Changes
Advertisers Admin
The Advertisers Admin
Account Changes
Advertiser Invoices
Generate Invoice
Advertiser Approval
Change Advertiser Status
Customers Admin
Customers Admin
Manually Adding a Customer
ID Numbers
Payments Admin
The Payments Admin
Payvia Types
Payout Periods
Payvia Dump Formats
Payment Dump Entry Numbers
Payment Dump Variables
Check Functions
Setting Rules
Payment Methods
Payza
REST API
General
API Overview
GET /service/ping
GET /service/set_currency_exchange_rates
Advertiser
POST /advertiser/add_advertiser
PATCH /advertiser/edit_advertiser
Affiliate
GET /affiliate/get_links
GET /affiliate/get_single_link
GET /affiliate/search
GET /affiliate/decode_trackingcode
PATCH /affiliate/edit_affiliate
POST /affiliate/add_affiliate
POST /affiliate/affiliate_login_ips
Creative
GET /creative/get_creatives
GET /creative/get_creative_fields
GET /creative/get_creative_rules
PATCH /creative/delete_creative
PATCH /creative/edit_creative
PATCH /creative/edit_creative_rules
PATCH /creative/undelete_creative
POST /creative/add_creative
POST /creative/add_creative_rule
POST /creative/delete_creative_rules
Offer
GET /offer/check_orderid_exists
GET /offer/get_commission_changes
GET /offer/get_conversion_caps
PATCH /offer/activate_offer
PATCH /offer/edit_landing_page
PATCH /offer/edit_offer
PATCH /offer/pause_offer
PATCH /offer/set_commission_change_payouts
PATCH /offer/set_enabled_affiliates
PATCH /offer/set_offer_categories
PATCH /offer/set_offer_countries
PATCH /offer/set_offer_goals
PATCH /offer/set_offer_groups
PATCH /offer/set_offer_marketing_types
PATCH /offer/store_offer_ips
POST /offer/add_commission_change
POST /offer/add_landing_page
POST /offer/add_offer
POST /offer/add_tracking_domain
Reporting
GET /report/profitloss
GET /report/transaction
Customer
PATCH /customer/lock
PATCH /customer/unlock
GET /customer/export
PATCH /customer/forget
Transaction
GET /transaction/transaction_payout_preview
PATCH /transaction/transaction_update_revenue_by_orderid
PATCH /transaction/transaction_update_revenue_by_transaction_hash
POST /transaction/process_void
POST /transaction/process_chargeback
POST /transaction/process_reversal
GET /transaction/click_details
Creatives Admin
The Creatives Admin
Add New Creatives
Add New Creative Type
Tracking Code
Code Builder
Track and Strack
Setting Rules
  Default Creative Types
Creative Types
Image Banners
Flash Banners
Dynamic Text Banners
Feeds
Mailers
Video Download
Video Embed
Page Peels
IM Popups
Footer Ads
Page Ads
Overlays
Communications Admin
The Communications Admin
Add News Item
Sending Messages
Signup Questions
Configuration Admin
The Configuration Admin
Affiliate Signup Postback URL
Edit Affiliate Text
Edit CSS Colors
Misc.
Rules
Freeform Date
Affiliate Custom Signup
Tracking Code
Tracking in NATS For Networks
Void Conversions Remotely

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

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

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

Replace <NATS For Networks 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 For Networks 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 For Networks install address>.natsfornetworks.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.

For example:
 <NATS For Networks install address>.natsfornetworks.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.