Loading
Einstein and Analytics in Marketing Cloud Engagement
Table of Contents
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

          Search all of Salesforce Help
          Pivot Tables Overview

          Pivot Tables Overview

          Pivot tables allow you to explore your data from multiple perspectives. You can calculate, summarize, and analyze data by seeing comparisons, patterns, and trends in your data. With pivot tables, you can create custom reports without the need for query formulas, such as SQL queries.

          Required Editions

          Available in: Intelligence Reports and Intelligence Reports Advanced

          For a detailed explanation of the metrics featured in pivot tables, see Dimensions and Measurements.

          For more information about pivot tables, click these links:

          Note
          Note Emails configured to Suppress from Send Reports aren't included in Intelligence Reports.
          • Out-of-the-Box Pivot Table Examples
            By default, Intelligence Reports for Engagement comes with five out-of-the-box pivot table examples. These examples help you get started so you can see how the most common pivot tables are configured and set up. You can use them as is, copy and then adjust them, or even delete them if they‘re not required.
          • Create a Pivot Table in Intelligence Reports
            Use a pivot table to explore and extract data. For example, you can get sends and open rates for all your emails to see how well a specific email performed. You can also export a pivot table locally or use it to create a scheduled report.
          • Customize a Pivot Table in Intelligence Reports
            You can change the data that is displayed in a pivot table, show or hide columns, and make other customizations.
          • Export a Pivot Table in Intelligence Reports
            You can export a pivot table as a report and run it as part of a workflow in real time or on a defined schedule. You can also export to an Excel file, for example, and share it with others.
          • Manage Pivot Tables in Intelligence Reports
            You can manage pivot tables in Intelligence Reports for Engagement after you create them. You can edit, duplicate, and delete existing pivot tables.
          • Apply Filters to a Pivot Table
            Add filters to a pivot table to narrow down the data and focus on what’s relevant to your use case. For example, add a filter to focus on a specific email name instead of all the emails in the campaign. Or filter by a campaign name to focus on that campaign.
           
          Loading
          Salesforce Help | Article