Salesforce Cross-Object Reporting by Sales Rep

Salesforce cross object reporting by sales rep

Cross-object reporting is one of the things that Salesforce is just not designed to do.  It frustrates sales leaders, sales ops people, and anyone else that’s looking to build meaningful reports to assess sales performance.  This post talks about what cross-object reporting is, and how you can make it happen.

What is Cross-Object Reporting in Salesforce?

Cross-object reporting is building a report that takes data from multiple Salesforce objects and presents that data in the same report.  For example, building a report that shows the number of leads created, tasks created and opportunities created by sales rep is a cross-object report.  

Why is Cross-Object Reporting useful?

There is huge value in cross-object reporting because it tells you the full story of what a sales rep is doing, rather than just showing data from one object at a time.  And, once you’re able to pull data from multiple Salesforce objects into the same report, then you can start looking at more advanced metrics that really shine a light on what’s going on.  For example, you might want to report on the number of calls that each of your reps is making (Tasks), as well as how many opportunities they’ve created (Opportunities). Once you have that data in the same report, you can now create a ratio to figure out how many calls it takes for a rep to open an opp.

What are some workarounds for Cross-Object Reporting?

The usual workaround to get cross-object reports for your Salesforce data is to pull data out to Excel.  This requires multiple Salesforce reports to be run (one from each object), and exported to Excel, and then all of those reports to be joined together manually.  It’s time consuming and not very dynamic -- if you want to look at a different date range for example, you would need to create a whole new spreadsheet.

Cross-Object Reporting with Salesforce data: Use Sales Rep Scorecards

Rekener Sales Rep Scorecards is an app designed to do Cross-Object reporting with Salesforce data.  The Sales Rep Scorecard app automatically produces amazing cross-object reports that let you see data from any object, by sales rep.  So you can see in one concise table, how many calls, emails, demos, opps, deals and bookings each of your sales reps has -- over any time period.  It’s incredibly simple, yet powerful.

Cross-object reporting with Salesforce data

What else can you do with Cross-object reporting?

Once you can pull multiple Salesforce objects into the same place, you can do other cool things.  For example, creating ratios between metrics from different objects (like calls divided by demos to figure out how many calls it takes a rep to set a demo).  Or, you can create scores for your sales reps. Scoring reps means you want to assign a weight to different metrics, and then multiply the weight times the value, to get an overall score.  So, for example, calls might be worth a point, demos worth 2 points, and opps worth 3 points. Then, for each rep, you can multiply their metrics by their weights to see an overall score that lets you stack rank the team.

Learn more:

  1. Here is a great white paper about Tracking Sales Rep Targets with Rekener.

  2. Check out this blog post on Leading Indicators for Sales Managers to Track

  3. Request a demo of Rekener's Sales Rep Scorecards application.

  4. Start a free trial by connecting your Salesforce or HubSpot CRM account.

Add new comment

Your comment will appear soon!

Gregory Keshian

Greg is COO and Co-Founder at Rekener. Greg’s career has been focused on using data to grow recurring revenue businesses. Before joining Rekener, he served as VP of Operations at ZeroTurnaround, where he built its strategy and operations practice, ran customer success and renewals, helped to grow and coach its high-velocity sales organization, and optimize its marketing efforts. Prior to that, he ran the BizOps and marketing functions for the AVOKE call center analytics business, a SaaS company within BBN Technologies. He got his start using data to improve sales and marketing efforts while at AppNeta. Greg is also a member of the Revenue Collective.

Sales Rep Scorecards

Rekener Sales Rep Scorecards is the quickest and easiest way to get all of your sales rep reporting done...period.

Learn More


Get the best BizOps content delivered to your inbox twice a month.