You are here:
Review Pipeline Data with Pivot Tables in Marketing Intelligence
Verify mapped pipeline data in Salesforce Report Builder. Compare measurements, group results by dimension, apply filters, add a chart, and export the report.
Marketing Intelligence automatically filters each new pivot table to include data from the pipeline where you created it. If mapped fields are available, the report includes these default dimensions and measurements.
| Data Pipeline Type | Dimensions | Measurements |
| Delivery | Date, Campaign Name | Impressions, Clicks, Spend |
| Conversions | Date, Campaign Name | Conversions, Revenue |
| Delivery Verification | Unified Date, Campaign Name | Viewable Impressions, Verifiable Impressions |
| Web Analytics Event | Date, Website Page Hostname | Website Total Events, Website Visits |
| Web Analytics Page | Date, Website Page Hostname | Website Page Views |
If the pipeline doesn’t include the default dimensions and measurements, Marketing Intelligence adds Date and all mapped measurements to the report.
In Report Builder, you can:
- Add or remove row groupings and measurements
- Narrow summarized results with aggregate filters
- Show subtotals and a grand total
- Add a chart and select a chart value to filter the report results
- Drill down into grouped results Save, run, and export the report
For Data 360 report availability, behavior, and limits, see Data 360 Reports and Dashboards: Limits and Limitations. For general Report Builder information, see Reports.
- Create a Pivot Table in Marketing Intelligence
Verify that pipeline data is mapped and processed correctly before you use it in dashboards and other analyses.
