Science fiction becomes reality! Now we can interact and use things that we used to see in movies every day.
One of the latest revolutionary technologies is ChatGPT, which will change the way you work A LOT!
As a programmer, at first I didn’t think it could solve advanced tasks, but I was surprised to see how helpful it can be in my daily life. So I started playing around and found ways that I found useful and wanted to share.
Here are five ChatGPT examples and useful ways SEO professionals and marketers can use it for their daily marketing work.
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 down your work. For marketers, it’s even tougher because they don’t have a technical background.
Let’s look at an example GSC report that supports regular expression filtering.
Screenshot of GSC Query Filter by Regexp, January 2023
If you’re a marketer with no technical background, you might find this feature difficult to use and limit yourself to the basic regular expressions you can find by searching development-related forums.
Now you have ChatGPT at your fingertips!
Go to ChatGPT and ask: ” Write a case-sensitive regular expression for ‘How’ or ‘What is’ using RE2 syntax”
Screenshot of ChatGPT response, January 2023
He got the job right away. Copy and paste it into GSC’s filter area, and you’ll have all the queries that are candidates for optimization in the FAQ or HowTo scheme.
Screenshot of GSC report, January 2023
You can also use it to complete a regular expression for GA reports. For example, let’s say you want to filter a report that contains the words “Samsung” and “phone” in the URL. Simply ask ChatGPT: Complete a case-sensitive regular expression for the words “Samsung” and “phone” using RE2 syntax.”
Note, it is important to mention “RE2 syntax” in the command, as Google’s reporting dashboards support this syntax.
Compose Complex Spreadsheet Formulas
Everyone works with Excel or Google Sheets. It’s in everyone’s daily work life, and you know how hard it is sometimes to complete spreadsheet formulas because you have to research to find the function name you need and then spend 10-15 minutes figuring out how it works.
Now you just need to ask ChatGPT a command: “Google Sheet formula that copies all rows in sheet1 where column ‘A’ contains the word ‘iphone'”.
And it didn’t take long to get the solution.
Screenshot of Google Sheet Form created by ChatGPT, January 2023
But the formula that returned =QUERY(Sheet1!A:Z, “SELECT * WHERE A CONTAINS ‘iphone'”, “Sheet2!A1”) has a small error. Of course, ChatGPT does not always provide 100% correct answers. Sometimes you should check and fix it manually. The formula I got is 99% correct, except the 3rd parameter shouldn’t be there. So I removed it manually and now =QUERY(Sheet1!A:Z, “SELECT * WHERE A CONTAINS ‘iphone'”) works perfectly!
Setup Custom Pixel Conversions
If you are a PPC marketing or SEO professional, when users take certain actions on the website, but do not have the help of web developers, if you want to set up custom conversions, it can be quite difficult in some situations. Yes, you can use Google Tag Manager in many cases when users click on the link, but you may need something. different, which is not a built-in feature of GTM.
For example, you should send a conversion event when someone enters your landing page and scrolls 35% of the way down the page. Now you don’t need to hire a developer to get the job done. Go to ChatGPT and ask “send a custom Facebook pixel conversion event once while users are scrolling 35% of the page using JavaScript” and it will do its magic!
Screenshot of the JavaScript code for the January 2023 custom Facebook pixel event
You can copy and paste this code into your <head> HTML tag, and that’s it. If you have a WordPress site, you can use plugins like WPCode to make the job easier. Alternatively, you can use the Google Tag Manager custom HTML tag to add JavaScript code to it.
It saves you time to find a developer for the small daily tasks you have or even if you already 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 user queries to optimize content for a specific keyword. You can use ChatGPT to get these related questions to make your content more helpful. If you have a travel blog, you can ask: “nice cities in Germany” and a question on ChatGPT will bring up a lot of really reasonable queries.
Screenshot of ChatGPT, January 2023
Of course, they may not make sense, but they will do 90% of the job. The queries it suggests may not have any search volume, but it’s still worth chasing because keywords with zero search volume can drive a lot of traffic.
Fetch Data from APIs and Coding
Let’s say you have a WooCommerce store and you want to get all your products with prices in a Google Sheet. Now you can simply ask: “Google app script that fetches all product names and prices from the WooCommerce REST API and adds them to a spreadsheet” and voila.
It gave me fully functional code:
Sometimes it can return a code with a small error that you need to fix manually, like in the example above from the Google Sheets formula.
Conclusion
ChatGPT’s coding capability will be especially useful when working with Zapier. If you’ve ever used Zapier, you know that it has a Zap called “code”, which is for advanced users. Now if you have data in a particular ugly format that needs to be fixed, you can ask ChatGPT to fix it and use Zapier to clean the data in custom code.
There is talk that ChatGPT will be replaced by humans, and many professions will disappear. In my personal opinion, it won’t happen, but it will make life easier in many industries and professional fields.