Sci-fi becomes a reality! We can now connect and use things we were used to seeing in films daily.
One of the current innovative innovations is ChatGPT, which will change how we work A LOT!
As a developer, I at first didn’t believe that it might fix advanced tasks, but was shocked by seeing how valuable it can be in my daily life. So I started playing around and discovered the methods I have actually found it helpful and wished to share.
Here are five ChatGPT examples and useful ways SEO specialists and online marketers can use it for daily marketing tasks.
Make Up Routine Expressions In Analytics Reporting
Routine expressions can be used in making up analytic reports such as Google Browse Console or Google Analytics. Regular expressions are one of the most boring tasks I understand, and it might truly slow down work. For online 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 Inquiry Filter by Regexp, January 2023
If you are a marketer with no technical background, you might find it tough to utilize this feature and limitation yourself to the few standard regexps which you can discover by browsing dev-related forums.
Now you have ChatGPT at your disposal!
Simply go to ChatGPT and ask: “make up routine expression which starts with “How To” or “What is” case insensitive using RE2 syntax “
Screenshot of ChatGPT reaction, January 2023
(? i)^(?: How To|What is)
It got the job done instantly. Just copy and paste in the GSC’s filter field, and you will have all the inquiries which are candidates to enhance for FAQ or HowTo schema.
Screenshot of GSC report, January 2023 Pretty easy, isn’t
it? You can use it to make up regexp for GA reports also. For instance, let’s say you wish to filter a report which has in the URL words”Samsung”and” phone “. Just ask ChatGPT “make up routine expression which contains words”Samsung”and” phone”case insensitive using RE2 syntax”. Simply to keep in mind, it is very important to mention “RE2 syntax”in the command, as Google’s reporting dashboards support that syntax. Make Up Complex Spreadsheet Formulas Everyone deals with Excel or Google Sheets. It remains in everyone’s daily work life, and
you understand how it is often difficult to compose spreadsheet formulas as you need to study to discover the function name you need and then invest 10-15mins in figuring 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”
consists of word “iphone””. And it didn’t take long to get the service. Screenshot of Google Sheet Solution produced by ChatGPT, January 2023
However, the formula it gave =QUERY(Sheet1!A: Z, “SELECT * WHERE An INCLUDES ‘iphone'”, “Sheet2!A1”) has a small error. Naturally, ChatGPT doesn’t constantly offer 100% proper responses. You should check in some cases and repair it by hand. The formula I got is 99% right, except the 3rd specification shouldn’t be there. So I eliminated it by hand and now have =QUESTION(Sheet1!A: Z, “SELECT * WHERE A CONTAINS ‘iphone'”) which works perfectly!
Setup Custom Pixel Conversions
If you are a PPC marketer or an SEO pro who wants to set up custom conversions when users perform specific actions on the site however don’t have a web developer’s help, it might be quite challenging in some circumstances. Yes, you can use Google Tag Supervisor in many cases when users click the link, however you could require smth. different, which is not an integrated function of GTM.
It saves you time to discover a designer for little day-to-day jobs you have or perhaps if you have a dev. group, you can considerably lower their work by doing it yourself.
Enhance FAQ and Included Bits
SEO professionals may require aid getting related questions from users to optimize material for a specific keyword. You can use ChatGPT to get these associated questions to make your content more helpful. If you have a travel blog site, you might ask: related questions concerning “cozy cities in Germany” and ChatGPT will draw numerous queries which actually make good sense.
Screenshot of ChatGPT performing keyword research study, January 2023
Naturally, there might be ones that don’t make good sense, but they will do 90% of the task. The questions it suggests may not have any search volume, however it is still worth going after them because zero-search volume keywords may drive considerable traffic.
Fetch Data from APIs and Coding
Let’s state you have a WooCommerce Store and want to bring all products you have with their rates into a Google Sheet. Now you can just 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 offered me a fully practical code:
function fetchProducts() products”; var choices = “approach”: “get”,”headers”: “Authorization”: “Fundamental ” + Utilities.base64Encode(“YOUR_CONSUMER_KEY: YOUR_CONSUMER_SECRET”); var reaction = UrlFetchApp.fetch(url, choices); var json = JSON.parse(response.getContentText()); for (var i = 0; i < json.length; i++) Do something with the product name and rate var sheet = SpreadsheetApp.getActiveSheet(); for (var i = 0; i < json.length; i++) var name = json [i] name; var cost = json [i] rate; sheet.appendRow( [name, price];
It in some cases might provide a code with a small mistake that you need to repair by hand, like in the above example of the Google Spreadsheet formula.The coding ability of ChatGPT is going to be particularly useful when dealing with Zapier. If you have actually ever used Zapier, you understand it has actually a Zap called “code,” which is for advanced 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 use it in Zapier customized code to clean up the information. Conclusion There are talks that ChatGPT is going to