Many sales teams run the same three Salesforce reports every week. Pipeline by stage, forecast by close month, revenue by rep. These are baseline reports and they serve a purpose, but they only use one of the four report formats Salesforce offers. Once you've enriched your contacts and leads with fields like industry, company size, title, and direct phone numbers, you can build reports that answer much harder questions. Which lead sources produce the highest close rates? Where is pipeline concentrating by geography or company size? Which enrichment fields are actually filled in across your database?
The gap isn't the data. If you're running an enrichment tool, you probably have industry, employee count, and title sitting on your Contact and Lead records right now. The gap is that most teams don't know which Salesforce report formats can use that data in a meaningful way.
We're going to walk through all four report types, explain what each one is actually good for, and show how enrichment fields change what's possible in each format.
The four report formats and what they actually do
Salesforce has four report formats: Tabular, Summary, Matrix, and Joined. Most teams live in Tabular and occasionally use Summary. Matrix and Joined are the two that unlock the interesting analysis, but they're also the two that most admins skip because the setup takes a few extra steps.
Here's the practical difference.
Tabular is a flat spreadsheet. One row per record, columns of data, a total at the bottom. If you need a list of all contacts enriched this month, Tabular works. But you can't group, you can't subtotal by category, and you can't add it to a dashboard. It's an export format, not an analysis format.
Summary reports add grouping. You can group rows by one, two, or three levels and get subtotals at each level. This is where most pipeline reports live. Group opportunities by Stage, get a sum of Amount at each stage, and you've got a basic pipeline view. Summary reports can go on dashboards and support charts, so this is where most teams stop.
Matrix reports group by both rows and columns. Think of it as a pivot table. You can put Stage on the rows and Close Month on the columns and see pipeline value in every cell of that grid. Or you can put Industry on the rows and Lead Source on the columns and see how many leads each source generates per industry. Matrix reports are the most useful format for enrichment analysis, and we'll explain why in a minute.
Joined reports combine up to five report blocks side by side. Each block can use a different report type, but they share a common grouping field. This lets you compare data across objects that don't directly relate. For example, you can put Accounts in one block and Opportunities in another, group both by Industry, and see which industries have the most customers versus the most pipeline. Joined reports support cross-block custom summary formulas, which means you can calculate ratios between blocks, like win rate by industry.
Why most teams only use one or two formats
The honest answer is that Tabular and Summary handle 80% of standard reporting needs. If all you're tracking is pipeline by stage, forecast by month, and activity counts by rep, you never need Matrix or Joined. The report builder defaults to Tabular, and converting to Summary is just dragging a field into the Group Rows section.
Matrix requires you to think about two dimensions at once: what goes on the rows and what goes on the columns. If you don't have rich data on your records, there's nothing interesting to put on the second axis. Pipeline by Stage is one dimension. Pipeline by Stage by Industry is two dimensions, and that second dimension only exists if your records actually have Industry populated.
Joined reports require even more setup. You're selecting multiple report types, building separate blocks, configuring filters per block, and then finding common fields to group across blocks. The payoff is real, but it takes 15-20 minutes to set up the first time, and most admins don't build one unless someone specifically asks for it.
This is where enrichment changes the equation. Before enrichment, your Contact records might have Name, Email, Phone, Account, and Owner. After enrichment, they might also have Title, Industry, Company Size, LinkedIn URL, and a direct dial number. Those extra fields give you something meaningful to group by, filter on, and cross-reference.
Three reports that only work with enriched data
Here's where we get practical. These are three reports we've built that require enrichment fields to be useful.
Report 1: Lead quality by source and industry (Matrix)
This report answers the question: which lead sources produce the best leads in which industries?
Set the report type to Leads with Converted Lead Information. Put Lead Source on the Group Rows. Put Industry on the Group Columns. Add Record Count as a summary and, if you have it, Converted (True/False) as a second grouping or filter.
What you get is a grid showing how many leads came from each source, broken out by industry. Turn off Detail Rows so you see just the summary grid. If you add a custom summary formula that divides converted leads by total leads, you get conversion rate by source and industry in every cell.
The formula looks like this: CONVERTED:SUM / RowCount
Without enrichment, the Industry column is empty for most leads, so the matrix collapses into a single "blank" column. With enrichment filling in Industry on your leads, you can actually see that trade shows produce great manufacturing leads but terrible SaaS leads, or that inbound web leads convert at 12% for financial services but 3% for healthcare.
Report 2: Pipeline concentration by company size (Summary with bucket fields)
This report answers the question: is our pipeline concentrated in one company size segment, or is it spread out?
Set the report type to Opportunities. Group by a bucket field based on the Number of Employees field on the related Account. Salesforce lets you create bucket fields directly in the report builder without creating a formula field on the object. You can define ranges like 1-50 (SMB), 51-200 (Mid-Market), 201-1000 (Enterprise), and 1000+ (Large Enterprise).
Add Amount as a summary (Sum), and now you can see total pipeline by company size segment. Each report can have up to 5 bucket fields with up to 20 groupings each, so you're not limited to just one dimension.
The reason this requires enrichment: the Number of Employees field on Account is almost always blank in orgs that haven't enriched. It's a standard Salesforce field, but reps rarely fill it in manually. Once your enrichment tool populates it, the bucket field has something to work with and the report becomes useful.
Report 3: Enrichment coverage audit (Summary with cross-filter)
This report answers the question: how complete is our enriched data, and where are the gaps?
Set the report type to Contacts. Add columns for the fields your enrichment tool writes to: Email, Mobile Phone, Title, Industry, and any custom fields like LinkedIn_URL__c. Group by Account Name or Owner.
To find records that are missing enrichment data, use a cross-filter or field filter. For example, filter where Mobile Phone equals blank. This shows you every contact that your enrichment tool either missed or hasn't processed yet.
You can take this further by adding a row-level formula. Salesforce lets you add one row-level formula per report that calculates on every row. Create a formula that scores enrichment completeness, something like: IF(Email != "", 1, 0) + IF(Phone != "", 1, 0) + IF(TITLE != "", 1, 0) + IF(Industry != "", 1, 0)
This gives each contact a score from 0 to 4 based on how many key fields are populated. Group by Account and average the score, and you can see which accounts have the most complete data and which need re-enrichment.
We ran this on our own Salesforce org and found that about 30% of our contacts were missing Mobile Phone even after enrichment. The issue turned out to be field-level security, not the enrichment tool itself. The data was there but our report was running as a user whose profile didn't have visibility on the Mobile Phone field. We wrote a separate post about that specific problem if you've run into it.
Setting up a dashboard that uses enrichment data
Individual reports are useful, but dashboards are where enrichment data drives ongoing decisions. Here's a dashboard layout we use that ties enrichment fields to pipeline metrics.
Component 1: Pipeline by Industry (horizontal bar chart). Source: the Matrix report from Report 1, configured to show Sum of Amount by Industry. This tells you where your pipeline is concentrated and whether you're over-indexed on one vertical.
Component 2: Lead Conversion by Source (funnel chart). Source: Summary report grouped by Lead Source with a custom summary formula for conversion rate. This tells you which channels are actually producing leads that close, not just leads that exist.
Component 3: Enrichment Completeness by Owner (gauge or metric). Source: the enrichment coverage report from Report 3, showing average completeness score by owner. This tells you which reps are working with full data and which are prospecting with gaps.
Component 4: Pipeline by Company Size (donut chart). Source: the bucket field report from Report 2. This tells you whether you're landing where you want to be in terms of market segment.
Add a dashboard filter on Owner so managers can toggle between reps. Dynamic dashboards in Salesforce let the running user see only their own data, but dashboard filters let a manager view any rep's data without switching users.
The two mistakes we see most often
Mistake 1: Building reports before checking field-level security. If the report's running user doesn't have field-level security access to an enrichment field, that field returns blank in the report even if the data exists on the record. We've seen teams conclude their enrichment tool failed when the real problem was that the SDR profile couldn't see the enriched fields. Check field-level security for every profile that runs reports, not just the admin profile.
Mistake 2: Using Tabular reports for analysis. Tabular reports can't be added to dashboards, can't use custom summary formulas, and can't group data. If you're exporting a Tabular report to Excel to build pivot tables, you're doing manually what a Matrix report does natively in Salesforce. The setup takes a few extra minutes but saves hours of recurring Excel work.
What to build first
If you're starting from zero, build the enrichment coverage report first. It tells you which fields are populated and which aren't, which directly affects whether your other reports will have useful data to group by.
Once you've confirmed your enrichment fields are populated and visible (check field-level security), build the pipeline-by-industry Matrix report. It's the single most useful report for understanding whether enrichment is translating into strategic insight.
If your team uses the Lead object, build the lead-quality-by-source Matrix report. It's the report that usually changes how teams allocate budget, because it shows which sources produce leads that close, not just leads that arrive.
Try it on a few records first
Pick 10 contacts or leads in your Salesforce. Check whether Industry, Company Size, and Title are populated. If they are, you have enough to build a meaningful Summary or Matrix report today. If they're blank, you need to enrich first, then report.
If you want to test enrichment on a small batch, ShareCo SalesSync writes to standard Salesforce fields like Email, Phone, Mobile Phone, Title, and Company. The free tier gives you 40 saves with 10 email enrichments and 3 phone enrichments a month, enough to populate a test set and build your first enrichment-driven report.