Reports API

GET https://api.offer18.com/api/m/report

🔗 Click to Test Reports API

Common Parameters

Query	Type	Description
mid	Integer	Network Account ID
api-key	String	Network API Key
secret-key	String	Network Secret Key

---

Filters

Query	Type	Description
date_from	Date	Report Start date (YYYY-MM-DD)
date_end	Date	Report End date (YYYY-MM-DD)
results	Integer	No. of results
page	Integer	Page No. (Starts from zero)
timezone	Decimal	Default 0.0 UTC
offer	String	Offer ID
affiliate	String	Affiliate ID
advertiser	String	Advertiser ID

https://api.offer18.com/api/m/report?mid=000&api-key=000000&secret-key=000000000&date_from=0000-00-00&date_end=0000-00-00&offer=0000,1111,2222,3333&affiliate=0000,1111,2222&advertiser=0000,1111,2222&timezone=0.0&results=100

Get Specific fields

Query	Type	Description
fields	String	🔗 View Fields

https://api.offer18.com/api/m/report?mid=000&api-key=0000000&secret-key=00000000000&fields=tid,i_id,offer_name,advertiser,affiliate,advertiser_model,affiliate_model,advertiser_price,clicks,conversion,affiliate_price,date,time,hour,offer,s_affiliate,event,impressions,unique_clicks,affiliate_model,ip,currency,isp,country,conn_speed,location,browser,os,os_ver,device,device_brand,device_model,referral_domain,useragent,referral_url,aff_click_id,aff_sub1,aff_sub2,aff_sub3,aff_sub4,aff_sub5,adv_sub4,adv_sub5,ios_idfa,source,google_aid,android_id,device_id,status,status_type,filter_log

Additional Sorting Method

Query	Type	Description
sort_by	String	Allowed values: clicks, unique_clicks, conversions, date, time, hour (Only one option is allowed to use)
sort_type	String	Allowed values: asc and desc

https://api.offer18.com/api/m/report?mid=000&api-key=000&secret-key=000000000000&sort_by=clicks&sort_type=asc

---

Example API Request

---

API Response

{
        "status": 200,
	"records": 100,
	"timezone": "+5:30",
	"reports": [{
			"TID": "D-1111-1630919271-34G126G155G34-WKBNIYP121890",
			"ImpressionID": "",
			"Date": "2021-09-06",
			"Time": "2021-09-06 14:37:51",
			"Hour": "2021-09-06 14:00",
			"OfferID": 1111,
			"OfferName": "",
			"Advertiser": 22,
			"Affiliate": 89,
			"Sub_Affiliate": "",
			"Event": "",
			"Impressions": 0,
			"Clicks": 1,
			"UniqueClicks": 0,
			"Conversions": 0,
			"Advertiser_Model": "CPA",
			"Affiliate_Model": "CPA",
			"Advertiser_Price": 0,
			"Affiliate_Price": 0,
			"IP": "1.1.1.1",
			"Currency": "USD",
			"ISP": "Mountain_View_Communications",
			"Country": "AU",
			"Connection_Speed": "cable_dsl",
			"Location": "Australia, Oceania",
			"Browser": "ch",
			"OS": "windows",
			"OSver": 10,
			"Device": "desktop",
			"Device_Brand": "Lenovo",
			"Device_Model": "ideapad-x310s-ua",
			"Referral_Domain": "urlopener.net",
			"UserAgent": "Mozilla%2F5.0+%28Windows+NT+10.0%3B+Win64%3B+x64%29+AppleWebKit%2F537.36+%28KHTML%2C+like+Gecko%29+Chrome%2F93.0.4577.63+Safari%2F537.36",
			"Referral_URL": "https%3A%2F%2Fexample.net%2F",
			"Aff_Click_ID": "",
			"Aff_Sub_1": "",
			"Aff_Sub_2": "",
			"Aff_Sub_3": "",
			"Aff_Sub_4": "",
			"Aff_Sub_5": "",
			"Adv_Sub_4": "",
			"Adv_Sub_5": "",
			"iOS_IDFA": "",
			"Source": "",
			"Google_AID": "",
			"Android_ID": "",
			"Device_ID": "",
			"Status": "Approved",
			"Status_Type": "Direct",
			"Filter_Log": ""
		},
	]
}