Sci-fi becomes a reality! We can now connect and use things we were used to seeing in motion pictures daily.
One of the current advanced technologies is ChatGPT, which will change how we work A LOT!
As a programmer, I initially didn’t think that it could fix sophisticated tasks, however was surprised by seeing how practical it can be in my life. So I started playing around and discovered the ways I’ve discovered it beneficial and wanted to share.
Here are 5 ChatGPT examples and beneficial methods SEO professionals and online marketers can use it for day-to-day marketing jobs.
Make Up Routine Expressions In Analytics Reporting
Routine expressions can be used in making up analytic reports such as Google Search Console or Google Analytics. Regular expressions are one of the most uninteresting jobs I understand, and it may really slow down work. For marketers, it is even tougher, as they do not 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 a marketer without any technical background, you may discover it hard to utilize this function and limitation yourself to the few fundamental regexps which you can discover by searching dev-related online forums.
Now you have ChatGPT at your disposal!
Simply go to ChatGPT and ask: “make up regular expression which starts with “How To” or “What is” case insensitive using RE2 syntax “
Screenshot of ChatGPT response, January 2023
(? i)^(?: How To|What is)
It did the job quickly. Simply copy and paste in the GSC’s filter field, and you will have all the queries which are candidates to enhance for FAQ or HowTo schema.
Screenshot of GSC report, January 2023 Pretty simple, isn’t
it? You can use it to compose regexp for GA reports also. For instance, let’s state you want to filter a report which has in the URL words”Samsung”and” phone “. Simply ask ChatGPT “make up routine expression which consists of words”Samsung”and” phone”case insensitive using RE2 syntax”. Simply to note, it is necessary to discuss “RE2 syntax”in the command, as Google’s reporting control panels support that syntax. Make Up Complex Spreadsheet Solutions Everyone works with Excel or Google Sheets. It is in everyone’s everyday work life, and
you understand how it is in some cases hard to make up spreadsheet formulas as you must do research to discover the function name you need and then invest 10-15mins in determining how to make it work. Now it just 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 created by ChatGPT, January 2023
However, the formula it offered =QUESTION(Sheet1!A: Z, “SELECT * WHERE A CONTAINS ‘iphone'”, “Sheet2!A1”) has a small error. Obviously, ChatGPT does not always supply 100% proper answers. You need to inspect in some cases and repair it manually. The formula I got is 99% proper, except the 3rd specification shouldn’t exist. So I eliminated it by hand and now have =QUESTION(Sheet1!A: Z, “SELECT * WHERE A CONTAINS ‘iphone'”) which works perfectly!
Setup Customized Pixel Conversions
If you are a pay per click marketer or an SEO pro who wants to establish custom-made conversions when users perform particular actions on the website however do not have a web developer’s aid, it could be quite difficult in some circumstances. Yes, you can use Google Tag Manager oftentimes when users click the link, but you could need smth. different, which is not an integrated feature of GTM.
It conserves you time to discover a designer for little day-to-day tasks you have and even if you have a dev. group, you can significantly decrease their workload by doing it yourself.
Optimize FAQ and Included Snippets
SEO specialists may need aid getting related concerns from users to enhance content for a particular keyword. You can utilize ChatGPT to get these associated concerns to make your material more valuable. If you have a travel blog, you might ask: associated questions concerning “comfortable cities in Germany” and ChatGPT will draw lots of queries which really make sense.
Screenshot of ChatGPT performing keyword research, January 2023
Of course, there may be ones that don’t make sense, but they will do 90% of the job. The concerns it recommends may not have any search volume, however it is still worth going after them because zero-search volume keywords may drive substantial traffic.
Fetch Data from APIs and Coding
Let’s say you have a WooCommerce Store and wish to fetch all products you have with their costs into a Google Sheet. Now you can merely ask: “google app script which fetches all product names and prices from WooCommerce REST API and adds into a spreadsheet” and you are done.
It provided me a completely functional code:
function fetchProducts() products”; var options = “technique”: “get”,”headers”: ; var reaction = UrlFetchApp.fetch(url, choices); var json = JSON.parse(response.getContentText()); for (var i = 0; i < json.length; i++) Do something with the item name and cost var sheet = SpreadsheetApp.getActiveSheet(); for (var i = 0; i < json.length; i++)
It sometimes might offer a code with a small mistake that you need to fix by hand, like in the above example of the Google Spreadsheet formula.The coding ability of ChatGPT is going to be specifically helpful when dealing with Zapier. If you have actually 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 needs to be repaired now, you can just ask ChatGPT to fix it, and utilize it in Zapier custom code to clean up the information. Conclusion There are talks that ChatGPT is going to