Skip to content
English
  • There are no suggestions because the search field is empty.

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.

Key benefits

  • Direct integration with BI tools (Power BI, Tableau, Looker…)
  • Compatible with all cloud infrastructures (AWS, Azure, GCP, SFTP…)
  • Reliable daily availability of up-to-date campaign KPIs

 

Delivery format & specifications

Item Expected format
Format Parquet
Delivery mode*
  • Each delivery generates a new file, kept in the storage.

OR

  • A single file is delivered daily, always with the same name, replacing the previous one.
Delivery schedule

File available daily before 10:00 CET - delivery time adjustable if needed.
Time range

Data from the last 24 hours.
Delivery destination

Preferred delivery : s3 bucket hosted by you.

If another mode of delivery is preferred on your side, please contact us.

 

*Delivery mode: 

  • Versioned mode – one new file per day, all files kept in storage → <YYYYmmddHHMMSS>_displayce_campaign_reports.parquet
  • Overwrite mode – a single file updated daily, always with the same name → displayce_campaign_reports.parquet

 

How to get started

To activate the daily delivery, please share the following with your Displayce contact:

  1. Your storage location / bucket URL
  2. Your preferred delivery schedule and time range (default: last 24 hours)
  3. Your preferred delivery mode (versioned or overwrite)

 

Reports fields

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