Slide 1

Slide 1 text

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

Slide 2

Slide 2 text

2 It all started 2 years ago when I started a flower blog… @KataDahlin | #brightonSEO

Slide 3

Slide 3 text

3 From 0 to 50K organic traffic in 1 year @KataDahlin | #brightonSEO

Slide 4

Slide 4 text

4 I started with affiliate marketing @KataDahlin | #brightonSEO

Slide 5

Slide 5 text

5 I connected product feeds to my blog… @KataDahlin | #brightonSEO

Slide 6

Slide 6 text

6 9500 …and soon I had product pages !!! @KataDahlin | #brightonSEO

Slide 7

Slide 7 text

7 How can I SEO-optimise these, when I don’t have enough time?! @KataDahlin | #brightonSEO

Slide 8

Slide 8 text

I started with Custom GPTs

Slide 9

Slide 9 text

9 What are Custom GPTs? Custom GPTs are your own versions of ChatGPT, that you can train with your own data & instructions. @KataDahlin | #brightonSEO

Slide 10

Slide 10 text

10 I created a custom GPT for each product brand. Fiskars GPT Iittala GPT Marimekko GPT @KataDahlin | #brightonSEO

Slide 11

Slide 11 text

11 Why? Custom GPTs can write better content than regular ChatGPT when they know the products and the brand. @KataDahlin | #brightonSEO

Slide 12

Slide 12 text

12 Less hallucinations. @KataDahlin | #brightonSEO

Slide 13

Slide 13 text

13 The right tone of voice. @KataDahlin | #brightonSEO

Slide 14

Slide 14 text

14 Reduce copy pasting! @KataDahlin | #brightonSEO

Slide 15

Slide 15 text

How I create Custom GPTs for product descriptions

Slide 16

Slide 16 text

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

Slide 17

Slide 17 text

17 Build your Custom GPT Instructions: https://katarinadahlin.com/ custom-gpts-product-desc riptions/ https://chatgpt.com/gpts/ editor @KataDahlin | #brightonSEO

Slide 18

Slide 18 text

18 Context & instructions Provide well-defined instructions and basic info about the context, task, language, styling, etc. @KataDahlin | #brightonSEO

Slide 19

Slide 19 text

19 Tell the Custom GPT to never hallucinate and to always ask for more info if needed. @KataDahlin | #brightonSEO Reduce hallucinations

Slide 20

Slide 20 text

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

Slide 21

Slide 21 text

21 Prompt (part 2/4) Rewrite the text. Make it about 400 words long. Start with info about the product. @KataDahlin | #brightonSEO

Slide 22

Slide 22 text

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

Slide 23

Slide 23 text

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

Slide 24

Slide 24 text

24 Before @KataDahlin | #brightonSEO

Slide 25

Slide 25 text

25 After @KataDahlin | #brightonSEO

Slide 26

Slide 26 text

26 I optimised 400 products with Custom GPTs in 5 weeks @KataDahlin | #brightonSEO

Slide 27

Slide 27 text

27 Number of words ranking 1-10 in Google for 400 optimised products @KataDahlin | #brightonSEO

Slide 28

Slide 28 text

28 115 more words in position 1 in Google @KataDahlin | #brightonSEO

Slide 29

Slide 29 text

29 156% more organic clicks after 5 weeks @KataDahlin | #brightonSEO

Slide 30

Slide 30 text

30 It takes 5 min per product to optimise like this → good @KataDahlin | #brightonSEO

Slide 31

Slide 31 text

31 → good, but it still takes too much time ;) @KataDahlin | #brightonSEO

Slide 32

Slide 32 text

I moved this process to Make

Slide 33

Slide 33 text

33 Why? Automate the workflow. @KataDahlin | #brightonSEO

Slide 34

Slide 34 text

34 No copy pasting. @KataDahlin | #brightonSEO

Slide 35

Slide 35 text

35 No writing them one by one. @KataDahlin | #brightonSEO

Slide 36

Slide 36 text

36 Save time. @KataDahlin | #brightonSEO

Slide 37

Slide 37 text

37 Optimise large amounts in a short time. @KataDahlin | #brightonSEO

Slide 38

Slide 38 text

38 Result = 3500 product descriptions in one day @KataDahlin | #brightonSEO

Slide 39

Slide 39 text

39 …or 40 product descriptions in 5 mins @KataDahlin | #brightonSEO

Slide 40

Slide 40 text

40 Connect apps like Google Sheets with ChatGPT & build workflows. No need to know Python or any coding language ;) Make.com @KataDahlin | #brightonSEO

Slide 41

Slide 41 text

41 How does it work? Instructions: https://katarinadahlin.com/make-product-description-automation/ @KataDahlin | #brightonSEO

Slide 42

Slide 42 text

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

Slide 43

Slide 43 text

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

Slide 44

Slide 44 text

44 2. The prompts & messages with ChatGPT goes here @KataDahlin | #brightonSEO

Slide 45

Slide 45 text

45 ChatGPT reads the first Google Sheet & writes a long product description. @KataDahlin | #brightonSEO

Slide 46

Slide 46 text

46 3. The new product description will be added to a second Google Sheet here. @KataDahlin | #brightonSEO

Slide 47

Slide 47 text

47 Result: Long description @KataDahlin | #BrightonSEO

Slide 48

Slide 48 text

48 4. ChatGPT reads the first Sheet again & writes a short product description. @KataDahlin | #brightonSEO

Slide 49

Slide 49 text

49 5. And implements the results in a third Google Sheet. @KataDahlin | #brightonSEO

Slide 50

Slide 50 text

50 Result: Short description @KataDahlin | #brightonSEO

Slide 51

Slide 51 text

51 When product descriptions are ready → import everything to your site @KataDahlin | #brightonSEO

Slide 52

Slide 52 text

52 For wordpress sites → All Import - WooCommerce Import Add-On Pro -plugin Instructions: https://katarinadahlin.com/all-import-product-descriptions-wordpress/ @KataDahlin | #brightonSEO

Slide 53

Slide 53 text

53 💡 When you’ve tested your prompts and the automation and it works – schedule it and do something else! @KataDahlin | #brightonSEO

Slide 54

Slide 54 text

Bonus tip

Slide 55

Slide 55 text

55 We want as implementation-ready product descriptions as possible. If you don’t get the result you want… @KataDahlin | #brightonSEO

Slide 56

Slide 56 text

56 → Show examples in the prompts, instead of telling too much about how to do it! @KataDahlin | #brightonSEO

Slide 57

Slide 57 text

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

Slide 58

Slide 58 text

58 In summary Start by building a Custom GPT & prompts @KataDahlin | #brightonSEO

Slide 59

Slide 59 text

59 When it’s working well, move it to Make & automate it @KataDahlin | #brightonSEO

Slide 60

Slide 60 text

60 Work with examples to get good output @KataDahlin | #brightonSEO

Slide 61

Slide 61 text

Katarina Dahlin Speakerdeck.com/katarinadahlin/brightonseo-2024 Linkedin.com/in/katarina-dahlin katarinadahlin.com @KataDahlin Youtube.com/@KatarinaDahlinSEO Senior Growth Hacker & SEO Consultant, Genero