In this article, we’ll show you how to display data from your Salesforce reports on your Geckoboard dashboards.
Salesforce reports are a powerful tool for making sense of all the data available within your Salesforce account. Our Salesforce data source makes visualizing your Salesforce reports really easy: First, you create the reports in Salesforce first and then build visualizations using those reports in Geckoboard.
To connect your Salesforce data to Geckoboard, you must be on a Pro plan.
In order to use Salesforce with Geckoboard, you need to have a Salesforce edition that allows for API access. Any of the following editions would work:
Creating reports in your Salesforce account
For a more detailed guide to creating reports, see Salesforce's documentation.
Geckoboard currently doesn't support the use of row level formulas, field to field filters or recognise any fields introduced on reports with unique counts.
Limitations of our Salesforce data source
Our Salesforce data source can only:
Visualize data from Custom Reports
Salesforce provides a collection of standard reports by default. These will not show up in Geckoboard, and you cannot visualize data from them on your dashboards.
You can create a custom report by either building a new report from scratch, or by customizing an existing standard report to your requirements.
Support Summary, Tabular and Matrix reports
Create a custom Summary or Matrix report for tracking the metrics you're interested in — just as you'd normally do in Salesforce. Geckoboard will then be able to pull in and display those metrics on your dashboards.
If you'd like to use Joined reports, drop us a line and let us know how they'll be useful to you.
Additionally, make sure that you:
- Save your reports in a folder that your Salesforce user account has access to (i.e. the one connected to Geckoboard), or under public folders. Geckoboard cannot read private reports that your Salesforce user doesn't have access to.
- Run reports each time you create a new report or make changes to an existing one. Use the Save and Run Report option within Salesforce.
Grouping your report data
The data within your reports need to be aggregated using groups to be plottable in a chart.
So, regardless of whether you’re using a Summary or Matrix report, you’ll need to have at least one grouped field (column) within your Salesforce report. Otherwise, you’ll receive an error such as
Cannot read property 'xAxis' of undefined or similar depending on your browser. You can find more details in our Salesforce troubleshooting article.
Summary reports can have up to three groupings while Matrix reports can have four (two row and two column groupings). For Matrix reports, you can't use the same field for both row and column groupings.
Grouping your report data will also automatically provide you with the record count metric (number of items) for each group.
If you group your report by a date field, you can click the group menu, select Group Dates By, and specify the grouping time frame: day, week, month, quarter, year, etc.
Summarizing your report data
Showing the record count (number of items) for each group is useful, but often you’re interested in other metrics as well – for example, the total sales value or average probability.
This is where summarizing your report data comes into play. Any numeric property can be added as a summary field. The report builder in Salesforce gives you the choice Sum, Average, Min, or Max.
Summary fields show at all grouping levels (that is, for each group within your report + even if there are multiple groupings). In Summary and Matrix reports, they also appear at the grand total level.
How Salesforce reports connect with Geckoboard
The grouped fields from your report act as the base while the summary fields act as the metrics. That is, you can plot a summary metric against a grouped field.
- Line Charts, Column Charts, and Bar Charts: Grouped fields will be available as the X-Axis options, while Summary fields as the Y-Axis options.
- Leaderboards: Grouped fields will be available as the 'Labels' options and Summary fields as the corresponding 'Values'.
- Number and Gecko-O-Meter: As these widgets can display only numerical data, they display values from just the summary fields. The value displayed will be the summarized metric (i.e. Sum, Avg, Min, Max) calculated based on all the records available within the report. For example, the metric displayed can be Sum of Total Sales Amount, Average Probability, Maximum Price, etc.
Let’s say you have a Salesforce report (can be either Summary or Matrix) with the following Grouped fields: Opportunity Owner, Stage and the following Summary fields: Amount (sum), Probability (avg), Number of Employees (avg). The report preview would look something like this:
You’ll then have options to plot within your Geckoboard widgets:
On all widgets, the Record Count (number of items) summary metric will always be available for each grouped field within your report.
Line, Column, and Bar Charts
X-Axis options: Opportunity Owner, Stage
Y-Axis options: Sum of Amount, Average Probability, Average Number of Employees, Record Count
Labels: Opportunity Owner, Stage
Values: Sum of Amount, Average Probability, Average Number of Employees, Record Count
Number and Geck-O-Meter
Metric: Sum of Amount, Average Probability, Average Number of Employees, Record Count
Now that you have a good grasp of how things work, let’s build the widget in Geckoboard
Build and display an example Salesforce widget on your dashboard
- Click Add widget, located in the top right of your dashboard.
- Search for Salesforce using the Search sources field.
Alternatively, you can also scroll down the alphabetical list of data sources until you reach the Salesforce data source.
- Click on the Salesforce data source.
- If you haven’t already, you’ll be prompted to connect your Salesforce account to Geckoboard.
We do not support custom domains.
- You'll now see the Choose Report page, which displays the list of your Salesforce reports folders. You can use the Search field or manually navigate through the folders to your chosen report. Click on the report.
- The widget configuration page will show up — this is where you actually build your widget.
Select the visualization from the top right. You'll see a preview of the widget.
Using appropriate visualizations can make a world of difference while consuming your dashboards and can help inspire action. We’ve created this handy flowchart which makes it easy to identify the best visualization for the metric you're looking to display.
- If required use the toggle switch to set a Goal and fill in your Goal value. You can also specify whether it's a Less than and More than Goal.
On the Number widget, you'll have the option to Track % progress toward the Goal. While on the Geck-O-Meter, you'll have options to also specify the min. and max. values.
- Next, click on the
The 'Units' field supports emojis too!💰😉
tab, towards the top-left, to configure abbreviations, decimal places, and units. You can leave these at their default Auto settings if things already look good.
- Once you’re happy with how your widget is previewing, switch back to the tab.
- From near the bottom-left, specify how often you want this widget to refresh. It'll also let you know how many API calls the widget will use per day. You'll need to specify the refresh rate for each Salesforce widget you add.
We have a useful guide which explains how to choose an appropriate refresh rate and offers some suggestions on how you can optimize and reduce the number of API calls used by your Geckoboard widgets (especially helpful if you have a lot of Salesforce widgets on your dashboards).
- At any point, while configuring your widget you can , , and . Any changes you've made within your report will be picked up and fetched immediately into the widget. This is especially handy when initially building the widget or while testing things.
- When you're happy with all the widget settings, click Add dashboard.
- Hover over your newly created widget and add a widget title.
- Adjust its size.
And you're done! You now have a widget on your dashboard displaying metrics from your Salesforce account 💥
Now that you're comfortable with adding Salesforce widgets, we'd recommend checking out the following articles: