NATS For Networks REST API Get Profit Loss Report

From TMM Wiki
NATS For Networks
For Affiliates
Automatic SubIDs
Affiliate Stats Dumps
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
Offer Setup
Affiliate Referrals
Tracking Domain
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
API Overview
GET /service/ping
GET /service/set_currency_exchange_rates
POST /advertiser/add_advertiser
PATCH /advertiser/edit_advertiser
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
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
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
GET /report/profitloss
GET /report/transaction
PATCH /customer/lock
PATCH /customer/unlock
GET /customer/export
PATCH /customer/forget
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
Video Download
Video Embed
Page Peels
IM Popups
Footer Ads
Page Ads
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
Freeform Date
Affiliate Custom Signup
Tracking Code
Tracking in NATS For Networks
Void Conversions Remotely

GET /report/profitloss


  • NATS for Networks supports an API resource to grab all the stats used within the NATS profit and loss report.

Resource URL

  • http://domain/api/service/profitloss
  • Replace domain with the nats domain

Request Method

  • GET

Response Format

  • JSON


  • HTTP headers


  • view - The breakdown of the report to display. Possible options are:
    • period
    • month
    • year
    • offer_group
    • landing_page
    • offer
    • subid1
    • subid2
    • login
    • adtool
    • demographic
    • refurl
    • device_type
    • device_brand
    • device_model
    • device_os
    • device_os_version
    • device_carrier
    • device_browser
  • params - Parameters for the report. An array that may contain:
    • period - Which period of time to select data for. See below for more information regarding the periods within NATS.
    • start - start date for the stats. Used when period is not sent or set to 8
    • end - end date for the stats. Used when period is not sent or set to 8
    • acct_rep - View the profit and loss report as an account rep. Will only see stats for affiliates assigned to the account rep
    • filter_loginid - Only see stats for the specifc login ID passed in.
    • filter_campaignid - Only see stats for the specific campaign ID for the affiliate. (Can only be used if filter_loginid is passed in)
    • filter_offerid - Only see stats for the specific site ID passed in.
    • filter_landingpageid - Only see stats for the specific tour ID passed in.
    • filter_adtoolid - Only see stats for the specific adtool ID passed in.
    • filter_programid - Only see stats for the specific program ID passed in.
    • filter_countryid - Only see stats for the specific Country ID passed in.
    • productcode - Breakdown the NATS code and only view stats associated with the NATS code.
    • limit_inhouse - 0 for all affiliates, 1 for only inhouse, 2 to exclude inhouse.
    • limit_mediabuy - 0 for all affiliates, 1 for only media buys, 2 to exclude media buys.
    • filter_device_type - 0 for desktop, 1 for mobile, unset for all types.
    • filter_device_brand_id - Device Brand ID.
    • filter_device_model_id - Device Model ID.
    • filter_device_os_id - Operating System ID.
    • filter_device_browser_id - Browser ID.
    • filter_device_carrier_id - IP/Carrier.


# Name Argument Description
0 current Current Period
1 last Last Period
2 today Today
3 yesterday Yesterday
4 week This Week
5 month This Month
6 year This Year
7 all All Time
8 free Freeform (See also the start and end parameters above)

Example Code


$curl = curl_init();

$data = array(
    'view' => 'year',
    'start' => '2006-06-06',
    'end' => 2015-03-14

$data_string = http_build_query($data);
$url = 'http://domain/api/report/profitloss?'.$data_string;

$headers = array(
    'api-key: 44b5498dbcb481a0d00b404c0169af62',
    'api-username: tmm1phrvezsbu'
curl_setopt($curl, CURLOPT_HTTPHEADER, $headers);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
curl_setopt($curl, CURLOPT_URL, $url);

$resp = curl_exec($curl);
//dumps an associative array representation of the json response
$output = json_decode($resp, true);
if($output !== NULL) {
	//json was valid. Dump the decoded array
else {
	//invalid json, just dump the raw response
// Close request to clear up some resources