...
| Table of Contents | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
1.
...
What
...
is Data Views?
Data Views is a
...
new, flexible reporting system
...
Why the Change?
Traditional reporting systems lacked the flexibility and speed required for in-depth analysis. Data Views is powered by BigQuery’s cube structure, allowing real-time data aggregation and seamless interaction with vast datasets, even across extended time ranges.
...
Key Benefits:
Speed: Reports are generated instantly, no matter the dataset size.
Flexibility: Filter, customize, and drill down into data like never before.
Comprehensiveness: Access dimensions and metrics (e.g., creative paths, categories) previously unavailable.
Actionability: Easily share insights via export or API.
2. How Data Views Work
Technology Overview:
Data Views leverages a cube structure built on BigQuery. This structure aggregates data dynamically, making it possible to deliver granular reports at lightning speed.Key Features:
Dynamic filtering and pinning of dimensions like advertiser ID.
Adding or removing columns for personalized reporting.
Granularity adjustments (e.g., daily, monthly views).
Export options including CSV files and API integrations.
Data Logic:
Data is pulled from core system sources (e.g., clicks, conversions, creative performance) and structured into predefined and customizable views. The system handles complex calculations, such as tracking anomalies or attribution metrics, without slowing performance.
3. Navigating the Interface
Overview of the Interface:
...
Main Dashboard: Access predefined reports such as creative performance or tracking details.
Filters: Apply pin filters (e.g., advertiser-specific views) to focus on relevant data.
...
click on a value you would like to filter. Then select Filter by this value
...
click on a column name you would like to have as a filter on top. Select Pin Filter
...
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
Accessing Data Views
Log in to your platform and navigate to the Reports or Data Views section.
Choose a predefined report (e.g., Creative Set Performance, Tracking Details) or create a custom one.
...
3. Available Data Views
Here are the main predefined reports you can use:
Creative Set Performance by Partner
Analyze how specific creative sets 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).
...
4. How to Use Data Views
A. Filtering Reports
Filters help narrow down data to what’s most relevant.
Example: Filter by Advertiser ID or Creative Type.
click in the field of a value, that you want to filter
select
filter by this value
| Info |
|---|
Tip: clicking on a value to filter by it is the easiest and quickest way to filter data! |
...
or:
Click the Filter menu at the top of the report.
Choose the dimension you want to filter (e.g., Date, Advertiser)
Pin filters for quick access or remove them as needed.
| Info |
|---|
Tip: Pinned filters appear at the top of your report for easier reference and as easy to use filter option. |
...
B. Adding or Removing Columns
Customizing columns lets you focus on specific metrics or dimensions.
To remove a column:
Hover over the column header.
Click Remove.
To add a column:
on the top right, hover over the name of the report. You will be able to select some options, including to “Edit Columns”
...
...
Browse the list of available dimensions and add or remove them
The data is sorted in different data sets.
...
For quick access, you may want to use the search bar
...
Select and drag it into your report.
...
Reordering Columns
In the function “edit columns”
If you select the tab “order” you can
change the order of columns
rename columns
remember to click on “preview the changes”
Be aware: If you hit
Save changesyou will save changes and change the data view (for all users).
Step-by-Step Navigation:
Open the Data Views tab from the main dashboard.
Choose a predefined report or create a custom one.
Use filters and column tools to tailor the view to your needs.
Save the report or mark it as a favorite for quick access.
4. Available Data Views (Models)
Creative Set Performance by Partner: Understand how specific creatives and partners contribute to conversions.
Tracking Detail Overview: Monitor the health of your tracking setup, identify missing attributes (e.g., click IDs), and detect anomalies.
Untracked Conversion Report: Diagnose why conversions weren’t tracked (e.g., missing conversion ID or duplicate entries).
Granularity and Metrics: Each model supports flexible granularity (daily, monthly) and a variety of metrics like partner performance, category details, and attribution data.
5. Creating Custom Data Views
Custom Reports:
Add new columns from the available fields (e.g., category, creative set path).
Remove unnecessary columns to declutter your view.
Reorder columns to prioritize key metrics.
Best Practices:
Start with predefined reports to familiarize yourself with available data.
Gradually explore and add new dimensions for a deeper analysis.
6. Sharing and Exporting Data Views
Sharing Options:
Mark reports as favorites for team access.
Share with defined users or teams within the system.
Exporting:
Export as CSV for offline analysis or reporting.
Generate API links for automated data integration with external systems.
Dynamic Time Ranges: Time-based filters update automatically in exports or API calls, ensuring your reports remain relevant.
7. Use Cases and Examples
Example 1: Filtering Performance by Advertiser
Select “Creative Set Performance.”
Apply a pin filter to view data for a specific advertiser.
Adjust the granularity to monthly for a long-term overview.
Example 2: Diagnosing Untracked Conversions
Open the “Untracked Conversion Report.”
Identify reasons for missing conversions (e.g., duplicate entries).
Export the data for investigation and resolution.
8. Future Developments
Upcoming features include:
Period comparison tools for year-over-year analysis.
Enhanced models with richer data dimensions.
New functionalities like anomaly detection and deeper tracking integration.
9. Summary and Next Steps
...
...
C. Adjusting Granularity
Time
Granularity determines the time intervals of your data (e.g., daily, monthly).
On top you find the filters for time granularity.
Choose from options like:
Daily
Weekly
Monthly
...
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:
Filtering for specific values (e.g., focusing on a single advertiser, category, or date range).
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.
...
D. Creating a Custom Report
Start with a predefined report.
Customize by:
Adding or removing columns.
Applying filters (e.g., by advertiser, date range).
Adjusting granularity.
Save the report with a clear name for future access.
...
E. Exporting Data
Click the Export button in the menu.
Choose the format:
CSV: Download for offline use.
API Link: Generate a dynamic link for integration with external tools.
Dynamic Time Ranges: Exported reports automatically update with the selected time range (e.g., "This Month").
...
5. Practical Examples
Example 1: Analyze Creative Performance by Category
Open the Creative Set Performance report.
Filter by Category and Date Range.
Add the Category Name column if not already visible.
Adjust granularity to Monthly.
Review performance metrics and save the report.
...
Example 2: Investigate Untracked Conversions
Open the Untracked Conversion Report.
Filter by Advertiser and Date Range.
Identify issues like missing conversion IDs or duplicate entries.
Export the report and share it with your team for further investigation.
...
6. 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
| Widget Connector | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|