How to optimise 3,500 product descriptions for ecommerce in one day using ChatGPT

In this BrightonSEO October 2024 deck, Katarina discusses how to use ChatGPT and Make to optimise product descriptions at scale for eCommerce. Learn how to automate the process, reduce manual effort, and improve Google rankings while driving organic traffic.

Transcript

1. How to Optimise 3,500 Product Descriptions for eCommerce in One Day Using ChatGPT Katarina Dahlin Genero Speakerdeck.com/katarinadahlin/brightonseo-2024 Linkedin.com/in/katarina-dahlin @KataDahlin
2. 2 It all started 2 years ago when I started a flower blog… @KataDahlin | #brightonSEO
3. 3 From 0 to 50K organic traffic in 1 year @KataDahlin | #brightonSEO
4. 4 I started with affiliate marketing @KataDahlin | #brightonSEO
5. 5 I connected product feeds to my blog… @KataDahlin | #brightonSEO
6. 6 9500 …and soon I had product pages !!! @KataDahlin | #brightonSEO
7. 7 How can I SEO-optimise these, when I don’t have enough time?! @KataDahlin | #brightonSEO
8. I started with Custom GPTs
9. 9 What are Custom GPTs? Custom GPTs are your own versions of ChatGPT, that you can train with your own data & instructions. @KataDahlin | #brightonSEO
10. 10 I created a custom GPT for each product brand. Fiskars GPT Iittala GPT Marimekko GPT @KataDahlin | #brightonSEO
11. 11 Why? Custom GPTs can write better content than regular ChatGPT when they know the products and the brand. @KataDahlin | #brightonSEO
12. 12 Less hallucinations. @KataDahlin | #brightonSEO
13. 13 The right tone of voice. @KataDahlin | #brightonSEO
14. 14 Reduce copy pasting! @KataDahlin | #brightonSEO
15. How I create Custom GPTs for product descriptions
16. 16 Data I scrape product & category descriptions and 'About Us' pages with Screaming Frog, then upload the data as a CSV file to the GPT. Instructions: https://katarinadahlin.com/scrape-content-screaming-frog/ @KataDahlin | #brightonSEO
17. 17 Build your Custom GPT Instructions: https://katarinadahlin.com/ custom-gpts-product-desc riptions/ https://chatgpt.com/gpts/ editor @KataDahlin | #brightonSEO
18. 18 Context & instructions Provide well-defined instructions and basic info about the context, task, language, styling, etc. @KataDahlin | #brightonSEO
19. 19 Tell the Custom GPT to never hallucinate and to always ask for more info if needed. @KataDahlin | #brightonSEO Reduce hallucinations
20. 20 Prompt (part 1/4) Product name: [paste you product name here] You are now Fiskars SEO-copywriter GPT. You write in finnish. Info: See database. @KataDahlin | #brightonSEO
21. 21 Prompt (part 2/4) Rewrite the text. Make it about 400 words long. Start with info about the product. @KataDahlin | #brightonSEO
22. 22 Prompt (part 3/4) Then, create a short text with the subheading: "For what work is [product name] good for?". Then, create a short text with the subheading "For who is [product name] suitable for?". @KataDahlin | #brightonSEO
23. 23 Prompt (part 4/4) Subheadings are formatted as H2. Format everything as html. SEO-optimize the texts and subheadings for the product name. @KataDahlin | #brightonSEO
24. 24 Before @KataDahlin | #brightonSEO
25. 25 After @KataDahlin | #brightonSEO
26. 26 I optimised 400 products with Custom GPTs in 5 weeks @KataDahlin | #brightonSEO
27. 27 Number of words ranking 1-10 in Google for 400 optimised products @KataDahlin | #brightonSEO
28. 28 115 more words in position 1 in Google @KataDahlin | #brightonSEO
29. 29 156% more organic clicks after 5 weeks @KataDahlin | #brightonSEO
30. 30 It takes 5 min per product to optimise like this → good @KataDahlin | #brightonSEO
31. 31 → good, but it still takes too much time ;) @KataDahlin | #brightonSEO
32. I moved this process to Make
33. 33 Why? Automate the workflow. @KataDahlin | #brightonSEO
34. 34 No copy pasting. @KataDahlin | #brightonSEO
35. 35 No writing them one by one. @KataDahlin | #brightonSEO
36. 36 Save time. @KataDahlin | #brightonSEO
37. 37 Optimise large amounts in a short time. @KataDahlin | #brightonSEO
38. 38 Result = 3500 product descriptions in one day @KataDahlin | #brightonSEO
39. 39 …or 40 product descriptions in 5 mins @KataDahlin | #brightonSEO
40. 40 Connect apps like Google Sheets with ChatGPT & build workflows. No need to know Python or any coding language ;) Make.com @KataDahlin | #brightonSEO
41. 41 How does it work? Instructions: https://katarinadahlin.com/make-product-description-automation/ @KataDahlin | #brightonSEO
42. 42 1. The data needed for optimising the product is in a Google Sheet: URL, Product name, and short info about the product @KataDahlin | #brightonSEO
43. 43 Use the info you get from the manufacturer. Scrape the brand site if it’s not enough data for the prompts to work. @KataDahlin | #brightonSEO
44. 44 2. The prompts & messages with ChatGPT goes here @KataDahlin | #brightonSEO
45. 45 ChatGPT reads the first Google Sheet & writes a long product description. @KataDahlin | #brightonSEO
46. 46 3. The new product description will be added to a second Google Sheet here. @KataDahlin | #brightonSEO
47. 47 Result: Long description @KataDahlin | #BrightonSEO
48. 48 4. ChatGPT reads the first Sheet again & writes a short product description. @KataDahlin | #brightonSEO
49. 49 5. And implements the results in a third Google Sheet. @KataDahlin | #brightonSEO
50. 50 Result: Short description @KataDahlin | #brightonSEO
51. 51 When product descriptions are ready → import everything to your site @KataDahlin | #brightonSEO
52. 52 For wordpress sites → All Import - WooCommerce Import Add-On Pro -plugin Instructions: https://katarinadahlin.com/all-import-product-descriptions-wordpress/ @KataDahlin | #brightonSEO
53. 53 💡 When you’ve tested your prompts and the automation and it works – schedule it and do something else! @KataDahlin | #brightonSEO
54. Bonus tip
55. 55 We want as implementation-ready product descriptions as possible. If you don’t get the result you want… @KataDahlin | #brightonSEO
56. 56 → Show examples in the prompts, instead of telling too much about how to do it! @KataDahlin | #brightonSEO
57. 57 Detailed guides & videos - How to scrape content from a website with screaming frog https://katarinadahlin.com/scrape-content-screaming-frog/ - How to build custom GPT:s for product descriptions https://katarinadahlin.com/custom-gpts-product-descriptions/ - Make product description automation setup example https://katarinadahlin.com/make-product-description-automation/ - How to all import all product descriptions in bulk with WP All Import plugin https://katarinadahlin.com/all-import-product-descriptions-wordpress/ @KataDahlin | #brightonSEO
58. 58 In summary Start by building a Custom GPT & prompts @KataDahlin | #brightonSEO
59. 59 When it’s working well, move it to Make & automate it @KataDahlin | #brightonSEO
60. 60 Work with examples to get good output @KataDahlin | #brightonSEO
61. Katarina Dahlin Speakerdeck.com/katarinadahlin/brightonseo-2024 Linkedin.com/in/katarina-dahlin katarinadahlin.com @KataDahlin Youtube.com/@KatarinaDahlinSEO Senior Growth Hacker & SEO Consultant, Genero