Customertimes How To: Building Better Salesforce Reports
By Evan Natelson - August 5, 2021
The interconnected, multitenant environment of Salesforce increases the amount of data available to be analyzed. Salesforce Reports are an invaluable tool in that data analysis lifecycle, with aggregation capabilities that deliver critical insight into new business trends or quickly alert you to data quality or management issues.
In addition, a great report is an immense value-add for any profession as it provides actionable insights the enable a business to pivot – or stay the course – confidently.
But before you begin making technical implementation decisions, you need a solid plan for your reports.
- What are the long and short-term goals?
- How will you measure progress?
- What types of data do you need to know?
- At what point will these metrics be determined as successful or failures?
- How should this data be delivered?
In order to create high-quality, useful reports, I’d encourage you to consider two things:
- Which technical requirements are necessary to get strategic results
- How the user will view the report to benefit from the insights and trends in the data
First, let’s take a look at some of the most common and helpful technical components in Salesforce Reports.
Technical Components
Custom Objects & Fields – Facilitate the ability to collect underlying data. For example, a junction object is needed to collect prescription information and connect patients to medication records.
Cross Filters – Quickly identify records with or without related records. For example, Accounts without Contacts helps identify users that aren’t following proper data etiquette.
Custom Report Types – Combine complex object relationships (up 4 objects) or expose fields from other objects via the Add Related via Lookup option. For example, create an account with opportunity, with opportunity product, or with product report to understand the accounts that choose certain families of products.
Buckets – Visualize a group of values within a picklist field in a ‘bucket’ that only applies to that report. For example, group into region based on the account’s country.
Custom Summary Formulas – Create formulas driven by that report’s data and use functions relative to the report’s groupings: PARENTGROUPVAL and PREVGROUPVAL. For example, report on sales compared to a goal, or summarize values within a date grouping.
Joined Reports – Show blocks of different data points from up to 5 reports in one screen. For example, see sales from this month, this year, and the last 12 months in one report view.
Field-to-Field Filters – Filter reports by the dynamic field values of related fields in the report instead of by static values. For example, filter a data set to only show the records where the actual cost of a campaign is less than the total value of won opportunities.
Unique Values – Summarize how many unique objects are in your report. For example, how many accounts are in your opportunity pipeline (in which the major sorting is done by stage)?
Now that you know what the options are, here are some tips for making your reports easy to understand.
Usability to Maximize Understanding
Use Conditional Highlighting – Draw the eye to the key information presented in the report by using color based on field values. For example, a pipeline report that highlights opportunities in jeopardy of slipping can be easily identified.
Organize with the Appropriate Structure – Salesforce provides 4 types of reports: Tabular, Summary, Matrix, and Joined:
✔️ A Tabular report displays 0 groupings and is basically a list. This kind of report is ideal where you are reporting on an object that is not aggregated – for example reporting on an object that has no connections.
✔️ Summary reports allow up to 3 vertical groupings – for example a report showing all contracts that are about to expire and grouped by the manager of the owner of the contract, the owner of the contract and the territory of the account.
✔️ Matrix reports can have 2 vertical groupings and 2 horizontal groupings. An example is a pipeline report where the vertical groupings are Territory and then Owner of the Opportunity, the horizontal groupings are stage and product, and the values represented in each cell of the table is the expected amount. These cells can then be summarized vertically and horizontally.
✔️ A Joined report inserts up to 5 distinct reports on the same report and enables the alignment of common fields. For example – comparing Converted Lead & Won Opportunity data to a campaign’s Total Won Opportunity value.
Remove Clutter – When presenting data, a simple, direct message showing correlations tells a readily digestible story. Remove unnecessary fields and summaries (“Record Count”) and anything else that distracts from the main story of the report.
Group Data into Meaningful Time Periods – Salesforce allows dates to be sorted by day, week, month, and quarter. It may be hard to look at a pipeline report where each opportunity is displayed by its close date, so try showing opportunity values by quarter to make it more effective.
Consistency across Reports Builds Familiarity – Salesforce allows you to create report charts, which provide a great bird’s eye view of the main data trends. However, if the same report has been duplicated to show different date ranges and the colors of the reported segments change, it’s difficult to understand that the reports are actually displaying the same criteria, just with different date ranges. The “Assign Fixed Colors to Picklist Values” administrative feature will resolve this issue.
Delivering Meaning Adds Relevance to Salesforce – Salesforce Reports can be emailed according to a schedule, so stakeholders receive data insights in a timely manner. For example, if a weekly task update meeting is regularly scheduled for Tuesdays at 2 PM, Salesforce can be set to email a report of your past week’s tasks, sorted by the contact and date, an hour before the meeting.
Don’t Leave Insight on the Table
Without the aggregation, summarization, and visibility that Salesforce Reports offer, the data captured and stored in Salesforce’s myriad tables and fields is merely a record of actions performed.
But if you’re regularly using, updating, and reviewing your reports, you’ll have the foresight to take measured actions and effectively guide your business forward.
Evan Natelson is a Salesforce Consultant at Customertimes. He has more than 14 years of Salesforce experience in Administrator, Business Analyst, Project Manager, and Consultant roles and has been awarded 5 Salesforce certifications.

