duv-by-time

ūüďė

This Reporting API endpoint was decommissioned on October 31, 2023, as part of the Delivery Reports Consolidation initiative. Learn more in the Delivery Reports Consolidation guide.

The following shows how to generate the duv-by-time report using either the Reporting API's Generate a report POST operation or the Get a cacheable report GET operation. Details about each report's supported products, metrics, filters, and available data intervals are also available dynamically by running the API's Get a report type operation, also shown below. See also other available reports.

Report definition

Returns visitor data over time.

This report allows you to configure the aggregation interval for each data record. Available interval values are: MONTH, WEEK, DAY.

Business object: cpcode

Data available for: 92 days

Available metrics

MetricDescription
Data metrics
allUniqueVisitorsThe total number of unique combinations of client IP addresses plus User Agent (or player ID for streaming).
ipv4UniqueVisitorsThe number of unique combinations of client IPv4 addresses plus User Agent.
ipv6UniqueVisitorsThe number of unique combinations of client IPv6 addresses plus User Agent.
Summary metrics
allUniqueVisitorsAverageThe average number of unique combinations of client IP addresses plus User Agent (or player ID for streaming).
allUniqueVisitorsMaxThe highest number of unique combinations of client IP addresses plus User Agent (or player ID for streaming)
allUniqueVisitorsMinThe lowest number of unique combinations of client IP addresses plus User Agent (or player ID for streaming)
allUniqueVisitorsSlopeRepresents the overall change in the unique combinations of client IP addresses plus User Agent (or player ID for streaming) over time, a positive number if increasing or a negative number if decreasing.
ipv4UniqueVisitorsAverageThe average number of unique combinations of client IPv4 addresses plus User Agent.
ipv4UniqueVisitorsMaxThe highest number of unique combinations of client IPv4 addresses plus User Agent.
ipv4UniqueVisitorsMinThe lowest number of unique combinations of client IPv4 addresses plus User Agent.
ipv4UniqueVisitorsSlopeRepresents the overall change in the unique combinations of client IPv4 addresses plus User Agent (or player ID for streaming) over time, a positive number if increasing or a negative number if decreasing.
ipv6UniqueVisitorsAverageThe average number of unique combinations of client IPv6 addresses plus User Agent.
ipv6UniqueVisitorsMaxThe highest number of unique combinations of client IPv6 addresses plus User Agent.
ipv6UniqueVisitorsMinThe lowest number of unique combinations of client IPv6 addresses plus User Agent.
ipv6UniqueVisitorsSlopeRepresents the overall change in the unique combinations of client IPv6 addresses plus User Agent (or player ID for streaming) over time, a positive number if increasing or a negative number if decreasing.

POST request

POST /reporting-api/v1/reports/duv-by-time/versions/1/report-data{?start,‚Äčend,‚Äčinterval}

Sample: /reporting-api/v1/reports/duv-by-time/versions/1/report-data?start‚Äč=2020-06-22T00%3A00%3A00Z‚Äč&end‚Äč=2020-06-26T00%3A00%3A00Z‚Äč&interval‚Äč=DAY

Query parameters

ParameterTypeSampleDescription
Required
startString2020-06-22T00:00:00ZSpecifies the start of the reported period as an ISO-8601 timestamp with optional time zone. The report includes data that matches the start value's timestamp.
endString2020-06-26T00:00:00ZSpecifies the end of the reported period as an ISO-8601 timestamp with optional time zone. The report excludes any data that matches the end value's timestamp.
intervalEnumerationDAYThe duration of each data record. Available values: MONTH, WEEK, DAY.

JSON request members

MemberTypeDescription
objectIdsArraySpecifies the set of cpcode values you want to report on.
objectIdsEnumerationAs an alternative to an array of ID values, specify all as a string for unfiltered data. Either way, objectIds is required.
metricsArrayThe set of desired metrics. If omitted, the report includes all available metrics.

Request body:

