Reporting API

Our daily revenue and placement report can be exported in order to use them in other software. In order to do this, please follow these steps:

1. Log into your Publisher-Account
2. Get your API-Token (Account Management -> Account)
3. Modify the API URL as required
4. Download the revenue report as CSV

API Reporting Endpoint

https://insight.connectad.io/APIreport?pid=API-Token&start=2024-10-04&end=2024-10-04&dpoint=0&websites=102,103&integration=2,5&groupby=website

Configuration

Parameter	Description
pid=API-Token	Replace "API-Token" with the Token in the Dashboard
start	Startdate of the Report (max 90 days in the past)
end	Enddate of the Report (max 31 days duration)
dpoint	Decimal point - 0 for "," and 1 for "." (Default: 0)
websites	Generate the Report for specific websites (comma separated).
integration	1 => Java Tag 2 => PreBid Client 3 => PreBid Server 4 => OpenRTB 5 => Amazon APS (comma separated).
groupby	Group values by "date", "website", "tag", "integration", "advertiser", "country" or "device". It is possible to combine values (e.g., "country,website").

Output

You will get the requested report as a CSV-Download with the following content

Column	Description
Placement	Name of the Placement (AdTag)
HB_ID	Header-Bidding ID (in case you're using Header-Bidding otherwise 0)
Website	Name of the Website
Integration	Integration used for specific requests
Format	Creative-Size
Impression sold	Number of Impressions sold
Revenue	Sum of revenue generated
AVG eCPM	Calculated average CPM
Requests	Number of requests submitted
Date	Date of the record
Filtered	Number of requests that were filtered and not eligible for bidding

API-Report Example

View: https://cdn.connectad.io/example_api.xlsx