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 is to validate your data and ensure that it’s loading correctly from the source 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.
- Create a Pivot Table from Scratch
Use a pivot table to explore and extract data. - 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. - Manage Pivot Tables
Edit, duplicate, and delete pivot tables in Marketing Cloud Intelligence.