{
    "objectIds": [
        "55232",
        "23433",
        "32433"
    ],
    "metrics": [
        "allUniqueVisitors",
        "allUniqueVisitorsAverage",
        "allUniqueVisitorsMax",
        "allUniqueVisitorsMin",
        "allUniqueVisitorsSlope",
        "ipv4UniqueVisitors",
        "ipv4UniqueVisitorsAverage",
        "ipv4UniqueVisitorsMax",
        "ipv4UniqueVisitorsMin",
        "ipv4UniqueVisitorsSlope",
        "ipv6UniqueVisitors",
        "ipv6UniqueVisitorsAverage",
        "ipv6UniqueVisitorsMax",
        "ipv6UniqueVisitorsMin",
        "ipv6UniqueVisitorsSlope"
    ]
}

GET request

GET /reporting-api/v1/reports/duv-by-time/versions/1/report-data{?start,‚Äčend,‚Äčinterval,‚ÄčobjectIds,‚ÄčallObjectIds,‚Äčmetrics}

Sample: /reporting-api/v1/reports/duv-by-time/versions/1/report-data?start‚Äč=2020-06-22T00%3A00%3A00Z‚Äč&end‚Äč=2020-06-26T00%3A00%3A00Z‚Äč&interval‚Äč=DAY‚Äč&objectIds‚Äč=55232,‚Äč23433,‚Äč32433‚Äč&metrics‚Äč=allUniqueVisitors%2CallUniqueVisitorsAverage

Query parameters

ParameterTypeSampleDescription
Required
startString2022-06-23T13:55:00ZSpecifies the start of the reported period as an ISO-8601 timestamp with optional time zone. The report includes data that matches the start value’s timestamp.
endString2022-06-23T14:15:00ZSpecifies the end of the reported period as an ISO-8601 timestamp with optional time zone. The report excludes any data that matches the end value’s timestamp.
intervalEnumerationDAYThe duration of each data record. Available values: MONTH, WEEK, DAY.
Optional
allObjectIdsBooleantrueAs an alternative to objectIds, enabling this generates a report that includes all IDs available for the cpcode objectType. This parameter is ignored if the request also specifies a set of objectIds.
objectIdsString55232,‚Äč23433,‚Äč32433As an alternative to allObjectIds, specifies the set of unique IDs for the cpcode objectType you want to report on, formatted as a comma-delimited list.
metricsStringallUniqueVisitors,‚ÄčallUniqueVisitorsAverageSpecifies a comma-separated list of metrics to include in the report, otherwise all metrics if omitted. The set of available metrics depends on the type of report. URL-encode the entire value in the GET request.

JSON response

Status 200 application/json

Response body:

{
    "metadata": {
        "name": "duv-by-time",
        "version": "1",
        "outputType": "FLAT",
        "groupBy": [
            "startdatetime"
        ],
        "interval": "DAY",
        "start": "2020-06-22T00:00:00Z",
        "end": "2020-06-26T00:00:00Z",
        "availableDataEnds": null,
        "suggestedRetryTime": null,
        "rowCount": 4,
        "filters": [],
        "columns": [
            {
                "name": "groupBy",
                "label": "startdatetime"
            },
            {
                "name": "allUniqueVisitors",
                "label": "Unique Visitors"
            },
            {
                "name": "ipv4UniqueVisitors",
                "label": "Unique Visitors"
            },
            {
                "name": "ipv6UniqueVisitors",
                "label": "Unique Visitors"
            }
        ],
        "objectType": "cpcode",
        "objectIds": [
            "55232",
            "23433",
            "32433"
        ]
    },
    "data": [
        {
            "startdatetime": "2020-06-22T00:00:00Z",
            "allUniqueVisitors": "3114",
            "ipv4UniqueVisitors": "1184",
            "ipv6UniqueVisitors": "3113"
        },
        {
            "startdatetime": "2020-06-23T00:00:00Z",
            "allUniqueVisitors": "551",
            "ipv4UniqueVisitors": "2116",
            "ipv6UniqueVisitors": "1705"
        },
        {
            "startdatetime": "2020-06-24T00:00:00Z",
            "allUniqueVisitors": "880",
            "ipv4UniqueVisitors": "2109",
            "ipv6UniqueVisitors": "1209"
        },
        {
            "startdatetime": "2020-06-25T00:00:00Z",
            "allUniqueVisitors": "478",
            "ipv4UniqueVisitors": "1120",
            "ipv6UniqueVisitors": "4556"
        }
    ],
    "summaryStatistics": {
        "allUniqueVisitorsAverage": {
            "value": "1286",
            "details": {}
        },
        "allUniqueVisitorsMax": {
            "value": "4577",
            "details": {}
        },
        "allUniqueVisitorsMin": {
            "value": "1556",
            "details": {}
        },
        "allUniqueVisitorsSlope": {
            "value": "1573",
            "details": {}
        },
        "ipv4UniqueVisitorsAverage": {
            "value": "118",
            "details": {}
        },
        "ipv4UniqueVisitorsMax": {
            "value": "475",
            "details": {}
        },
        "ipv4UniqueVisitorsMin": {
            "value": "3443",
            "details": {}
        },
        "ipv4UniqueVisitorsSlope": {
            "value": "168",
            "details": {}
        },
        "ipv6UniqueVisitorsAverage": {
            "value": "3241",
            "details": {}
        },
        "ipv6UniqueVisitorsMax": {
            "value": "2923",
            "details": {}
        },
        "ipv6UniqueVisitorsMin": {
            "value": "2942",
            "details": {}
        },
        "ipv6UniqueVisitorsSlope": {
            "value": "91",
            "details": {}
        }
    }
}

