Managing an Amazon store’s performance can be overwhelming, especially with vast amounts of sales and customer data to analyze. By knowing which products attract new customers, Amazon sellers can optimize their advertising efforts and decide on product pricing and promotion to maximize organic growth. This article will explore how Defog, through its seamless integration with Amazon Seller Central and the support from ChatGPT, helps sellers identify which products bring in the most new customers.

Artificial Intelligence (AI) transforms how Amazon sellers manage and analyze sales data, helping them uncover valuable trends and forecast customer demand. With tools like Defog, sellers can seamlessly integrate Amazon Seller Central data into ChatGPT and analyze their sales information. This automation enables sellers to efficiently track which products attract the most new customers and identify patterns in their purchasing behavior.

This is what the results of this article will look like:

One good thing about doing this in Defog’s spreadsheet is that as soon as Defog updates the data, you will have the latest information about your customer behavior as the answer if you repeat the query in ChatGPT. 

ChatGPT – Setting Up Google Sheets Integration

Step 1: To facilitate the data upload from Defog to ChatGPT, we suggest you connect your ChatGPT with Google Drive. Here is how to set up this integration. Start by clicking on the paper clip icon and then click on Connect to Google Drive (see images below):

Follow the login and authorization process presented by Google Drive. Then, you can upload data from Google Drive to ChatGPT.

ChatGPT – Upload Your Defog from Google Drive

Step 2: Now that you have connected your Google Drive with ChatGPT, click on the paper clip icon again and then click Add from Google Drive.

Choose your Defog on Google Drive. In this example, we will use a Defog named “Joe’s Coffee Store – Defog.”

Using ChatGPT to generate a chart of the top 10 SKUs that attracted more new customers

Step 3: Copy and paste the prompt below into your ChatGPT and press send.

I need help analyzing the OrdersTable worksheet to learn which SKUs attract more new customers. The goal is to generate a histogram chart showing the percentage of the total number of unique customers who purchased the same first SKU. For example, 70% of customers bought SKU 2 first, 8% bought SKU 4 first, etc. Please create the chart. Sort the chart by the descending order of customer percentage. Show only the top 10 SKUs that attracted more new customers.

After ChatGPT analyzes the data, you will get a result like the one below.

Visit this article if you want to create a dashboard that persists in Google Sheets to track monthly advertising and organic sales trends without relying on ChatGPT.

If you want to learn what a particular column stands for on Defog’s tables, please visit our glossary.

Thank you for reading this post. If you still haven’t used Defog, you can do so for free here.

If you need any help, we are here for you.

Disclaimer: Defog is not responsible for any decisions made by the reader of this post regarding the data, formulas, and visuals provided.