You can add dynamic targets or goals for individual representatives, teams, or regions to better measure how your sales are trending against targets. Using your sales data and a Google Sheets, Excel, or CSV data source, you can create joins to compare your targets and sales.
Skill level : Beginner
Time : 10 minutes
- A Salesforce Opportunity table or another data source containing sales data.
- Google sheet, Excel file, or CSV.
Creating your targets
After you import your sales data, you will then need to add another data source containing your targets. This example uses Google Sheets to manage targets, but you can use an Excel or CSV file as well. For information on formatting Excel and CSV files, see Excel and CSV best practices .
- Create a new Google Sheet, Excel, or CSV file.
Add columns containing your sales representatives and their targets. You can also add in any other attributes, as long as you abide by the formatting guidelines.
Note: If your data includes representative IDs, you can use the IDs as a join key. If your data doesn't include IDs, then you can use the representative name as the join key, as long as it's the same in both sources.
- After you have finished entering in your targets, save your file, and return to your interface.
- In the Data sources library, click + New .
- Click the icon matching your data source.
- Name your connection Sales Targets.
Select the file or sheet containing your targets. This example uses Google Sheets, so the data source Info step would resemble the image below.
- Click Next .
- Select a storage option. For information on the different storage options, see Selecting a storage option .
You will automatically be redirected to the Query Builder.
Joining your data
To use your sales and target data in the same query, you must join the two data sources. This section will discuss how to blend your sales and targets datasets. After you add your Sales Targets connection, you will automatically be redirected to the Query Builder. For more information on using the Query Blender, see Creating joins with the Query Blender .
- In the Query Builder, click the Query Blender icon ( ).
- Select your Salesforce Opportunities table or your Sales data source from the (Select a data source) drop-down list.
Click and drag from one half-circle on the side of your Sales Targets data source box to a half-circle on the Opportunities data source box.
Select a common attribute to use as your join key from the
Select a field
drop-down list. This example uses Name, but you could use any common attribute between your representatives, such as ID.
- Click Add condition .
Note: A right join is used to ensure that there is always data. If you use an inner or left join, and a representative doesn't make a sale over a given time frame, they will not be visible in your query.
- Click Ok .
- Click Save .
Your two data sources will be joined. You can then use information from both data sources in your query.
Creating a visual to measure how reps trend against targets
After you finish joining your two data sources, you can begin to create queries to measure how your representatives are trending against your targets. This section contains a simplified example to show you the possibilities of using targets in your reports. If your representatives have different targets each month, you will need to have separate rows for each month and representative.
- Add your Sales metric from your Salesforce or Sales data source. You can add filters to only show results from specific values, such as opportunities won or deals.
- Add your Target metric from your Sales Targets sheet.
- Add your sales representative name or ID as an attribute.
- Select a chart type. The example below uses a bar chart.
This is just one example of how you can use targets in your reports. You can adapt the same principles to your own report to create dynamic comparisons.