CSV response

Status 200 text/csv

Response Body:

#METADATA_START
name,‚Äčduv-by-time
version,‚Äč1
source,‚Äčduv-by-time/versions/1
groupBy,‚Äčstartdatetime
start,‚Äč2020-06-22T00:00:00Z
end,‚Äč2020-06-26T00:00:00Z
interval,`DAY`
availableDataEnds,
suggestedRetryTime,
rowCount,‚Äč4
objectType,‚Äčcpcode
objectIds,‚Äč55232,‚Äč23433,‚Äč32433
#METADATA_END

#SUMMARYSTATISTICS_START
allUniqueVisitorsAverage,‚Äč1286
allUniqueVisitorsMax,‚Äč4577
allUniqueVisitorsMin,‚Äč1556
allUniqueVisitorsSlope,‚Äč1573
ipv4UniqueVisitorsAverage,‚Äč118
ipv4UniqueVisitorsMax,‚Äč475
ipv4UniqueVisitorsMin,‚Äč3443
ipv4UniqueVisitorsSlope,‚Äč168
ipv6UniqueVisitorsAverage,‚Äč3241
ipv6UniqueVisitorsMax,‚Äč2923
ipv6UniqueVisitorsMin,‚Äč2942
ipv6UniqueVisitorsSlope,‚Äč91
#SUMMARYSTATISTICS_END

#COLUMNS_START
startdatetime,‚ÄčallUniqueVisitors,‚Äčipv4UniqueVisitors,‚Äčipv6UniqueVisitors
#COLUMNS_END

#DATA_START
2020-06-22T00:00:00Z,3114,‚Äč1184,‚Äč3113
2020-06-23T00:00:00Z,551,‚Äč2116,‚Äč1705
2020-06-24T00:00:00Z,880,‚Äč2109,‚Äč1209
2020-06-25T00:00:00Z,478,‚Äč1120,‚Äč4556
#DATA_END

Get report details

This sample Get a report type operation gets the same information you need to run the duv-by-time report as provided in this reference documentation, but available dynamically to your API client application.

GET /reporting-api/v1/reports/duv-by-time/versions/1

Status 200 application/json

Response body:

