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 more information about pivot tables, click these links:
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.
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.
Did this article solve your issue?
Let us know so we can improve!
Loading
Salesforce Help | Article
Cookie Consent Manager
General Information
Required Cookies
Functional Cookies
Advertising Cookies
General Information
We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required Cookies
Always Active
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional Cookies
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising Cookies
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.