Science fiction becomes a reality! We can now connect and utilize things we were used to seeing in films daily.
One of the current revolutionary innovations is ChatGPT, which will alter how we work A LOT!
As a programmer, I initially didn’t believe that it could fix innovative jobs, however was surprised by seeing how useful it can be in my daily life. So I started messing around and discovered the methods I’ve found it helpful and wished to share.
Here are five ChatGPT examples and helpful ways SEO specialists and marketers can use it for everyday marketing jobs.
Compose Regular Expressions In Analytics Reporting
Routine expressions can be used in composing analytic reports such as Google Search Console or Google Analytics. Regular expressions are among the most boring jobs I know, and it may actually decrease work. For online marketers, it is even tougher, as they don’t have a technical background.
Let’s take a look at an example of GSC’s reporting, which supports filtering by regexp.
Screenshot of GSC Query Filter by Regexp, January 2023
If you are an online marketer with no technical background, you might find it tough to utilize this function and limit yourself to the few fundamental regexps which you can discover by browsing dev-related forums.
Now you have ChatGPT at your disposal!
Simply go to ChatGPT and ask: “compose regular expression which begins with “How To” or “What is” case insensitive using RE2 syntax “
Screenshot of ChatGPT action, January 2023
(? i)^(?: How To|What is)
It finished the job immediately. Just copy and paste in the GSC’s filter field, and you will have all the inquiries which are candidates to optimize for frequently asked question or HowTo schema.
Screenshot of GSC report, January 2023 Pretty simple, isn’t
it? You can utilize it to compose regexp for GA reports as well. For example, let’s state you want to filter a report which has in the URL words”Samsung”and” phone “. Simply ask ChatGPT “compose regular expression which consists of words”Samsung”and” phone”case insensitive using RE2 syntax”. Just to note, it is necessary to point out “RE2 syntax”in the command, as Google’s reporting dashboards support that syntax. Make Up Complex Spreadsheet Formulas Everybody deals with Excel or Google Sheets. It is in everybody’s day-to-day work life, and
you understand how it is sometimes difficult to compose spreadsheet solutions as you must do research to find the function name you require and then invest 10-15mins in finding out how to make it work. Now it simply takes you to ask ChatGPT a command like:”Google Sheet formula which copies all rows from sheet1 where column”A”
consists of word “iphone””. And it didn’t take long to get the service. Screenshot of Google Sheet Formula produced by ChatGPT, January 2023
But, the formula it gave =QUERY(Sheet1!A: Z, “SELECT * WHERE An INCLUDES ‘iphone'”, “Sheet2!A1”) has a little error. Naturally, ChatGPT doesn’t constantly provide 100% proper responses. You must inspect sometimes and repair it by hand. The formula I got is 99% right, except the 3rd specification shouldn’t be there. So I removed it manually and now have =QUESTION(Sheet1!A: Z, “SELECT * WHERE A CONTAINS ‘iphone'”) which works perfectly!
Setup Custom-made Pixel Conversions
If you are a pay per click marketer or an SEO pro who wants to establish customized conversions when users perform certain actions on the website but don’t have a web developer’s help, it could be rather challenging in some circumstances. Yes, you can utilize Google Tag Supervisor in most cases when users click on the link, but you might require smth. different, which is not a built-in feature of GTM.
It saves you time to discover a developer for little day-to-day tasks you have or perhaps if you have a dev. group, you can substantially reduce their workload by doing it yourself.
Optimize Frequently Asked Question and Featured Bits
SEO experts may need assistance getting associated questions from users to optimize content for a particular keyword. You can utilize ChatGPT to get these associated questions to make your content more useful. If you have a travel blog, you may ask: related concerns relating to “comfortable cities in Germany” and ChatGPT will draw lots of queries which truly make good sense.
Screenshot of ChatGPT carrying out keyword research, January 2023
Naturally, there might be ones that don’t make good sense, however they will do 90% of the job. The concerns it suggests may not have any search volume, but it is still worth pursuing them because zero-search volume keywords might drive substantial traffic.
Fetch Data from APIs and Coding
Let’s state you have a WooCommerce Shop and wish to bring all items you have with their costs into a Google Sheet. Now you can merely ask: “google app script which fetches all item names and rates from WooCommerce REST API and includes into a spreadsheet” and you are done.
It gave me a fully functional code:
function fetchProducts() wc
It sometimes may provide a code with a small mistake that you need to fix manually, like in the above example of the Google Spreadsheet formula.The coding ability of ChatGPT is going to be specifically useful when working with Zapier. If you have ever used Zapier, you know it has actually a Zap called “code,” which is for sophisticated users. If you have information in a certain unsightly format that requires to be repaired now, you can just ask ChatGPT to fix it, and utilize it in Zapier custom-made code to tidy up the data. Conclusion There are talks that ChatGPT is going to