Science fiction becomes a reality! We can now communicate and utilize things we were used to seeing in motion pictures daily.
Among the current innovative innovations is ChatGPT, which will change how we work A LOT!
As a developer, I initially didn’t think that it could fix innovative tasks, but was surprised by seeing how valuable it can be in my every day life. So I began playing around and found the ways I have actually discovered it useful and wished to share.
Here are 5 ChatGPT examples and helpful ways SEO experts and online marketers can utilize it for day-to-day marketing tasks.
Compose Regular Expressions In Analytics Reporting
Routine expressions can be utilized in making up analytic reports such as Google Browse Console or Google Analytics. Routine expressions are among the most dull tasks I know, and it may truly decrease work. For marketers, it is even harder, 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 Question Filter by Regexp, January 2023
If you are an online marketer without any technical background, you may find it tough to utilize this function and limit yourself to the few standard regexps which you can discover by searching dev-related online forums.
Now you have ChatGPT available!
Just go to ChatGPT and ask: “compose routine expression which begins with “How To” or “What is” case insensitive utilizing RE2 syntax “
Screenshot of ChatGPT response, January 2023
(? i)^(?: How To|What is)
It got the job done instantly. Simply copy and paste in the GSC’s filter field, and you will have all the questions which are prospects to optimize for frequently asked question or HowTo schema.
Screenshot of GSC report, January 2023 Pretty easy, isn’t
it? You can use it to compose regexp for GA reports also. For instance, let’s say you want to filter a report which has in the URL words”Samsung”and” phone “. Just ask ChatGPT “make up regular expression which consists of words”Samsung”and” phone”case insensitive utilizing RE2 syntax”. Just to keep in mind, it is necessary to discuss “RE2 syntax”in the command, as Google’s reporting dashboards support that syntax. Make Up Complex Spreadsheet Formulas Everybody works with Excel or Google Sheets. It remains in everyone’s daily work life, and
you understand how it is in some cases tough to make up spreadsheet solutions as you need to do research to find the function name you require and after that invest 10-15mins in determining 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 solution. Screenshot of Google Sheet Solution produced by ChatGPT, January 2023
However, the formula it offered =QUESTION(Sheet1!A: Z, “SELECT * WHERE A CONTAINS ‘iphone'”, “Sheet2!A1”) has a small mistake. Of course, ChatGPT does not always supply 100% appropriate responses. You must check often and repair it by hand. The formula I got is 99% proper, other than the 3rd parameter shouldn’t exist. So I eliminated it by hand and now have =QUERY(Sheet1!A: Z, “SELECT * WHERE An INCLUDES ‘iphone'”) which works completely!
Setup Customized Pixel Conversions
If you are a pay per click marketer or an SEO pro who wishes to establish custom conversions when users perform particular actions on the website however don’t have a web developer’s assistance, it could be rather difficult in some scenarios. Yes, you can use Google Tag Manager oftentimes when users click on the link, but you could require smth. various, which is not a built-in feature of GTM.
It saves you time to discover a developer for small everyday tasks you have or even if you have a dev. team, you can substantially decrease their workload by doing it yourself.
Optimize Frequently Asked Question and Featured Bits
SEO experts may require assistance getting related concerns from users to optimize content for a specific keyword. You can use ChatGPT to get these related concerns to make your material more useful. If you have a travel blog, you may ask: related questions relating to “comfortable cities in Germany” and ChatGPT will draw lots of inquiries which truly make good sense.
Screenshot of ChatGPT performing keyword research, January 2023
Of course, there might be ones that do not make 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 since 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 fetch 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 costs from WooCommerce REST API and adds into a spreadsheet” and you are done.
It provided me a completely functional code:
function fetchProducts() products”; var alternatives = ; var reaction = UrlFetchApp.fetch(url, alternatives); var json = JSON.parse(response.getContentText()); for (var i = 0; i < json.length; i++) var sheet = SpreadsheetApp.getActiveSheet(); for (var i = 0; i < json.length; i++)
It in some cases might give a code with a little mistake that you require to fix manually, like in the above example of the Google Spreadsheet formula.The coding ability of ChatGPT is going to be specifically beneficial when dealing with Zapier. If you have ever utilized Zapier, you know it has a Zap called “code,” which is for innovative users. If you have data in a particular awful format that needs to be repaired now, you can simply ask ChatGPT to repair it, and utilize it in Zapier custom code to tidy up the information. Conclusion There are talks that ChatGPT is going to