# Reports API
```
GET https://api.offer18.com/api/m/report
```
:link: [**Click to Test Reports API**](https://offer18.readme.io/reference/reports-api)
### Common Parameters
| Query | | |
|---|
| Query | Type | Description |
| mid | Integer | Network Account ID |
| api-key | String | Network API Key |
| secret-key | String | Network Secret Key |
***
### Filters
| Query | | |
|---|
| 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 | 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 |
{% code overflow="wrap" %}
```
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
```
{% endcode %}
#### Get Specific 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,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,epc,cpc,erpm,ecpm,e_cost_per_conversion,e_revenue_per_conversion,status,status_type,filter_log
#### Additional Sorting Method
| Query | | |
|---|
| 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 |
{% code overflow="wrap" %}
```
https://api.offer18.com/api/m/report?mid=000&api-key=000&secret-key=000000000000&sort_by=clicks&sort_type=asc
```
{% endcode %}
***
### 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": "",
"CTR": "0.000 %",
"EPC": 0,
"CPC": 0,
"ERPM": 0,
"ECPM": 0,
"E_Cost_Per_Conversion": 0,
"E_Revenue_Per_Conversion": 0,
"CR": "0%"
}
]
}
```