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
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
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": ""
},
]
}
Last updated
Was this helpful?