Talk to an expert!
If you need help building better Salesforce reports, we'd love to chat! Reach out to us here.
Email an Expert-fm-converted.png)
Alimera Sciences Boosts Productivity with CT Mobile
-fm-converted.png)
Brian Borack Joins Customertimes as Chief Operating Officer
-fm-converted.png)
Xactly & Customertimes Improve Sales Performance Management
-fm-converted.png)
Meet the Women of Customertimes
-fm-converted.png)
Orkla Automates Territory Alignment with CT Mobile & CT CPG
-fm-converted.png)
Meet the Women of Customertimes
-fm-converted.png)
ISG Names Customertimes a Salesforce Ecosystem Leader
-fm-converted.png)
Propel Goes Global with PDO and Managed Services
-fm-converted.png)
Meet the Women of Customertimes
-fm-converted.png)
Choosing the Ideal PDO Partner
-fm-converted.png)
Customertimes Launches The Give Back to Ukraine Fund
-fm-converted.png)
CT Software Announces New Consumer Health Projects
-fm-converted.png)
The Top 5 QA Testing Metrics
-fm-converted.png)
UMMC Uses Salesforce Health Cloud to Improve Pediatric Psychiatric Care
-fm-converted.png)
Minimizing the Impact of Log4j and Other Java Vulnerabilities
-fm-converted.png)
DFG152 is Live on Salesforce AppExchange
-fm-converted.png)
A Year of Giving
-fm-converted.png)
Leverage the power of Salesforce automation with CT Orders
-fm-converted.png)
New Product Idea? 5 Things to Look for in a Salesforce PDO
-fm-converted.png)
A Sharp USA Customer Success Story
-fm-converted.png)
Organic Growth: Building an Agile, Scalable Salesforce Team
-fm-converted.png)
Open to Hire? 5 Ways to Deal with a Staffing Shortage
-fm-converted.png)
The Transformation Guidebook
-fm-converted.png)
CT Vision is now live on Salesforce AppExchange
-fm-converted.png)
Unlock Customer-Centric Growth with the World's #1 CRM
-fm-converted.png)
[On-Demand] Growing a Profitable Salesforce Practice
-fm-converted.png)
Launch Excellence in a Post-Pandemic World
-fm-converted.png)
A Sirenum Customer Story
-fm-converted.png)
Making a Switch: 5 Things to Consider When Switching Salesforce Partners
-fm-converted.png)
Customertimes Announces Expanded Salesforce Industries Practice
-fm-converted.png)
Use case of CT Mobile for Consumer Packaged Goods - Beiersdorf
-fm-converted.png)
Customertimes How To: Uniting Sales Cloud and Service Cloud
-fm-converted.png)
Bench Strength, and Other Introductions
-fm-converted.png)
Meet Alexis: Introducing Our PepUp Tech Intern
-fm-converted.png)
Customertimes How To: Building Better Salesforce Reports
-fm-converted.png)
Stand Out: Overcoming Digital Fatigue in a Crowded Marketplace
-fm-converted.png)
Connecting Image Recognition Technlogies to the Salesforce Ecosystem with CT Vision
-fm-converted.png)
[On Demand] Launch Excellence in a Post-Pandemic World: The right Life Sciences ...
-fm-converted.png)
Customertimes Announces Strategic Partnership with Blue Consulting
-fm-converted.png)
Expanding Our Reach, Building Our Communities
-fm-converted.png)
Discover CT: Anna Andreieva
-fm-converted.png)
Discover CT: Sergey Selivanov
-fm-converted.png)
CT Orders Whitepaper
-fm-converted.png)
Giving Back Is in Our DNA
-fm-converted.png)
Customertimes is Awarded Three Best in Class Distinctions in POI’s 2021 Retail S...
-fm-converted.png)
Discover CT: Dmitry Selkov
-fm-converted.png)
Discover CT: Denny Gracey
-fm-converted.png)
Automating Order Management with CT Orders
-fm-converted.png)
ISG Names Customertimes a Rising Star
-fm-converted.png)
Bitcoin Is Just the Beginning: How Blockchain Will Revolutionize Data Collection...
-fm-converted.png)
Two Major Challenges of AI Adoption for Enterprises
-fm-converted.png)
Commercial Launch Enablement for Emerging Life Sciences Companies
-fm-converted.png)
The Holy Grail of Customer Engagement: A True 360° View
-fm-converted.png)
Strategies to Maximize Your CRM/CX Investments
-fm-converted.png)
CRM: It's a Journey not a Event
-fm-converted.png)
Women in Tech: Angel Di Legge Kokoszka
-fm-converted.png)
Efficiency vs. Effectiveness: Getting the Right Things Done
-fm-converted.png)
Women in Tech: Svetlana Makhlysheva
-fm-converted.png)
Customertimes and PepUp Tech announce support for the Pennsylvania Innocence Pro...
-fm-converted.png)
Improve the Human Element of Your CX for More Emotional Connections
-fm-converted.png)
James Goldfinger Joins the PepUp Tech Board
-fm-converted.png)
Customertimes and Competera Announce Strategic Partnership
-fm-converted.png)
Women in Tech: Maria Karandin
-fm-converted.png)
Back to the Future – Dusting Off the Old Playbook for Salesforce in Healthcare
-fm-converted.png)
Bringing a Product to Market: An Interview with Park Capital’s Alex Lopatine
-fm-converted.png)
Women in Tech: Tahuana Cirati
-fm-converted.png)
DevOps Strategy: A Journey to Efficiency
-fm-converted.png)
Megatrends in Customer Experience Webinar | Customertimes, Edify, Verint, eGain
-fm-converted.png)
Introducing Women in Tech: Meet the Inspiring Women of Customertimes
-fm-converted.png)
CT Orders - Sales automation with easy order taking
-fm-converted.png)
Sharp and Customertimes | A Salesforce Implementation Story
-fm-converted.png)
A Look at Marketing's Biggest Data Challenges of the 2020s
-fm-converted.png)
What makes a successful CRM Journey
-fm-converted.png)
Customertimes Partners with PepUp Tech to Train a New Generation of Salesforce P...
-fm-converted.png)
Customertimes welcomes Sergey Zinin as Global VP of Verticals and Business Consu...
-fm-converted.png)
PepUp Tech Announces New Partnership with Customertimes
-fm-converted.png)
How do you build a high-performing, cost-effective CRM technology team?
-fm-converted.png)
Сustomertimes Achieves Salesforce Master Navigator Status for Delivering Experti...
-fm-converted.png)
Customertimes and Propel Announce Global Strategic Partnership
-fm-converted.png)
Is It Time to Revise Your Business Continuity Plan?
-fm-converted.png)
Customertimes Achieves Salesforce Master Navigator Status for Delivering Experti...
-fm-converted.png)
Customertimes Continues to Expand
-fm-converted.png)
Customertimes achieves Salesforce Master Navigator status for delivering experti...
-fm-converted.png)
Choosing a Software Product Development Partner: Why Strategy, Customisation, an...
-fm-converted.png)
The power of CRM's and post COVID-19 technology adoption | Jim Goldfinger
-fm-converted.png)
Let Data Be Your Guide: Adapt to Become Digital First
-fm-converted.png)
Customertimes Cares: Making Strides to Help Our Communities in Eastern Europe
-fm-converted.png)
Salesforce and Tableau – the perfect combination for these challenging times
-fm-converted.png)
Rethinking HCP Interaction in the Midst of the New Normal
-fm-converted.png)
Improving marketing engagement using actionable intelligence
-fm-converted.png)
My 2019 Trailblazer Story
-fm-converted.png)
CV-19 highlights the importance of digital transformation
-fm-converted.png)
The Evolution from Systems of Engagement to Systems of Agility
-fm-converted.png)
The Next Normal for Life Sciences Sales Calls
-fm-converted.png)
Never a Better Time to Give Back and to Put Life in Perspective
-fm-converted.png)
CT partners with Salesforce in a time of need for Health Care providers
-fm-converted.png)
Data is the New Oil
-fm-converted.png)
Lessons learned from my years as the CEO of Customertimes
-fm-converted.png)
Why do you love working with Customertimes?
-fm-converted.png)
Where is the real value in CRM?
-fm-converted.png)
What makes Customertimes different?
-fm-converted.png)
Salesforce World Tour 2019
-fm-converted.png)
Lightforce : sharing experience Salesforce / Customertimes
-fm-converted.png)
CT Mobile for a global beauty company | WELLA
-fm-converted.png)
PDI - CT Mobile
-fm-converted.png)
CT Pharma / CT Mobile - May 2018
-fm-converted.png)
CT Mobile Use Case for Luxury Goods - Cartier
-fm-converted.png)
Rethinking Your Open Banking Journey with MuleSoft
-fm-converted.png)
Customertimes Solution for Life Sciences
-fm-converted.png)
Customertimes is recognized by Promotion Optimization Institute in the Vendor Pa...
-fm-converted.png)
Customertimes at MEDICA/COMPAMED 2014 – Düsseldorf
-fm-converted.png)
CT Mobile - Full Featured Sales force Offline
-fm-converted.png)
CT Mobile - Salesforce Based CLM Solution for Your Business
-fm-converted.png)