# 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** 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** 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 } } ```