Explore your data from multiple perspectives using pivot tables. You can calculate, summarize, and analyze data by seeing comparisons, patterns, and trends in your data. You can also create custom reports without using query formulas, such as SQL queries.
A common use case for using pivot tables in Marketing Cloud Intelligence Data Pipelines is to validate your data and ensure that it’s loading correctly from the source into MDP and that the values are aggregating correctly. After you create a pivot table, you can export it locally or turn it into a scheduled report.
- MDP Create a Pivot Table from Scratch
Use a pivot table to explore and extract data. - MDP Create a Pivot Table Using a Data Stream
Create a pivot table using a data stream to base it on already-defined measurements and dimensions. - MDP Manage Pivot Tables
Edit, duplicate, and delete pivot tables in Marketing Cloud Intelligence Data Pipelines.