Get conversions

HTTP method	Endpoint
GET	/v1/conversion_reports

Path parameters

Parameter	Description	Nullable
start_time	Start time range. Format yyyy-MM-dd HH:mm:ss.	No
end_time	End time range. Format yyyy-MM-dd HH:mm:ss.	No
timezone	Acquire timezone required by the report. Leave this parater vacant, the report will be based on the timezone set by netowrk.	Yes

Note: Test conversion data can be acquired via filter [aff_sub1][EQUAL_TO]=test, and it can be excluded via filter [aff_sub1][NOT_EQUAL_TO]=test

Query string parameters

Conditions	Parameters	Type	Description
Offset	offset	offset	Check page scale.
Limit	limit	limit	The number of date displays in each page. Maximum = 1000
Sort	sort	sort	Ranking according to the specified field ascending "+", or descending "-".
Filters	filters	filter	Query requirements of Specify field.
Support filter conditions			EQUAL_TO NOT_EQUAL_TO LESS_THAN LESS_THAN_OR_EQUAL_TO GREATER_THAN GREATER_THAN_OR_EQUAL_TO CONTAINS NOT_CONTAINS NULL NOT_NULL IN NOT IN
Fields	fields	field	You can choose the field of the query (the result of the query is in line with the selected field).
	id	integer	A string that uniquely identifies this conversion report.
	conversion_time	integer	Advertiser post back time
	click_time	integer	Client-side response time
	advertiser_id	integer	The advertiser id.
	affiliate_id	integer	The affiliate id.
	advertiser_manager_id	integer	The advertiser manager id.
	affiliate_manager_id	integer	The affiliate manager id.
	offer_id	integer	The offer id.
	country	string	Country name; country abbreviation available
	source_id	string	Source ID.
	click_id	string	Click ID.
	click_ip	string	Click IP.
	conversion_ip	string	Conversion IP.
	user_agent	string	User agent for user when session was started.
	status	string	The status of the conversion report. Allowed values: approved·rejected·pending
	status_remark	string	The remark providing more granular status details. Allowed values: need_approval offer_redirect duplicate_click offer_expired offer_status_error invalid_security_code ip_not_whitelisted affiliate_status_error affiliate_access_denied affiliate_conversion_cap_exceeded affiliate_payout_cap_exceeded advertiser_conversion_cap_exceeded advertiser_revenue_cap_exceeded conversion_expired conversion_protocol_not_matched encrypt_conversion_enabled event_endpoint_reached event_status_error total_affiliate_conversion_cap_exceeded total_affiliate_payout_cap_exceeded inactive_tracking_domain smartlink_not_found smartlink_status_error smartlink_access_denied
	conversion_test	integer	Test Conversion: 0 not test conversion 1 aff_test 2 adv_test Note: better to filter test conversion
	referral	string	Conversion Referral URL.
	is_post_back	integer	Postback: 0 No; 1 Yes
	currency	string	The currency of the offer.
	currency_revenue	string	The revenue of the offer.
	revenue	double	Offer revenue based on platform default currency
	currency_payout	string	The payout of the offer
	payout	double	Offer payout based on platform default currency
	currency_amount	string	The amount of the offer
	amount	double	Offer amount based on platform default currency
	profit	string	Offer profit based on platform default currency
	ios_idfa	string	iOS IDFA
	google_aid	string	Google AID
	android_id	string	Android ID.
	aff_sub1	string	Affiliate Sub ID 1.
	aff_sub2	string	Affiliate Sub ID 2.
	aff_sub3	string	Affiliate Sub ID 3.
	aff_sub4	string	Affiliate Sub ID 4.
	aff_sub5	string	Affiliate Sub ID 5.
	adv_sub1	string	Advertiser Sub ID 1.
	adv_sub2	string	Advertiser Sub ID 2.
	adv_sub3	string	Advertiser Sub ID 3.
	platform	string	Click Platform.

Response body parameters

