Find Your Regular Customers With One Order Spreadsheet and ChatGPT

At a glance

This video shows how online store owners can use an order history spreadsheet and ChatGPT to find their regular customers. The spreadsheet only needs four columns: buyer ID, order date, payment amount, and product name.

Key points

• To protect privacy, the name and phone number columns are removed before the file is uploaded.
• One year of order data is entered, and ChatGPT divides customers into three groups by how recently, how often, and how much they bought.
• Finding the first product that regular customers bought is the key step.
• The video suggests spending more ad budget on the core products that turn customers into regulars, not on discount bait items that mostly attract one-time buyers.

Why it matters

It can help online store owners who are unsure where to spend their advertising budget.

More from this field

• Claude Whiteboards, Sheets and Data: What Works Now

  This video tries out Claude's new whiteboard, sheet (spreadsheet), and data features to see which ones are actually useful. It also asks whether there is a reason to move from Google Sheets.

  The AI Advantage · Nov 14, 08:57 KST
• Amazon Plans Index of Online Product Data Across the Web

  Amazon reportedly plans to gather data on products sold anywhere online, including items it does not sell, and show it on its own site, according to Reuters. The project would cover products beyond Amazon's own catalog.

  The Verge · Nov 14, 08:49 KST
• Theo Retracts Praise for Gemini 4 Carbon Over Severe Response Delays

  This video is from the Theo (t3.gg) channel. Theo corrects his earlier mild review of Gemini 4 Carbon and covers the response delays he found in real-world use. Gemini 4 Carbon is an AI model from Google.

  Theo - t3.gg · Nov 14, 08:45 KST
• TSMC Leak Exposes 46,000 Staff Records; Hackers Demand Bitcoin

  Personal data of about 46,000 current and former TSMC employees in Taiwan was leaked and offered for sale on underground forums. The sellers threatened to publish it within a week if no buyer appeared.

  코인리더스 · Nov 14, 08:32 KST