Ex-Co Walkthrough
  • 3 Minutes to read
  • Dark
    Light
  • PDF

Ex-Co Walkthrough

  • Dark
    Light
  • PDF

Article summary

Cedato Reports in Rivery

Rivery allows users to pull data from Cedato in the following reports:

  1. Supplies report

  2. Demands report

  3. Domains report

  4. Domains by Supply report

  5. Revenue report

  6. Top supplies report

  7. Top demand report


Cedato Columns in Rivery 

The Cedato API returns columns with a different name as compared to the columns in the Cedato UI. 

Follow these mappings to understand the connection between the columns:


Supply Report 

API

Dashboard

supply_id

Supply ID

supply_name

Supply Name

supply_type

Type

impressions

Opportunities

loaded

Player Loads

usable

Usable

ad_starts

Impressions

revenue

Revenue

cost

Cost

RPM

RPM

loaded_percent

Player Loads%

usable_percent

Usable%

ad_starts_percent

FillRate%

 

Demand Report

API

Dashboard

demand_id

Demand ID

supply_id

Supply ID

demand_url

Demand URL

name

Demand Name

ad_requests

Ad Responses

ad_loads

Ad Loads

ad_starts

Impressions

completed

Complete

reqs_starts

Start Requests

ad_loads_precent

Ad Loads%

ad_starts_precent

FillRate%

revenue

Revenue

 Supplies/Demand reports


The supplies and demands reports contain information about supplies/demands for a given time period and in different types of aggregations. 

  1. Select how to group by the results of the report

  • The list of the available values to group by is different in the supplies report compared to the demands report. 
  • If selecting to group by “day” - the interval chunks input will be available (instead of the “time resolution” input). 
  1. Date range - Choose the date range of the report

  • Select the start date of the report
  • Select the end date of the report or leave empty in order to run the report until the moment the report runs. 
  • After the river runs, the start date will be updated with the value of the end date and the end date will be updated with an empty value. This will cause the next river to run from the end of the last run. 
  • Days back - use this input in order to include days before the given start date. For example, if days back = 7, the report will run from 7 days before the start date until the given end date. 


  1. Time resolution - Select the time resolution of the report. 

    If you do not select “day” to group by, it is possible to run the report in different time resolutions. 

    The results will contain the start date and the end date of the selected time resolution so that each record in the results will store these values. 

  1. Interval chunks - Decide if you would like to run the API in smaller chunks. This option will split the process into smaller requests for each of the selected intervals. 

    There might be a case where you are trying to run a report with the “day” group by for a long period of time. In this case, if you select the weekly interval, the API will run for each week in the given time period. 


Domains/Domains By Supply/Domains By Demand Reports

  1. Date range - Decide the date range of the report

  • Select the start date of the report
  • Select the end date of the report or leave empty in order to run the report until the moment the report runs. 
  • After the river runs, the start date will be updated with the value of the end date and the end date will be updated with an empty value. This allows the next run of the river to run from the end of the last run. 
  • Days back - use this input in order to include days before the given start date. For example, if days back = 7, the report will run from 7 days before the start date until the given end date. 
  • Time resolution - Select the time resolution of the report. 

If you don’t select “day” to group by, it is possible to run the report in different time resolutions. The results will contain the start date and the end date of the selected time resolution. Each record in the results will store those values. 


Revenue Report

  1. Date range - Decide the date range of the report

  • Select the start date of the report
  • Select the end date of the report or leave empty in order to run the report until the moment the report runs. 
  • After the river runs, the start date will be updated with the value of the end date and the end date will be updated with an empty value. This allows the next run of the river to run from the end of the last run. 
  • Days back - use this input in order to include days before the given start date. For example, if days back = 7, the report will run from 7 days before the start date until the given end date. 


Top Supplies/Top Demands Reports

These reports provide information about the top 10 demands/supplies in the given Cedato account up until the moment the river runs. 

These reports have no inputs.


Was this article helpful?