Use deal and employee data in one report to track how many deals each sales agent creates. Set up the table to compare sales performance across your team.

Add data sources to Looker Studio

1. Go to Analytics > BI analytics.
2. Click Connect Google Looker Studio.

Connect Google Looker Studio

Looker Studio will open in a new tab. Add the data source tables one at a time: Deals and Employees.
Description of entity fields in BI Analytics

How to blend data sources

1. In Looker Studio, click Create and select Report.
2. Open the My data sources tab.
3. Select a source and click Add.
4. Select the table and click Blend Data.
5. Add another table with deal data.

Configure dimensions

For the Employees table, add these fields:

• Unique Key
• User Name

For the Deals table, add:

• Created by ID

Configure the join

1. Click Configure Join.
2. Set the following parameters:

• Join operator: Select Left outer.
  This join shows all employees, including employees without deals.
• Join conditions: Select the fields used to match rows between tables.
  In this example:
  • Unique key from Employees
  • Created by ID from Deals

3. Save the blended data.

Set up table metrics

1. To display employee names in the table, drag the User name field to dimensions.
2. To add a column with the number of deals:
   • Click Add metric
   • Select Add field
3. Enter the metric name, select the data type, and add a formula.

Example formula for the total number of deals:

The table now shows how many deals each employee created. It also helps you identify employees who have not created any deals.