Artificial Intelligence (AI) may speed up Amazon sellers’ decisions by helping them analyze sales trends, predict future revenue, and optimize operations. Defog empowers sellers to connect their data with AI models like ChatGPT efficiently. In this article, we will walk through an example of identifying top SKU combinations to understand customer purchasing behavior better using the OpenAI Large Language Model (LLM). 

Defog is a tool designed to simplify data analysis for Amazon sellers. It connects directly to Amazon Seller Central and Amazon Advertising, automatically retrieving valuable data and organizing it in Google Sheets. Defog empowers sellers to effortlessly gain actionable insights by cleaning and preparing this data for AI.

One of the most significant analyses a seller must do is understand customer purchasing behavior. Sellers can optimize inventory management and marketing strategies by monitoring how customer purchases shift over time and identifying frequently purchased product pairings. With the help of prompts, Defog enables sellers to generate precise results, making data-driven decisions more effortless than ever.

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 prompt. 

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 that Google Drive will present. After that, you can upload data from Google Drive to ChatGPT. Easy, isn’t it?!

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 – Defog.”

Using ChatGPT to generate the most purchased SKU combinations

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

I need help analyzing the OrdersTable worksheet. The goal is to generate a table with two columns: one is the list of unique combinations of SKUs purchased by customers and the other one is the count of customers who purchased each combination - the order in which a customer bought two or more SKUs does not matter - meaning "SKU2, SKU10" is the same as "SKU10, SKU2". Please create the table as described without single SKUs; we are only interested in customers who have bought more than one different SKU. Sort the final table by the number of customers in descending order.

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

Visit this article if you want to create a dashboard in Google Sheets to see the top SKU combinations your customers purchase instead of using 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. Learn more about combining Defog with AI in this article here. 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.