Network creative frequency and recency

The Network Creative Frequency & Recency report can be used to view creative data for a specific advertiser based on the frequency and recency of user views. This report is more granular than the Advertiser Creative Frequency and Recency report and is available to network users only.

For instructions on retrieving a report, see Report Service or the example below. This report requires specifying the advertiser ID as part of the URL, for example:

https://api.appnexus.com/report?advertiser_id=ADVERTISER_ID

Time frame

The report_interval field can be set to one of the following:

• last_hour
• today
• yesterday
• last_48_hours
• last_2_days
• last_7_days
• last_14_days
• month_to_date
• last_30_days
• last_month
• last_100_days
• custom

Data retention period

Data retention period for this report is 120 days (no data before February 26, 2017).

Dimensions

Metrics

Creative frequency buckets

Creative recency buckets

Example

Create a JSON formatted report request

$ cat network_advertiser_frequency_recency

{
    "report":
    {
        "report_type": "network_advertiser_frequency_recency",
        "columns": [
            "creative_recency_bucket",
            "creative_frequency_bucket",
            "creative_id",
            "imps",
            "clicks",
            "total_convs",
            "booked_revenue",
            "media_cost",
            "profit_ecpm"
        ],
        "report_interval": "last_7_days",
        "emails": ["jsmith@xandr.com"],
        "format": "csv"
    }
}

POST the request to the reporting service

$ curl -b cookies -c cookies -X post -d @network_frequency_recency 'https://api.appnexus.com/report?advertiser_id=384'

{
    "response": {
        "status": "OK",
        "report_id": "0f148df60ff2760d57014f607f46fce4"
    }
}

Use the report ID to retrieve the report data

The standard response includes the report data and a Download URL that you can use to save the data to a file. If you want to get just the Download URL without the report data, pass "without_data" in the query string.

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

{
    "response": {
        "status": "OK",
        "report": {
            "name": null,
            "created_on": "2012-02-03 22:00:33",
            "cache_hit": false,
            "fact_cache_hit": false,
            "fact_cache_error": "did not find any cache table for 2,4,44,30,31,66,32,34,9,17,16,36",
            "json_request": "{\"report\":{\"report_type\":\"network_advertiser_frequency_recency\",
             \"columns\":[\"creative_recency_bucket\",\"creative_frequency_bucket\",\"creative_id\",
             \"imps\",\"clicks\",\"total_convs\",\"booked_revenue\",\"media_cost\",\"profit_ecpm\"],
             \"report_interval\":\"last_7_days\",\"emails\":[\"js@email.com\"],\"filters\":
             [{\"buyer_member_id\":\"541\"},{\"advertiser_id\":\"3610\"}]}}",
            "header_info": "Report type:,network_advertiser_frequency_recency\r\n,\r\nRun at:,
             2012-02-03 22:00:33\r\nStart date:,2012-01-27 00:00:00\r\nEnd date:,2012-02-03 00:00:00
             \r\nTimezone:,\r\nUser:,John Smith (9685)\r\n",
            "data": "creative_recency_bucket,creative_frequency_bucket,creative_id,imps,clicks,
             total_convs,booked_revenue,media_cost,profit_ecpm\r\n7-14 days,6-10,753570,1,0,0,.000000,
             .000000,.000000000000000000000000\r\n15-30 minutes,151-250,753571,3,0,0,.000000,.000000,
             .000000000000000000000000\r\n1-2 days,11-20,1316901,12,0,0,.000000,.004200,-.350000000000
             000000000000\r\n1-2 days,11-20,1316886,6,0,0,.000000,.001900,-.316666666666666666667000\r
             \n7-14 days,21-40,773408,3,0,0,.000000,.000160,-.053333333333333333333000\r\n30-60 minutes,
             500+,700464,35,0,0,.000000,.000000,.000000000000000000000000\r\n30-60 minutes,2-5,1317391,
             ...
            "url": "report-download?id=0f1374f60ff2760d57014f607f46fce4"
        },
        "execution_status": "ready"
    }
}

Use the Download URL to save the report data to a file

You use the "url" field in the response to save the report data to a file. Simply make another GET call and identify the location and file that you want to save to. Be sure to use the file the extension of the "format" that you specified in your initial POST request.

$ curl -b cookies -c cookies 'https://api.appnexus.com/report-download?id=0f1374f60ff2760d57014f607f46fce4' > /tmp/network_frequency.csv