{
    "name": "duv-by-time",
    "description": "Returns visitor data over time. ",
    "businessObjectName": "cpcode",
    "version": 1,
    "status": "PUBLISHED",
    "deprecated": false,
    "timeBased": true,
    "outputType": "FLAT",
    "requiredProducts": [
        "Basic Traffic Reports"
    ],
    "requiredRoles": [
        "Reports - All privileges ",
        "Reports - View only",
        "OTA App User"
    ],
    "available": true,
    "metrics": [
        {
            "name": "allUniqueVisitors",
            "description": "The total number of unique combinations of client IP addresses plus User Agent (or player ID for streaming).",
            "label": "Unique Visitors",
            "unit": "COUNT",
            "summaryStatistic": false
        },
        {
            "name": "allUniqueVisitorsAverage",
            "description": "The average number of unique combinations of client IP addresses plus User Agent (or player ID for streaming).",
            "label": "Unique Visitors Average",
            "unit": "COUNT",
            "summaryStatistic": true
        },
        {
            "name": "allUniqueVisitorsMax",
            "description": "The highest number of unique combinations of client IP addresses plus User Agent (or player ID for streaming)",
            "label": "Unique Visitors Maximum",
            "unit": "COUNT",
            "summaryStatistic": true
        },
        {
            "name": "allUniqueVisitorsMin",
            "description": "The lowest number of unique combinations of client IP addresses plus User Agent (or player ID for streaming)",
            "label": "Unique Visitors Minimum",
            "unit": "COUNT",
            "summaryStatistic": true
        },
        {
            "name": "allUniqueVisitorsSlope",
            "description": "Represents the overall change in the unique combinations of client IP addresses plus User Agent (or player ID for streaming) over time, a positive number if increasing or a negative number if decreasing.",
            "label": "Unique Visitors Slope",
            "unit": "COUNT",
            "summaryStatistic": true
        },
        {
            "name": "ipv4UniqueVisitors",
            "description": "The number of unique combinations of client IPv4 addresses plus User Agent.",
            "label": "Unique Visitors",
            "unit": "COUNT",
            "summaryStatistic": false
        },
        {
            "name": "ipv4UniqueVisitorsAverage",
            "description": "The average number of unique combinations of client IPv4 addresses plus User Agent.",
            "label": "Unique Visitors Average",
            "unit": "COUNT",
            "summaryStatistic": true
        },
        {
            "name": "ipv4UniqueVisitorsMax",
            "description": "The highest number of unique combinations of client IPv4 addresses plus User Agent.",
            "label": "Unique Visitors Maximum",
            "unit": "COUNT",
            "summaryStatistic": true
        },
        {
            "name": "ipv4UniqueVisitorsMin",
            "description": "The lowest number of unique combinations of client IPv4 addresses plus User Agent.",
            "label": "Unique Visitors Minimum",
            "unit": "COUNT",
            "summaryStatistic": true
        },
        {
            "name": "ipv4UniqueVisitorsSlope",
            "description": "Represents the overall change in the unique combinations of client IPv4 addresses plus User Agent (or player ID for streaming) over time, a positive number if increasing or a negative number if decreasing.",
            "label": "Unique Visitors Slope",
            "unit": "COUNT",
            "summaryStatistic": true
        },
        {
            "name": "ipv6UniqueVisitors",
            "description": "The number of unique combinations of client IPv6 addresses plus User Agent.",
            "label": "Unique Visitors",
            "unit": "COUNT",
            "summaryStatistic": false
        },
        {
            "name": "ipv6UniqueVisitorsAverage",
            "description": "The average number of unique combinations of client IPv6 addresses plus User Agent.",
            "label": "Unique Visitors Average",
            "unit": "COUNT",
            "summaryStatistic": true
        },
        {
            "name": "ipv6UniqueVisitorsMax",
            "description": "The highest number of unique combinations of client IPv6 addresses plus User Agent.",
            "label": "Unique Visitors Maximum",
            "unit": "COUNT",
            "summaryStatistic": true
        },
        {
            "name": "ipv6UniqueVisitorsMin",
            "description": "The lowest number of unique combinations of client IPv6 addresses plus User Agent.",
            "label": "Unique Visitors Minimum",
            "unit": "COUNT",
            "summaryStatistic": true
        },
        {
            "name": "ipv6UniqueVisitorsSlope",
            "description": "Represents the overall change in the unique combinations of client IPv6 addresses plus User Agent (or player ID for streaming) over time, a positive number if increasing or a negative number if decreasing.",
            "label": "Unique Visitors Slope",
            "unit": "COUNT",
            "summaryStatistic": true
        }
    ],
    "groupOutlyingValues": {
        "enabled": false
    },
    "groupBy": [
        "startdatetime"
    ],
    "intervals": [
        "MONTH",
        "WEEK",
        "DAY"
    ],
    "dataRetentionDays": 92,
    "links": [
        {
            "rel": "self",
            "href": "/reporting-api/v1/reports/duv-by-time/versions/1"
        },
        {
            "rel": "versions",
            "href": "/reporting-api/v1/reports/duv-by-time/versions"
        },
        {
            "rel": "all-reports",
            "href": "/reporting-api/v1/reports"
        },
        {
            "rel": "execute-report",
            "href": "/reporting-api/v1/reports/duv-by-time/versions/1/report-data"
        }
    ]
}