Conversion Pixel Last Fire

The Conversion Pixel Fire report allows you to view the date and time when your advertisers' conversion pixels last fired. You can use this information both to verify the pixels that are firing properly and to identify the pixels in need of troubleshooting.

For each conversion pixel, the last fire should correspond to the last time a user visited the web page on which the pixel is placed. If a pixel has never fired, or last fired a long time ago, it is a sign that the pixel may not be placed correctly on the page.

For instructions on retrieving a report, see Report Service or the examples below.

Time frame

This report retrieves data for the entire lifetime of a pixel but only in UTC timezone. The report_interval field in the JSON request can be set only to lifetime, but this is not necessary, as the interval defaults to lifetime if not specified. Likewise, the timezone field in the JSON request can be set only to UTC, but this is not necessary, as the timezone defaults to UTC if not specified.

Dimensions

Metrics

Examples

Create the JSON-formatted report request

$ cat pixel_fired
  {
    "report": {
        "report_type": "pixel_fired",
        "columns": [
            "pixel_id",
            "last_fired",
            "advertiser_id",
            "buyer_member_id"
        ],
        "report_interval": "lifetime",
        "emails": ["js@email.com"],
        "format": "csv"
    }
}

POST the request to the Reporting Service

$ curl -b cookies -c cookies -X POST -d @pixel_fired_report 'https://api.appnexus.com/report?advertiser_id=123'

{
    "response":{
        "status":"OK",
        "report_id":"07af1282c9485adcef49c95fa5d7496b"
    }
}

GET the report status from the Report Service

You make a GET call with the Report ID to retrieve the status of the report. You continue making this GET call until the execution_status is "ready". Then you use the report-download service to save the report data to a file, as described in the next step.

$ curl -b cookies -c cookies 'https://api.appnexus.com/report?id=07af1282c9485adcef49c95fa5d7496b'

{
    "response": {
        "status": "OK",
        "report": {
            "name": null,
            "created_on": "2012-01-27 19:47:51",
            "cache_hit": false,
            "fact_cache_hit": false,
            "fact_cache_error": "did not find any cache table for 2,59",
            "json_request": "{\"report\":{\"report_type\":\"pixel_fired\",\"columns\":[\"pixel_id\",
             \"last_fired\",\"advertiser_id\",\"buyer_member_id\"],\"report_interval\":\"lifetime\",\"emails\":
             [\"js@email.com\"],\"filters\":[{\"buyer_member_id\":\"319\"}]}}",
            "header_info": "Report type:,pixel_fired\u000d\u000a,\u000d\u000aRun at:,2012-01-27 19:47:51\
             u000d\u000aStart date:,\u000d\u000aEnd date:,\u000d\u000aTimezone:,\u000d\u000aUser:,
             Sample User (2562)\u000d\u000a",
            "url": "report-download?id=677556dvds34013ff1108f159d7f39b"
        },
        "execution_status": "ready"
    }
}

GET the report data from the Report Download Service

To download the report data to a file, you make another GET call with the Report ID, but this time to the report-download service. When identifying the file that you want to save to, be sure to use the file extension of the "format" that you specified in your initial POST.

curl -b cookies -c cookies 'https://api.appnexus.com/report-download?id=677556dvds34013ff1108f159d7f39b' > /tmp/pixel_fire.csv