# Get conversions

| HTTP method | Endpoint                    |
| ----------- | --------------------------- |
| **GET**     | **/v1/conversion\_reports** |

## Path parameters <a href="#path-parameters" id="path-parameters"></a>

| 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 <a href="#query-string-parameters" id="query-string-parameters"></a>

| 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 <a href="#response-body-parameters" id="response-body-parameters"></a>

| 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 <a href="#example-request" id="example-request"></a>

**Request GET** [https://{networkname}.api.offerslook.com/v1/conversion\_reports?end\_time=2016-10-22](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](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 <a href="#example-response" id="example-response"></a>

```
    {
      "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
      }
    }
```
