Offerit API Get Profit Loss Report

From Offerit
Revision as of 08:21, 20 September 2013 by OfferitSopko (talk | contribs) (Created page with "{{Offerit Manual | show_api_admin_section = true }} This functions allows for you to grab all the details for the profit and loss report remotely. The get_profit_loss_report acc...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
Offerit
For Affiliates
Automatic SubIDs
Affiliate Stats Dumps
Linkcode
Link Groups
Affiliate Custom Pixels
Affiliate Host and Post
Offerit 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
Offerit Setup
Creating Admin Accounts
Tracking Domain
Edit Affiliate Text
Edit CSS Colors
Getting Started Admin
Offerit Quick-Start Guide
Tracking in Offerit
Pixel Builder
Offerit 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
Visitor Actions 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 Post URLs
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
Creatives Admin
The Creatives Admin
Add New Creatives
Add New Creative Type
Offeritcode
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
REST API
General
Offerit REST API Overview
GET /service/ping
PATCH /service/set_currency_exchange_rates
Advertiser
PATCH /advertiser/edit_advertiser
POST /advertiser/add_advertiser
Affiliate
GET /affiliate/get_links
GET /affiliate/get_single_link
GET /affiliate/search
GET /affiliate/decode_trackingcode
PATCH /affiliate/edit_affiliate
PATCH /affiliate/payvia
POST /affiliate/add_affiliate
POST /affiliate/affiliate_login_ips
Config
GET /config/get_global_void_ips
GET /config/get_global_post_ips
GET /config/get_global_hostnpost_ips
POST /config/add_global_void_ip
POST /config/remove_global_void_ip
POST /config/add_global_post_ip
POST /config/remove_global_post_ip
POST /config/add_global_hostnpost_ip
POST /config/remove_global_hostnpost_ip
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
Customer
PATCH /customer/set_customer_details
PATCH /customer/lock
PATCH /customer/unlock
PATCH /customer/forget
GET /customer/export
Offer
GET /offer/get_conversion_caps
GET /offer/check_orderid_exists
GET /offer/get_commission_changes
GET /offer/get_details
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
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
POST /transaction/approve_pending_transaction
GET /transaction/click_detail
SOAP API (*deprecated*)
API
Add Affiliate
Add Affiliate Sale
Add Offer
Approve Transaction
Creative Types
Decode Offeritcode
Deny Transaction
Disable Affiliate Landing Page
Edit Affiliate Sale
Enable Affiliate Landing Page
Get Affiliate Stats
Get Allowed Affiliates
Get Landing Page Details
Get Offer Details
Get Offer List
Get Profit Loss Report
List Affiliate Details
List Affiliate Subaffiliates
Ping
Set Affiliate Status
Set SubAffiliate Status
Set Member Details
Record Affiliate Click
Misc.
Rules
Freeform Date
Affiliate Custom Signup
Offeritcode
Tracking in Offerit
Offerit Logos
Void Conversions Remotely

This functions allows for you to grab all the details for the profit and loss report remotely. The get_profit_loss_report accepts the following parameters:

  • view - The breakdown of the report to display. The possible options are:
    • period
    • month
    • year
    • offer_group
    • landing_page
    • offer
    • subid1
    • subid2
    • login
    • adtool
    • demographic
  • params - Parameters for the report. Must be an array and may contain any of the following:
    • period - Which period of time to select data for. The following are the allowed periods parameters for Offerit:
      • 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
    • start - Free Form start date for stats. Used when period is not sent or set to 8
    • end - Free Form end date for 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 the affiliates assigned to the account rep.
    • filter_loginid - Only see stats for the specific login ID passed in.
    • filter_campaignid - Only see stats for the specific campaign ID for the affiliate. This parameter can only be used if filter_loginid is passed in.
    • filter_offerid - Only see stats for the specific Offer ID passed in.
    • filter_landing_pageid - Only see stats for the specific Landing Page ID passed in.
    • filter_adtoolid - Only see stats for the specific Creative ID passed in.
    • filter_offeritcode - Breakdown the Offerit code and only view stats associated with the Offerit code.
    • no_inhouse - Remove in-house traffic from the returned report.
    • no_typein - Remove type-in traffic from the returned report.

NuSOAP Example

This example continues from the main article NuSOAP Example:

$function = 'get_profit_loss_report';
$values = Array(
	'view' => 'year',
	'params' => Array(
		'period' => 7,
	),
);


$result = $client->call($function, $values, 'offeritapiadmin_wsdl');

Sample Output

Array (
	[total] => Array (
		[breakdown] => year
		[row] => Array (
			[initial] => 389
			[initial_amount] => 1373187
			[charges] => 19200
			[affiliate_payout] => 100430
			[payout] => 100430
			[referral_payout] => 0
			[account_rep_payout] => 0
			[partner_payout] => 0
			[byoa_payout] => 0
			[promotional_payout] => 0
			[join_profit] => 3779173
			[rebill] => 46
			[rebill_amount] => 120033
			[recurring] => 56
			[recurring_profit] => 121573
			[wm_join] => 29
			[wm_join_referral_payout] => 0
			[void] => 77
			[void_amount] => -73703
			[refunds] => 51
			[refund_loss] => -38645
			[void_reversal] => 36
			[void_reversal_amount] => 37908
			[advertiser_initial] => 272
			[advertiser_initial_amount] => 2276720
			[impression] => 18993
			[visitor] => 7969
			[chargeback] => 10
			[chargeback_amount] => -2850
			[phone_call] => 30
			[phone_call_amount] => 0
			[phone_conversion] => 10
			[phone_conversion_amount] => 0
			[joins_amount] => 19593
			[conversion] => 0
			[conversion_amount] => 0
			[recurring_count] => 0
			[recurring_amount] => 0
			[advertiser_income_amount] => 0
			[seconds_amount] => 0
			[credit] => 0
			[credit_amount] => 0
			[insufficient_funds] => 0
			[insufficient_funds_amount] => 0
			[credit_reversal] => 0
			[credit_reversal_amount] => 0
			[chargeback_reversal] => 0
			[chargeback_reversal_amount] => 0
			[insufficient_funds_reversal] => 0
			[insufficient_funds_reversal_amount] => 0
			[reversals] => 0
			[reversal_profit] => 0
			[tier_adjustment_payout] => 0
			[correction_payout] => 0
			[custom_income] => 0
		)
	)
	[rows] => Array (
		[0] => Array (
			[break] => 1293858000
			[stats] => Array (
				[impression] => 0
				[visitor] => 0
				[name] => 1293858000
				[initial] => 0
				[initial_amount] => 0
				[advertiser_initial] => 0
				[advertiser_initial_amount] => 0
				[join_profit] => 0
				[joins_amount] => 0
				[phone_call] => 0
				[phone_call_amount] => 0
				[phone_conversion] => 0
				[phone_conversion_amount] => 0
				[wm_join] => 0
				[conversion] => 0
				[conversion_amount] => 0
				[rebill] => 0
				[rebill_amount] => 0
				[recurring_count] => 0
				[recurring_amount] => 0
				[recurring] => 0
				[recurring_profit] => 0
				[advertiser_income_amount] => 0
				[seconds_amount] => 0
				[void] => 0
				[void_amount] => 0
				[credit] => 0
				[credit_amount] => 0
				[chargeback] => 0
				[chargeback_amount] => 0
				[insufficient_funds] => 0
				[insufficient_funds_amount] => 0
				[refunds] => 0
				[refund_loss] => 0
				[void_reversal] => 0
				[void_reversal_amount] => 0
				[credit_reversal] => 0
				[credit_reversal_amount] => 0
				[chargeback_reversal] => 0
				[chargeback_reversal_amount] => 0
				[insufficient_funds_reversal] => 0
				[insufficient_funds_reversal_amount] => 0
				[reversals] => 0
				[reversal_profit] => 0
				[payout] => 0
				[affiliate_payout] => 0
				[wm_join_referral_payout] => 0
				[referral_payout] => 0
				[account_rep_payout] => 0
				[partner_payout] => 0
				[byoa_payout] => 0
				[promotional_payout] => 0
				[tier_adjustment_payout] => 0
				[correction_payout] => 0
				[charges] => 0
				[custom_income] => 0
			)
		)
	)
)