Automated Reporting: Access your campaign data daily
Automated Reporting is the recommended way to retrieve your DOOH campaign performance data from the Displayce DSP. Every day, a complete campaign report is automatically generated and delivered to your storage infrastructure, ready to plug into your BI tools.
Overview
Displayce provides an automated daily export of your campaign performance data.
Once configured, a report is generated every day and securely delivered to your S3 bucket. This enables your teams to automate reporting, build custom dashboards, and integrate Displayce data into your existing analytics environment without any manual intervention.
Delivery Specifications
| Item | Expected format |
|---|---|
| File format | Parquet |
| Delivery frequency | Daily |
| Default delivery time |
12:00 CET (can be adjusted upon request) |
| Reporting period |
Previous 24 hours |
| Delivery destination |
Preferred delivery : s3 bucket hosted by you. If another mode of delivery is preferred on your side, please contact us. |
| Access method |
Authentication used : SAS token / AWS Access Key / AWS Secret Key ... |
| Delevery modes |
Choose the delivery mode that best fits your data ingestion process.
→ This option is recommended if you want to keep a complete history of all delivered files.
→ This option is recommended if your ingestion process always consumes the latest available report. |
Getting started
To configure the automated delivery, please provide the following information.
- 1. Delivery destination : Provide the storage location where Displayce should upload the daily reports.
Examples: AWS S3 s3://my-company-reporting/displayce/
- 2. Access credentials : Provide the credentials allowing Displayce to securely upload files to your storage.
Examples :
- AWS Access Key & Secret Access Key
- Azure SAS Token
- Google Cloud Service Account
- SFTP credentials
These credentials are only used for the automated delivery of your daily reports.
- 3. Delivery schedule
- preferred delivery time (default: 12:00 CET)
- reporting period (default: previous 24 hours)
- 4. Delivery mode : Please choose one of the following options:
- Versioned mode (one new file per day)
- example :
<YYYYMMDDHHMMSS>_displayce_campaign_reports.parquet - Overwrite mode (one file updated daily)
- example :
displayce_campaign_reports.parquet
Reports content
The daily report contains campaign metadata together with delivery and performance metrics.
The dataset includes:
- Campaign information
- Agency and advertiser information
- Creative details
- Display locations
- Venue information
- Device and screen identifiers
- Delivery timestamps
- Performance metrics (plays, impressions)
- Financial information (net cost, DSP fee, currency)
Data Dictionary
| Field | Description | Type |
|---|---|---|
campaign_name |
Name of the campaign | String |
campaign_uuid |
Unique identifier for the campaign | UUID |
deal_id |
Unique identifier for the deal | String |
currency_code |
Currency code for the deal | String |
net_cost |
Net cost of the campaign | Float |
impressions |
Number of impressions served | Integer |
plays |
Number of times the creative was played | Integer |
screens |
Number of screens/faces displaying | Integer |
line_item_name |
Name of the line item | String |
line_item_uuid |
Unique identifier for the line item | UUID |
publisher |
Publisher name | String |
creative_duration |
Duration of the creative in seconds | Integer |
creative_mime_type |
MIME type of the creative (e.g. video/mp4) | String |
creative_width |
Width of the creative in pixels | Integer |
creative_height |
Height of the creative in pixels | Integer |
creative_name |
Name of the creative | String |
creative_uuid |
Unique identifier for the creative | UUID |
point_of_display_environments |
Venue types where the display is located | String |
point_of_display_long |
Longitude coordinate of the display | Float |
point_of_display_lat |
Latitude coordinate of the display | Float |
point_of_display_city_name |
City of the display location | String |
point_of_display_country |
Country of the display location | String |
point_of_display_address |
Full geocoded address of the display | String |
point_of_display_name |
Name of the display frame location | String |
point_of_display_device_id |
Device identifier for the point of display | String |
dt_local |
Display timestamp in local timezone | Timestamp |
dt_local_last_display_time |
Last display timestamp in local timezone | Timestamp |
dt_server_time_pop |
Display timestamp in server time | Timestamp |
venue_name |
Name of the venue where the frame is located | String |
frame_type |
Type/category of the frame | String |
frame_uuid |
Unique identifier for the display frame | UUID |
advertiser_name |
Name of the advertiser | String |
advertiser_id |
Unique identifier for the advertiser | UUID |
agency_name |
Name of the agency | String |
agency_id |
Unique identifier for the agency | UUID |
purchase_order_number |
Purchase order reference number | String |
dsp_fee_rate |
DSP fee rate | Decimal |
validated |
Validation flag | Boolean |