How to Analyze Sales Performance with GPT

Last Modified: August 21, 2023 - 5 min read

Hannah Recker
Discover how to analyze sales performance using Google Sheets and AI.

The ability to analyze sales performance at any moment in time is vital for any business.

High-performing sales and revenue leaders rely on this to quickly identify key insights for strategic decision making on a day-to-day basis. However, slicing and dicing data to visualize this information can be complex, time-consuming, manual, and repetitive.

In the attempt to make data-driven decisions, most run into blockers such as:

  • Native reporting limitations in SaaS systems
  • The need to analyze data that lives in multiple systems
  • Manual data refreshes in spreadsheets
  • Lack of advanced spreadsheet skills

Fortunately, it’s easy to leverage and blend live data, schedule automations, and use AI in Google Sheets to streamline the entire process!

In this example, we’ll walk through importing live data into Google Sheets and using GPT in Sheets to analyze sales performance by product category, and even break it down further by salesperson, all within Google Sheets.

Watch our video guide below for a quick overview of the sales analysis process with Google Sheets and AI. Use it as a visual aid as you follow the step-by-step guide.

Step-by-Step Example: Product Performance by Salesperson and Revenue Analysis

Coefficient is a free Google Sheets add-on that allows you to connect your business systems to Google Sheets and pull real-time data into your spreadsheet.

It has several powerful AI features that help with a wide range of analyses, like the one we’ll walk through shortly.

To install Coefficient, open your spreadsheet and click Extensions on the menu bar ‘Add-ons’ -> ‘Get add-ons.’

Install Coefficient for the first time

Once the Google Workspace Marketplace launches, search for “Coefficient” and select the Coefficient app.

coefficient data connector in the google workspace marketplace

Press ‘Allow’ to grant Coefficient access to your Google account.

grant coefficient permissions to your google account

Wait a few moments for the installation to finish, then return to your spreadsheet menu.

Click Extensions -> Coefficient -> Launch.

Launch Coefficient from the extensions menu

Coefficient will appear on the sidebar of your Google Sheet. Next, we will connect Google Sheets to Snowflake.

Click ‘Import from…’ on the Coefficient sidebar menu.

Import data from the main menu

Select ‘Snowflake’ as your data source.

Select Snowflake as your data source

From there, you can choose to import your data from ‘Tables & Columns’ or a Custom SQL Query.

two options to import data from snowflake

Select the data you need to perform your analysis. In this example, ‘Date,’ ‘Sales Person,’ ‘Product Category,’ and ‘Sales Revenue.’ This data will be imported into a new tab in your spreadsheet.

You’ll have the ability to set this import on automatic refresh in your cadence of choice or refresh manually by clicking on the ‘Refresh’ button in the top row.

Manually add the sales person and total sales revenue columns

To start the analysis, create a table summarizing the sales revenue by salesperson. This is done using the Coefficient’s Formula Builder to generate the appropriate formulas.

From the Coefficient menu, click ‘GPT Copilot.’

Create a table using GPT Copilot

Select ‘Formula Builder.’

Select formula builder

Next, describe the formula you want to build: “Get a unique list of values in B starting at row 3.”

Click ‘Build’ to generate your formula. Copy the formula from the output and paste it into the cell under Sales Person to apply it.

copy the formula into the select data range

We’ll repeat this process for sales revenue.

Coefficient Excel Google Sheets Connectors
314,000 Pros Sync Live Data from Their Business Systems into Spreadsheet

Stop exporting data manually. Sync data from your business systems into Google Sheets or Excel with Coefficient and set it on a refresh schedule.

repeat the process for total sales revenue

Copy the formula and paste it into the cell under Sales Revenue.

Use Autofill to apply your formula to each row

Quickly format your data by adding dollar signs.

Quickly format your data

You can also remove decimals.

Remove unnecessary zeros

Next, let’s break down the amount of sales by salesperson and product category using the Pivot Builder.

Return to the GPT Copilot menu and click on Pivot Builder.

select pivot builder from the GPT Copilot menu

Next, you’ll want to select the range of data you want to use.

Pro tip: Delete the end reference (‘14’), and the Pivot Builder will automatically grab your data!

select the data range for analysis

Once your data range is selected, you can describe the pivot you wish to visualize: “Group by salesperson, then by product category, and show total of sales revenue.”

Click ‘Build.’

Describe the pivot table you wish to build

Select where you want to insert your pivot table. In this example, choose to insert your table in a new sheet.

Insert your pivot table into a new sheet

Select the tab, and you’ll see your data organized by Sales Person, Product Category, and Sales Revenue by Product Category.

A view of sales revenue by sales person and product category

Note: If you wish to see a breakdown of product category first instead of salesperson, simply repeat the same process as before. This time you will modify the prompt to read “Group by product category, then by salesperson, and show the total sales revenue and count of sales revenue.”

Pivot by product category

Insert your pivot table into a new sheet once more to see the result.

A view of sales revenue by s product category

And just like that, you’ve explored how you can use Coefficient’s GPT Copilot to help build formulas and pivot tables.

Analyze Sales Performance Across Product Lines and More with Coefficient + AI

Coefficient helps bring your sales analysis to the next level by harnessing the power of AI and Google Sheets. Here, we walked through how to analyze sales performance by product category, salesperson, and revenue with ease and efficiency, but this is only one of many use cases.

Get started with Coefficient for free today to learn more!

Sync Live Data into Your Spreadsheet

Connect Google Sheets or Excel to your business systems, import your data, and set it on a refresh schedule.

Try the Spreadsheet Automation Tool Over 350,000 Professionals are Raving About

Tired of spending endless hours manually pushing and pulling data into Google Sheets? Say goodbye to repetitive tasks and hello to efficiency with Coefficient, the leading spreadsheet automation tool trusted by over 350,000 professionals worldwide.

Sync data from your CRM, database, ads platforms, and more into Google Sheets in just a few clicks. Set it on a refresh schedule. And, use AI to write formulas and SQL, or build charts and pivots.

Hannah Recker Growth Marketer
Hannah Recker was a data-driven growth marketer before partying in the data became a thing. In her 12 years experience, she's become fascinated with the way data enablement amongst teams can truly make or break a business. This fascination drove her to taking a deep dive into the data industry over the past 4 years in her work at StreamSets and Coefficient.
350,000+ happy users
Wait, there's more!
Connect any system to Google Sheets in just seconds.
Get Started Free

Trusted By Over 20,000 Companies