Reports API

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

🔗 Click to Test Reports API

Common Parameters

Query	Type	Description
mid	Integer	Your Advertiser MID
aid	Integer	Affiliate ID
key	String	API Key

---

Filters

Query	Type	Description
date_from	Date	Report Start Date (YYYY-MM-DD)
date_end	Date	Report End Date (YYYY-MM-DD)
datetime_from	Datetime	Report Start Date & Time (YYYY-MM-DD hh:mm:ss)
datetime_end	Datetime	Report End Date & Time (YYYY-MM-DD hh:mm:ss)
results	String	No. of results
page	Integer	Page No. (Starts from zero)
timezone	Decimal	Default 0.0 UTC
offer	String	Offer ID
report_type	String	Allowed values: click, conversion, imps
aff_sub1	String	First Sub Affiliate ID (Affiliate Data)
aff_sub2	String	Second Sub Affiliate ID (Affiliate Data)
aff_sub3	String	Third Sub Affiliate ID (Affiliate Data)
aff_sub4	String	Fourth Sub Affiliate ID (Affiliate Data)
aff_sub5	String	Fifth Sub Affiliate ID (Affiliate Data)

https://api.offer18.com/api/af/report?key=000000000&aid=0000&mid=0000

Specify fields to view

Query	Type	Description
fields	String	Allowed values: clicks, conversion, affiliate_price, date, time, hour, offer, offer_name, 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, aff_sub6, aff_sub7, aff_sub8, aff_sub9, aff_sub10, ios_idfa, source, google_aid, android_id, device_id, cr, ctr, cpc, ecpm, e_cost_per_conversion, cr_unique, coupon

https://api.offer18.com/api/af/report?key=000000000&aid=0000&mid=0000&fields=clicks,conversion,affiliate_price,date,time,hour,offer,offer_name,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,aff_sub6,aff_sub7,aff_sub8,aff_sub9,aff_sub10,adv_sub4,adv_sub5,ios_idfa,source,google_aid,android_id,device_id,cr,ctr,cpc,ecpm,e_cost_per_conversion,cr_unique,coupon

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/af/report?key=000000000&aid=0000&mid=0000&sort_by=000000&sort_type=0000

---

Example API Request

---

API Response

{
	"status": 200,
	"records": 3,
	"timezone": "+5:30",
	"reports": [
	{
		"Date": "2021-09-09",
		"Time": "2021-09-09 17:16:24",
		"Hour": "2021-09-09 17:00",
		"OfferID": "0001",
		"Sub_Affiliate": "",
		"Event": "",
		"Impressions": 0,
		"Clicks": 8,
		"UniqueClicks": 0,
		"Conversions": 0,
		"Affiliate_Model": "CPA",
		"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": "",
		"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": "",
		"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": ""
	},	
	]
}