ad:personam GmbH logo
Published on

DSP Reports Service

Build custom analytics reports with flexible dimensions, metrics, and filters. Download CSV results directly from your browser — no email required.

The DSP Reports service lets you build detailed analytics reports with full control over which dimensions and metrics are included. Reports are generated asynchronously and delivered as downloadable CSV files directly in the platform — no email step required.


How It Works

  1. Choose a report preset — each preset defines the dimensions and metrics available for that analysis type
  2. Configure filters — select a date range, campaign, and optional line items or conversion pixel
  3. Pick your dimensions and metrics — customise exactly what data columns appear in the output
  4. Submit — the report is queued for background generation; you can continue working
  5. Download — once ready, the report appears in the My Reports queue at the bottom of the page with a CSV download button

Available Report Presets

Each preset is optimised for a specific analytical need. When you select a preset, the Dimensions & Metrics panel updates to show only the data points relevant to that report.

PresetCategoryDescription
Delivery AnalyticsPerformanceComprehensive delivery, cost, viewability, engagement, and frequency metrics by date, campaign, and line item
Domain PerformanceInventoryPerformance breakdown by RTB domains, inventory sources, deals, and publishers
Video Inventory PerformanceVideoVideo completion rates, play times, and viewability across RTB inventory sources and video placement types
App PerformanceInventoryPerformance breakdown by app name, app ID, and inventory sources
Device & TechnologyTechnicalPerformance by device type, vendor, model, environment, and operating system
Browser & TechnologyTechnicalPerformance by browser, language, cookies, and environment type
Audience PerformanceAudienceDMP segment and data provider analysis with reach and frequency metrics
RTB Lost Bids AnalysisRTBTroubleshoot auction losses by analysing bid loss reasons across inventory sources
RTB Win Rate AnalysisRTBCompetitive bidding analysis with win rates, loss rates, and cost efficiency
Geo AnalyticsPerformanceGeographic breakdown by country, region, city, continent, and postal code

How to Generate a Report

Step 1: Access the Reporting Page

Navigate to Reporting → DSP Reports from the sidebar. The page is split into two sections: Report Configuration on the left and Dimensions & Metrics on the right.

Step 2: Configure the Report

In the Report Configuration card:

Report Preset — select one of the presets listed above. The description below the dropdown explains what the preset covers. Switching presets resets dimensions and metrics to their defaults.

Date Range — pick start and end dates using the date picker or use a quick preset button (Today, Yesterday, Last 7/30/90 Days, This Month, Last Month). Date ranges cannot exceed 365 days.

Date Kind — choose between UTC (default) and Campaign timezone for date filtering.

Campaign (required) — select the campaign to report on. This is a required field.

Line Items (optional) — narrow the report to specific line items within the selected campaign. Leave empty to include all line items.

Conversion Pixel (optional) — shown only when the selected preset includes conversion metrics. Select a tracking filter to filter data by a specific conversion event.

Conversion Attribution (optional) — shown alongside the conversion pixel selector. Choose between All (default), Post-Click, or Post-Impression attribution.

Step 3: Select Dimensions and Metrics

Switch between the Dimensions and Metrics tabs to customise which data columns appear in the report.

  • Dimensions determine how the data is grouped (e.g. by date, campaign, country). Maximum 8 dimensions per report.
  • Metrics are the numerical values measured (e.g. impressions, clicks, cost). Maximum 10 metrics per report.

Each dimension and metric has an info tooltip explaining what it represents. Items are organised into collapsible categories for easy navigation. Counters show how many items are selected in each category.

Use the Select First 8/10 and Deselect All buttons to quickly adjust selections. A summary of selected items appears below the list.

Step 4: Generate and Download

Click Generate Report in the top-right corner. The report is submitted for asynchronous processing and added to the My Reports queue at the bottom of the page.

The queue shows each report with its status:

StatusMeaning
Pending (spinner)Report is being generated. Polling continues automatically in the background.
Completed (green check)Report is ready. Click the Download CSV button to save it.
Paused (pause icon)Polling timed out after too many attempts. You can retry after a 10-minute cooldown.
Failed (red X)Generation failed. Review the error message and try again.

You can navigate away from the page while reports generate — the queue persists and polling continues in the background. Completed reports remain available for download until you clear them.


Understanding the Report Output

Reports are downloaded as CSV files. Each row represents a unique combination of the selected dimensions, and each column contains either a dimension value or a metric value.

Example Output Structure

For a Delivery Analytics report with dimensions date, campaign, lineItem and metrics impressions, clicks, ctr, cost:

datecampaignlineItemimpressionsclicksctrcost
2026-02-20Summer SaleDisplay Banner 300x25045,2303120.69%22.61
2026-02-21Summer SaleDisplay Banner 300x25051,8903870.75%25.94

Troubleshooting

Report stays in "Pending" for a long time

Large date ranges or high-cardinality dimension combinations (e.g. many domains across many days) take longer to process. Reports for complex queries may take several minutes. If the report transitions to "Paused", wait for the cooldown period and retry.

Report generation fails

Common causes:

  • No data available for the selected date range and filters — try a broader date range or different campaign
  • Too many dimensions or metrics — reduce the number of selected columns
  • Network or session timeout — refresh the page and retry from the queue

Data looks incomplete

  • Reports reflect data available at the time of generation. There may be a processing delay of up to a few hours for the most recent data.
  • Ensure the correct Date Kind (UTC vs Campaign timezone) is selected — mismatched timezones can shift data across date boundaries.
  • Check that the intended line items and conversion pixel filters are set correctly.

CSV formatting issues

If numbers appear incorrectly in your spreadsheet application, ensure you are importing the CSV with the correct delimiter and decimal format settings for your locale.


Tips for Effective Reporting

  • Start broad, then drill down — use Delivery Analytics for a campaign overview, then switch to Domain Performance or Geo Analytics for deeper analysis
  • Compare time periods — generate the same preset for different date ranges to spot trends and anomalies
  • Use RTB reports for troubleshooting — the Lost Bids Analysis and Win Rate Analysis presets help diagnose delivery issues and competitive pressure
  • Leverage conversion filtering — when tracking CPA campaigns, select the relevant conversion pixel to see conversion-attributed metrics alongside delivery data
  • Queue multiple reports — you can submit several reports in succession and download them all from the queue