Data Views

A New Standard in Reporting and Data Analysis

1. What is Data Views?

Data Views is a new, flexible reporting system that allows you to:

• Access data dimensions and metrics previously unavailable.

• Customize reports with filters, columns, and views tailored to your needs.

• Analyze performance across campaigns, partners, creatives, and more.

Key Features:

• Instant filtering and data updates.

• Predefined and customizable reports.

• Options to export data or share reports with others.

2. Getting Started with Data Views

Familiarize Yourself with Data Views

• Begin by exploring the demo and walkthrough provided in the introduction video. It offers a clear explanation of how Data Views work, key features, and practical examples to help you get started quickly.

Accessing Data Views

1. Log in to your platform and navigate to the Insights and the Data Views section.

2. Choose a predefined report (e.g., Creative Set Performance, Tracking Details) or go to the overview.

3. Available Data Views

Here are the main predefined reports you can use:

• General Overview
  General Overview of the performance - light data model, may be used for long time ranges and with little filters

• Partner Overview
  Overview of your Partner’s performance - light data model, may be used for long time ranges and with little filters

• Creative Set Performance by Partner
  Analyze how specific creative sets (often “campaigns”) and partners contribute to conversions.

• Tracking Detail Overview
  Check tracking implementation health (e.g., missing click IDs, anomalies).

• Untracked Conversions Report
  Diagnose why some conversions weren’t tracked (e.g., missing IDs, duplicate entries).

• Validation Report
  See how many conversions were validated

• Adspace Attribution Scenarios
  Analyzes who would have gotten conversions for “first click” attribution and who assisted, but did not win user journeys. Needs a bit of explanation, read more here

• Basket Report
  See all your product sales: Which product is performing best? What are well performing brands?

4. How to Use Data Views

A. Navigating the Data Views UI

The Data Views interface is designed for easy access and analysis. Here’s how to make the most of it:

Key Features

1. Breadcrumb Navigation

   • Use the top-left breadcrumb trail (e.g., Dataview > Explorer > Report Name) to move between reports.

2. Filter Bar

   • Apply filters (e.g., Date, Advertiser ID) to refine data.

   • Use Clear to reset filters or Refresh to update data.

   • Use the sort function to change the order in your data
     
     

     Open

     

3. Data Table

   • Shows your report in columns (e.g., Click Count, Conversion Count).

   • Column Options (⋮): Add, remove, or reorder columns as needed.

4. Report Actions Menu

   • Found in the top-right, lets you:

     • Edit columns.

     • Export data (CSV or API).

     • Save changes (affects all users).

5. Pagination and Summary

   • Adjust rows per page or navigate between pages at the bottom.

   • See the total rows and processing time.

Open

Elements of Navigation

B. Filtering Reports

Filters help narrow down data to what’s most relevant.

• Example: Filter by Advertiser ID or Creative Type.

1. click in the field of a value, that you want to filter

2. select what you want to filter

Open

or:

1. Click the Filter menu at the top of the report.

2. Choose the dimension you want to filter (e.g., Date, Advertiser)

3. Pin filters for quick access or remove them (with the pin icon)

Open

C. Adding or Removing Columns

Customizing columns lets you focus on specific metrics or dimensions.

To remove a column:

1. Hover over the column header.

2. Click Remove.

To add a column:

1. on the top right, hover over the name of the report. You will be able to select some options, including to “Edit Columns”

2. Browse the list of available dimensions and add or remove them

   1. The data is sorted in different data sets.

   2. For quick access, you may want to use the search bar

3. Select and drag into the right position

Open

Reordering Columns

• In the function “edit columns”

• In the section selected columns you can grab and move the columns up or down

• Open

  

   

  •  

• remember to click on “apply”

• Be aware: If you hit Save changes you will save changes and change the data view (for all users who have access).

D. Adjusting Granularity

Time

Granularity determines the time intervals of your data (e.g., daily, monthly).

1. On top you find the filters for time granularity (performedAt)

2. Choose your time range (e.g. “last month”)

3. Choose from aggregation options:

   • Daily

   • Weekly

   • Monthly

Open

Granularity: Start Broad, Then Focus

Granularity in Data Views allows you to see detailed numbers (like conversions, clicks, or revenue) for every value in each column. A smart strategy is to start with a broad view, including multiple columns and values, to explore all available data. From there, you can gradually reduce granularity by:

1. Filtering for specific values (e.g., focusing on a single advertiser, category, or date range).

2. Removing unnecessary columns to simplify your view and focus on the most relevant insights.

This step-by-step approach helps you uncover patterns and refine your analysis without getting overwhelmed by too much data at once. Think of it as zooming in on the details that matter most.

E. Visualize Data

Data, trends and effects can be judged best, when seen.

• Select the “visualize trends” icon on the top right

• select (top left) what you want to see as chart, e.g. “Conversions” or “Clicks”

• In the middle select granularity (daily, monthly) or the chart type (columns, line or pie)

