Hello, this is Chris from Clickpower. I wanted to contribute something to the SEO community, so I decided to whip up this brief video. I always come across fascinating tips on the internet, hence the idea to develop this video.

I’ve recently been conducting a health audit on a client’s website, where, as seen, there are 152 issues with duplicate title tags. Traditionally, we would manually create these, or devise a formula to expedite the process. However, with the rise of AI, we’ve begun exploring alternative solutions.

Before I began optimisation, I discovered a plugin for Google Sheets, named GPT for Sheets and Docs. If we open it, it appears in the sidebar. To provide a quick rundown of this spreadsheet, the URLs are in the first column, the existing page titles in the second, and the newly created titles are in the third.

To shed a little light, the green titles indicate those that have been made live on the client’s website, while the yellow ones are those we’ve created in the spreadsheet but have yet to go live. However, as you can see, there are still many titles to create, and several duplicates are evident.

Upon examining the first column, the URL section, unique identifiers can be found within these URLs, such as the manufacturers, wheel size, style, colour, and part numbers. Consequently, I decided to create a custom prompt to write an optimised metadata title, ensuring uniqueness with no matching titles.

To put this into action, one can use column A to find potential keywords. This could be the wheel’s colour, style, or size. Then, we strictly use 50 to 60 characters, including spaces. Below, there’s another drop box where the column for new results can be chosen, and then one can select how many rows to populate, or simply select all rows.

Once satisfied, click run. Upon installation of this plugin, a certain amount of free tokens is provided, or additional tokens can be bought at a reasonable price. Looking at our results, the duplicated titles have been replaced with unique ones, each including styles, colours, and other details specified in the prompt.

I’ll now go through manually to ensure that all the information is accurate and corresponds to the correct page URL. The goal is to make sure they all read well and can potentially enhance the click-through rate on the website.

I hope you found this video helpful. If you did, please click the ‘like’ button. Thank you very much.