Sci-fi comes true! We can now engage and use things we were used to seeing in films daily.
One of the current revolutionary innovations is ChatGPT, which will change how we work A LOT!
As a developer, I initially didn’t believe that it could solve innovative tasks, however was shocked by seeing how useful it can be in my life. So I began messing around and discovered the ways I’ve discovered it useful and wanted to share.
Here are 5 ChatGPT examples and helpful methods SEO specialists and online marketers can use it for everyday marketing tasks.
Make Up Regular Expressions In Analytics Reporting
Routine expressions can be utilized in making up analytic reports such as Google Browse Console or Google Analytics. Regular expressions are among the most boring tasks I understand, and it might really slow down work. For 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 a marketer without any technical background, you might find it tough to use this feature and limitation yourself to the couple of fundamental regexps which you can discover by browsing dev-related online forums.
Now you have ChatGPT available!
Simply go to ChatGPT and ask: “make up 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 did the job immediately. Simply copy and paste in the GSC’s filter field, and you will have all the questions which are prospects to enhance for FAQ or HowTo schema.
Screenshot of GSC report, January 2023 Pretty easy, isn’t
it? You can utilize it to compose regexp for GA reports too. For example, let’s state you wish to filter a report which has in the URL words”Samsung”and” phone “. Simply ask ChatGPT “make up routine expression which includes words”Samsung”and” phone”case insensitive using RE2 syntax”. Simply to keep in mind, it is essential to point out “RE2 syntax”in the command, as Google’s reporting dashboards support that syntax. Compose Complex Spreadsheet Formulas Everybody deals with Excel or Google Sheets. It is in everybody’s everyday work life, and
you understand how it is in some cases hard to make up spreadsheet formulas as you should research to find the function name you need and then spend 10-15mins in finding out 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”
includes word “iphone””. And it didn’t take long to get the solution. Screenshot of Google Sheet Formula produced by ChatGPT, January 2023
However, the formula it offered =QUESTION(Sheet1!A: Z, “SELECT * WHERE A CONTAINS ‘iphone'”, “Sheet2!A1”) has a little mistake. Naturally, ChatGPT doesn’t always provide 100% appropriate answers. You should inspect in some cases and fix it by hand. The formula I got is 99% right, other than the 3rd parameter shouldn’t be there. So I eliminated it by hand and now have =QUESTION(Sheet1!A: Z, “SELECT * WHERE An INCLUDES ‘iphone'”) which works perfectly!
Setup Customized Pixel Conversions
If you are a PPC marketer or an SEO pro who wants to establish customized conversions when users perform particular actions on the site however do not have a web designer’s help, it might be quite tough in some scenarios. Yes, you can utilize Google Tag Manager in a lot of cases when users click the link, however you might need smth. different, which is not an integrated function of GTM.
It conserves you time to discover a developer for little daily jobs you have or even if you have a dev. team, you can significantly lower their workload by doing it yourself.
Optimize Frequently Asked Question and Included Snippets
SEO specialists may need aid getting associated questions from users to enhance material for a particular keyword. You can utilize ChatGPT to get these related questions to make your content more handy. If you have a travel blog site, you may ask: related concerns relating to “relaxing cities in Germany” and ChatGPT will draw lots of questions which really make sense.
Screenshot of ChatGPT carrying out keyword research study, January 2023
Naturally, there might be ones that do not make sense, however they will do 90% of the job. The questions it suggests may not have any search volume, however it is still worth going after them due to the fact that zero-search volume keywords may drive considerable traffic.
Fetch Data from APIs and Coding
Let’s state you have a WooCommerce Shop and want to fetch all products you have with their costs into a Google Sheet. Now you can simply 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 totally functional code:
It sometimes may provide a code with a small error that you need to repair manually, like in the above example of the Google Spreadsheet formula.The coding capability of ChatGPT is going to be particularly useful when working with Zapier. If you have actually ever utilized Zapier, you know it has a Zap called “code,” which is for innovative users. If you have information in a specific unsightly format that needs to be repaired now, you can simply ask ChatGPT to fix it, and use it in Zapier custom code to clean up the data. Conclusion There are talks that ChatGPT is going to