• On the top right you can select a second measure (e.g. comparing conversions and clicks)

• If you do a mouseover on the chart, you will see details (like numbers)

• Drawing a rectangle with your mouse to zoom in

• select rows in the table you want to see

Open

Open

Open

F. Creating a Custom Report

1. Start with a predefined report.

2. click on “duplicate” in the menu, save the report with a clear name for future access.

3. Customize by:

   • Adding or removing columns.

   • Sorting columns and renaming them.

   • Applying filters (e.g., by advertiser, date range) or pinning filters.

   • Adjusting granularity (time wise)

Open

G. Exporting Data (CSV)

Click the button with the name of the report in the menu (upper right).

Open

Export (CSV)

CSV: Download for offline use. The download will be provided via the export page

Access the export page via the displayed path on top of the page

Important: Do not “just” open in Excel, but import in Excel

Open

Handling Dataview CSV Exports in Localized Excel Versions

When you download a Dataview report as a CSV, the numerical data uses a dot (.) as the decimal separator (standard US format) and contains multiple decimal places. This high level of precision is intentional and ensures that you do not encounter rounding errors when summing up values.

However, if your computer's regional settings use a comma (,) as the decimal separator (e.g., in Germany or many other European countries), simply double-clicking the CSV file will cause Excel to misinterpret the data. To preserve the precision and format the data correctly, you should import the CSV using Excel's Power Query:

1. Open a blank Excel workbook.

2. Go to the Data tab in the top ribbon and click on From Text/CSV.

3. Select your downloaded Dataview CSV file and click Import.

4. A preview window will appear. Do not click "Load". Instead, click Transform Data (or "Edit" in older versions).

5. The Power Query Editor will open. On the right side, under Applied Steps, delete the automatic Changed Type step by clicking the X next to it. (This prevents Excel from prematurely removing the decimal dots).

6. Select the column(s) containing your high-precision numbers.

7. Right-click the column header, hover over Change Type, and select Using Locale... at the very bottom.

8. In the pop-up window, configure the following:

   • Data Type: Decimal Number

   • Locale: English (United States)

9. Click OK. Excel now understands that the dots are decimal separators and will correctly translate them into your system's format without losing any precision.

10. Click Close & Load in the top left corner to bring the clean, accurate data into your spreadsheet.

Open

English video: Importing csv in Excel

Open

German Excel Version (deutsches Video: CSV in Excel sauber importieren)

H. Get data (API)

Generate a dynamic link for integration with external tools (e.g., BI software, Excel, or custom scripts). The API link will automatically provide results based on your data view configuration.

Open

Dynamic Time Ranges & Parameters

To make data retrieval flexible, you can control the time period using URL parameters. This allows for both rolling reports and queries for fixed time spans.

1. Relative Time Ranges (Rolling)

Use predefined intervals so that the exported reports automatically update based on the current date (e.g., "The last 30 days").

• Parameter: &timePeriod=

• Available Values:

  • LAST_30_DAYS

  • LAST_60_DAYS

  • LAST_90_DAYS

2. Specific Date Ranges (Fixed)

For precise queries between two fixed points in time, the mode must be set to SPECIFIC and supplemented with start and end dates.

• Main Parameter: timePeriod=SPECIFIC

• Required Fields:

  • dateRangeFrom: Start timestamp (ISO-8601 format)

  • dateRangeTo: End timestamp (ISO-8601 format)

URL Structure Examples

6. Overview of Data Views

The Data Views Overview page provides a centralized space to manage and navigate all your reports. It displays both predefined and custom data views, allowing you to quickly access, edit, or create new reports. Here's how the page is structured:

1. Search Bar

   • The search bar allows you to quickly find specific reports by typing the name or keyword.

2. Create Button

   • The red + Create button in the upper-right corner allows you to create a new custom Data View.

   • Recommended for advanced usage only

3. Data View List

   • Each row represents an individual Data View, showing: Title, category, last edited by

4. Icons and Actions

   • People Icon: Displays how many users or groups the report has been shared with.

   • Star Icon: Mark a Data View as a favorite for quick access later.

   • Ellipsis Menu (⋮): Access advanced options such as editing, duplicating, or deleting the Data View.

7. Practical Examples

Example 1: Analyze Creative Performance by Category

1. Open the Creative Set Performance report.

2. Filter by Category and Date Range.

3. Add the Category Name column if not already visible.

4. Adjust granularity to Monthly.

5. Review performance metrics and save the report.

Example 2: Investigate Untracked Conversions

1. Open the Untracked Conversion Report.

2. Filter by Advertiser and Date Range.

3. Identify issues like missing conversion IDs or duplicate entries.

4. Export the report and share it with your team for further investigation.

8. Tips and Best Practices

• Start simple: Use predefined reports to familiarize yourself with the interface.

• Pin frequently used filters (e.g., advertiser) to save time.

• Regularly export reports for offline analysis or to share insights with stakeholders.

• Use API exports for automated data integrations.

• learn more in this video