Field	Type	Description
id	integer	The unique id for the report.
conversion_time	integer	Advertiser post back time
click_time	integer	Client-side response time
advertiser_id	integer	The unique id for the advertiser.
affiliate_id	integer	The unique id for the affiliate.
advertiser_manager_id	integer	The unique id for the advertiser manager.
affiliate_manager_id	integer	The unique id for the affiliate manager.
offer_id	integer	The unique id for the offer.
event_id	integer	The offer event id.
is_private_event	integer	private event: 1：Yes；0：No
country	string	Click GEO Country.
state	string	Click GEO State.
city	string	Click GEO City.
source_id	string	Source ID.
click_id	string	Click ID.
click_ip	string	Click IP.
conversion_ip	string	Conversion IP.
user_agent	string	User agent for user when session was started.
status	string	The status of the conversion report. Allowed values: approved·rejected·pending
status_remark	string	The remark providing more granular status details.
conversion_test	integer	Test Conversion: 0 not test conversion 1 aff_test 2 adv_test Note: better to filter test conversion
referral	string	Conversion Referral URL.
is_post_back	integer	Postback: 0 No; 1 Yes
currency	string	The currency of the offer.
currency_revenue	string	The revenue of the offer
revenue	double	Offer revenue based on platform default currency
currency_payout	string	The payout of the offer
payout	double	Offer payout based on platform default currency
currency_amount	string	The amount of the offer
amount	double	Offer amount based on platform default currency
profit	string	Offer profit based on platform default currency
ios_idfa	string	iOS IDFA
google_aid	string	Google AID
android_id	string	Android ID.
aff_sub1	string	Affiliate Sub ID 1.
aff_sub2	string	Affiliate Sub ID 2.
aff_sub3	string	Affiliate Sub ID 3.
aff_sub4	string	Affiliate Sub ID 4.
aff_sub5	string	Affiliate Sub ID 5.
adv_sub1	string	Advertiser Sub ID 1.
adv_sub2	string	Advertiser Sub ID 2.
adv_sub3	string	Advertiser Sub ID 3.
platform	string	Click Platform. Allowed values: PC·Mobile·Tablet
totalPages	integer	The list of data pages (associated with your limit).
totalRows	integer	Total number of available data.
offset	integer	The number of records from a collection to skip. Iterating over large collections with this parameter can be slow.
limit	integer	The number of data displayed on one page

Example request

Request GET https://{networkname}.api.offerslook.com/v1/conversion_reports?end_time=2016-10-22 00:00:00&start_time=2016-09-01 00:00:00&timezone=Asia/Hong_Kong&fields=id,conversion_time,click_id,click_ip,aff_sub1,click_ip,status,offer_id,advertiser_id&sort=+id&offset=2&limit=10&filters[id][GREATER_THAN_OR_EQUAL_TO]=1000&filters[id][LESS_THAN_OR_EQUAL_TO]=5000&filters[aff_sub1][NOT_EQUAL_TO]=test

Request GET http://{networkname}.api.offerslook.com/v1/conversion_reports?end_time=2016-10-22 00:00:00&start_time=2016-09-01 00:00:00&timezone=Asia/Hong_Kong&fields=id,conversion_time,click_id,click_ip,aff_sub1,click_ip,status,offer_id,advertiser_id&sort=+id&offset=2&limit=10filters[id][GREATER_THAN_OR_EQUAL_TO]=1000&filters[id][LESS_THAN_OR_EQUAL_TO]=5000&filters[aff_sub1][NOT_EQUAL_TO]=test

