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.

end_time

End time range. Format yyyy-MM-dd HH:mm:ss.

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

Check page scale.

Limit

limit

The number of date displays in each page. Maximum = 1000

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).

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

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
      }
    }

PreviousConversion Reports NextApprove conversion by conversion id

Last updated 2 years ago