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

    Ex-Co Walkthrough

    • 3 Minutes to read
    • Print
    • 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?
    What's Next