Ex-Co walkthrough
Cedato Reports in Data Integration
Data Integration lets you pull data from Cedato in the following reports:
-
Supplies report
-
Demands report
-
Domains report
-
Domains by Supply report
-
Revenue report
-
Top supplies report
-
Top demand report
Cedato columns in Data Integration
The Cedato API returns columns with a different name from those in the Cedato UI.
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 period and in different aggregations.
- Select how to group by the report.
- The list of available values to group by is different in the supplies report from that in the demands report.
- If selecting to group by day - the interval chunks input will be available (instead of the time resolution input).
- Date range: Choose the report's date range.
- Select the start date of the report.
- Select the end date of the report or leave it empty to run the report until the moment the report runs.
- After the river runs, the start date will be updated with the end date value, and the end date will be updated with an empty value. This causes the next river to run from the end of the last run.
- Days back: Use this input 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 do not select day to group by, running the report in different time resolutions is possible.
The results will contain the start date and the end date of the selected time resolution, and each record will store these values.
- Interval chunks: Decide if you want to run the API in smaller chunks. This option will split the process into smaller requests for each selected interval. You might be trying to run a report with the “day” group for an extended period. In this case, if you select the weekly interval, the API will run each week in the given period.
Domains/domains by supply/domains by demand reports
- 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 it empty to run the report until it runs.
- After the river runs, the start date will be updated with the end date value, and the end date will be updated with an empty value. The next run of the river runs from the end of the last run.
- Days back: Use this input 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 do not select day to group by, you can run the report in different time resolutions. The results contain the start date and end date of the selected time resolution, and each record stores those values.
Revenue report
- Date range: Decide the report's date range.
- Select the start date of the report.
- Select the end date of the report or leave it empty to run the report until the moment the report runs.
- After the river runs, the start date will be updated with the end date value, 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 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 until the river runs. They have no inputs.
