Science fiction becomes reality! Now we can communicate and use things every day that we were used to seeing in movies.
One of the recent revolutionary technologies is ChatGPT, which changes the way we work A LOT!
As a programmer, at first I didn’t think it could handle more complex tasks, but I was surprised to see how useful it could be in my daily life. So I started playing and found ways that I found useful and wanted to share.
Here are five examples of ChatGPT and useful ways SEO professionals and marketers can use it for everyday marketing tasks.
Compose Regular Expressions In Analytics Reporting
Regular expressions can be used to generate analytical reports such as Google Search Console or Google Analytics. Regular expressions are one of the most boring tasks I know, and it can really slow things down. It’s even harder for marketers because they don’t have a technical background.
Let’s look at an example of GSC reporting that supports regular expression filtering.
Screenshot of Regexp’s GSC query filter, January 2023
If you’re a marketer with no technical background, you might find it hard to use this feature and be limited to some basic regexps you’ll find by searching development forums.
Now you have ChatGPT at your disposal!
Just go to ChatGPT and ask: “build a case-sensitive regular expression starting with ‘How’ or ‘What is’ using RE2 syntax”
Screenshot of ChatGPT’s response, January 2023
It got the job done instantly. Just copy and paste into the GSC filter field and you’ll have any query that can be optimized for a FAQ or HowTo scheme.
Screenshot from GSC report, January 2023
You can also use it to build regexp for GA reports. For example, let’s say you want to filter a report that has the words “Samsung” and “phone” in its URL. Just ask ChatGPT to “construct a regular expression containing the words ‘Samsung’ and ‘phone’ using RE2 syntax, case sensitive.”
Just to note, it’s important to mention “RE2 syntax” in the command, as Google reporting dashboards support this syntax.
Compose Complex Spreadsheet Formulas
All work with Excel or Google Spreadsheets. It’s in everyone’s daily work, and you know how hard it is sometimes to create spreadsheet formulas because you have to research the name of the function you need and then spend 10-15 minutes figuring out how to make it work.
Now you just need to ask ChatGPT for a command like: “Google Page Formula that copies all rows from page 1 where column ‘A’ contains the word ‘iphone'”.
And it didn’t take long to find a solution.
Screenshot of Google Spreadsheet formula created by ChatGPT, January 2023
But the formula it gives =QUERY(Sheet1!A:Z, “SELECT * WHERE A CONTAINS ‘iphone'”, “Sheet2!A1”) has a small error. Of course, ChatGPT doesn’t always give 100% correct answers. You should check and fix manually sometimes. The formula I got is 99% correct except that the 3rd parameter shouldn’t be there. So I removed it manually and now I have =QUERY(Sheet1!A:Z, “SELECT * WHERE A CONTAINS ‘iphone'”) which works perfectly!
Setup Custom Pixel Conversions
If you’re a PPC marketer or SEO professional who wants to set up custom conversions when users take certain actions on your website, but you don’t have the help of a web developer, this can be quite difficult in some situations. Yes, you can use Google Tag Manager for many cases where users click on a link, but you may need a different one that is not a built-in feature of GTM.
For example, you need to send a conversion event when they reach your landing page and scroll through 35% of the page. Now you don’t need to hire a developer to get the job done. Just go to ChatGPT and ask “Send Facebook pixel custom conversion event once users scroll 35% of page using JavaScript” and it will do the magic!
Screenshot of running JavaScript code from a custom Facebook pixel event, January 2023
You can copy and paste this code into your <head> HTML tag and you’re done. If you have a WordPress site, you can use plugins like WPCode to make things easier. Alternatively, you can use Google Tag Manager’s custom HTML tag to add your own JavaScript code.
It saves you time to find a developer for small daily tasks or even if you have a developer. team, you can significantly reduce their workload by doing it yourself.
Optimize FAQ and Featured Snippets
SEO professionals may need help getting related questions from users to optimize content for a specific keyword. You can use ChatGPT to ask these related questions to make your content more useful. If you have a travel blog, you can ask: Related questions about “Cozy cities in Germany” and ChatGPT ask a lot of questions that really make sense.
Screenshot from ChatGPT Keyword Research, January 2023
Of course, there can be useless ones, but they do 90% of the work. The questions it suggests may not have search volume, but they are still worth following because keywords with zero search volume can generate significant traffic.
Fetch Data from APIs and Coding
Let’s say you have a WooCommerce Store and you want to bring all your products with their prices into a Google Spreadsheet. Now you can simply ask: “Google app script to get all product names and prices from the WooCommerce REST API and insert into a spreadsheet” and you’re good to go.
This gave me fully working code:
Sometimes this can produce code with a small error that you need to fix manually, as in the Google Spreadsheet formula example above.
Conclusion
ChatGPT’s encoding capability is particularly useful when working with Zapier. If you’ve ever used Zapier, you know that it has a Zap called “code” for advanced users. If you have data in some ugly format that needs to be fixed right away, you can simply ask ChatGPT to fix it and use it in Zapier’s custom code to clean up the data.
It is said that ChatGPT will replace people and many occupations will simply die out. In my personal opinion, it won’t happen, but it will make life easier in different industries and professions.