Example response

    {
      "code": 0,
      "message": "Successs",
      "data": {
        "rowset": [
          {
            "id": 1161,
            "conversion_time": 1474600385,
            "advertiser_id": 1,
            "offer_id": 63,
            "click_id": "S3VE02u_uaddu_m_uaddu__ugsadu_UW83yntaFROKnLhkBLFr7K8XEjzrhI4pYeU0dyBQb3_uaddu_6Owvs_e83ce_",
            "click_ip": "192.168.1.1",
            "status": "Approved",
            "aff_sub1": ""
          },
          {
            "id": 1162,
            "conversion_time": 1474600666,
            "advertiser_id": 1,
            "offer_id": 47,
            "click_id": "V7X1DzIQtEjU_uaddu_KUO38Q8y9kEWFNcMjbhMNsvOpwu3Bh3jPLdfv_ugsadu_T9TPjh6Q_e83ce_",
            "click_ip": "192.168.1.1",
            "status": "Approved",
            "aff_sub1": "oxKZ_ugsadu_DX_ugsadu_hqydr2OP1iPmEo9RplRlK2OT0Nkol1_uaddu_3fPJ2kY0kwmqFNGcAp6Q_e83ce_"
          },
          {
            "id": 1163,
            "conversion_time": 1474600684,
            "advertiser_id": 1,
            "offer_id": 47,
            "click_id": "IPQGBbN5KF3bAZxESdlDxqLjyqrX_uaddu_6mXbXgAiGeBErAQbjhTFsvhxty1uEk_e83ce_",
            "click_ip": "192.168.1.1",
            "status": "Approved",
            "aff_sub1": "DmZXb_uaddu_AZI4JBghJUG7_ugsadu_97Ab4gJGBqVa0VpRXbul2qIEycUb_uaddu_S03rFLz8RoQ_e83ce_"
          },
          {
            "id": 1165,
            "conversion_time": 1474613646,
            "advertiser_id": 5,
            "offer_id": 60,
            "click_id": "sndYIkeNSuordHLDf5TlcsECgJW0WZadD0xJvn6Of6W5EYRq61RjzzKocI4_e83ce_",
            "click_ip": "192.168.1.1",
            "status": "Approved",
            "aff_sub1": ""
          },
          {
            "id": 1166,
            "conversion_time": 1474613773,
            "advertiser_id": 5,
            "offer_id": 60,
            "click_id": "NfTC0FF7bY9Q8NtYMCxWjSzLyXziYheU0RXPUXgNftrLqEWoXkRpkmwgtpQ_e83ce_",
            "click_ip": "192.168.1.1",
            "status": "Approved",
            "aff_sub1": ""
          },
          {
            "id": 1167,
            "conversion_time": 1474613979,
            "advertiser_id": 5,
            "offer_id": 60,
            "click_id": "3L4CxebKePs2Aw_uaddu_7cH2uWE1zqn27TwswyVpLWbESKZ_ugsadu_qBbe3MFyq2V5gPDM_e83ce_",
            "click_ip": "192.168.1.1",
            "status": "Approved",
            "aff_sub1": ""
          },
          {
            "id": 1168,
            "conversion_time": 1474614108,
            "advertiser_id": 5,
            "offer_id": 60,
            "click_id": "RelbnAoPoWax3BRE6CGtrFiP1GJk72GZ1CZmZv4pw8smWX8HjGdrVG6gDjE_e83ce_",
            "click_ip": "192.168.1.1",
            "status": "Approved",
            "aff_sub1": ""
          },
          {
            "id": 1169,
            "conversion_time": 1474614153,
            "advertiser_id": 5,
            "offer_id": 60,
            "click_id": "3zAV_ugsadu_o4S6uUx6mLDjzThG6oNm3kd5_ugsadu_pAMcTgJ9PT5PagCdpdeWpe0SjLbno_e83ce_",
            "click_ip": "192.168.1.1",
            "status": "Approved",
            "aff_sub1": ""
          },
          {
            "id": 1170,
            "conversion_time": 1474614270,
            "advertiser_id": 5,
            "offer_id": 60,
            "click_id": "4_uaddu_t8vZf4KcMQyUZpOP_uaddu_jHnYI5FL_ugsadu__ugsadu_ymvpY5XNpQImiJmePc3IzgmhWoMe8Q_e83ce_",
            "click_ip": "192.168.1.1",
            "status": "Approved",
            "aff_sub1": ""
          },
          {
            "id": 1172,
            "conversion_time": 1474617214,
            "advertiser_id": 5,
            "offer_id": 60,
            "click_id": "jpKDjmNqD2XxNpE8t5_uaddu_D4lLE68nlvLdJvuspXuO6oiIz8ZE_ugsadu_6EcTOmu_ugsadu_Bpw_e83ce_",
            "click_ip": "192.168.1.1",
            "status": "Approved",
            "aff_sub1": "1023a7f283c3a7e78e7701068ddbc0"
          }
        ],
        "totalPages": 325,
        "totalRows": 3245,
        "offset": 2,
        "limit": 10
      }
    }