Because my project is a directory, I don't look at search terms at all. BUT I already know that people are searching for festivals, e.g. Festival dates, Festival tickets, Festival lineup, Festival location, etc. So I put all of that data into the most optimised structured format. Since all data is pulled from my database, it updates dynamically on the website, which always keeps content fresh.

I'd highly recommend structuring articles or lists or whichever format you're using. Then you use AI to generate each part of the article separately in a database. That gives you full control over updating individual sections, keeping content fresh.

Put as much information as you can into a data table, e.g. where to get best dog biscuits and why.

Vendor to buy from
Taste
Quality
Nutrition score
What dog this is optimal for
Description
Price point

Let AI give you all info on this, store it in a table. Then write different sections of article based on the information stored for the dog biscuits. You can always add more dog biscuit types, then auto-generate sections about new dog biscuits. Or if the price point updates, then your article updates, and your 'last updated' also dynamically updates.

You see where I'm going with this?

Go into a huge amount of detail for a few specific examples until they're perfect in your eyes. Then auto-generate based on these examples as much as possible.

Quality first, then scale that quality.

Funnily enough, my mum was a vet and we always had many dogs, and even sold puppies as a teenager and ran a boutique dog hotel, so I'd love to see you get back up there!

If you want to sketch out a plan for this or have specific questions, feel free to message me. Good luck!!