Sci-fi comes true! We can now communicate and use things we were used to seeing in movies daily.
Among 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 could resolve innovative jobs, however was surprised by seeing how helpful it can be in my life. So I began messing around and discovered the methods I’ve found it useful and wished to share.
Here are 5 ChatGPT examples and beneficial methods SEO experts and marketers can use it for day-to-day marketing jobs.
Compose Routine Expressions In Analytics Reporting
Routine expressions can be used in making up analytic reports such as Google Browse Console or Google Analytics. Routine expressions are among the most boring jobs I know, and it might really decrease work. For marketers, it is even harder, as they do not have a technical background.
Let’s 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 a marketer with no technical background, you may discover it hard to use this function and limit yourself to the few standard regexps which you can find by searching dev-related forums.
Now you have ChatGPT available!
Just 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 quickly. Just copy and paste in the GSC’s filter field, and you will have all the queries which are prospects to optimize 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 example, let’s say you wish to filter a report which has in the URL words”Samsung”and” phone “. Simply ask ChatGPT “make up regular expression which includes words”Samsung”and” phone”case insensitive using RE2 syntax”. Just to note, it is very important to discuss “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 sometimes hard to compose spreadsheet formulas as you should study to find the function name you need and after that invest 10-15mins in figuring 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 solution. Screenshot of Google Sheet Formula created by ChatGPT, January 2023
But, the formula it offered =QUERY(Sheet1!A: Z, “SELECT * WHERE A CONTAINS ‘iphone'”, “Sheet2!A1”) has a small mistake. Naturally, ChatGPT does not constantly offer 100% right responses. You should inspect in some cases and fix it by hand. The formula I got is 99% correct, other than the 3rd criterion should not be there. So I removed it manually and now have =QUESTION(Sheet1!A: Z, “SELECT * WHERE A CONTAINS ‘iphone'”) which works perfectly!
Setup Custom Pixel Conversions
If you are a PPC online marketer or an SEO pro who wants to set up custom-made conversions when users carry out specific actions on the site however don’t have a web designer’s assistance, it could be quite difficult in some situations. Yes, you can use Google Tag Supervisor in most cases when users click on the link, however you could need smth. different, which is not a built-in function of GTM.
It conserves you time to find a designer for small day-to-day tasks you have and even if you have a dev. team, you can substantially minimize their workload by doing it yourself.
Enhance Frequently Asked Question and Featured Bits
SEO specialists may need assistance getting associated concerns from users to enhance material for a specific keyword. You can utilize ChatGPT to get these related concerns to make your material more useful. If you have a travel blog, you might 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
Obviously, there may be ones that don’t make sense, but they will do 90% of the task. The questions it suggests might not have any search volume, however it is still worth pursuing 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 want to fetch all items you have with their prices into a Google Sheet. Now you can just 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 totally practical code:
function fetchProducts() wc
It sometimes might offer a code with a little 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 especially beneficial when working with Zapier. If you have ever used Zapier, you know it has actually a Zap called “code,” which is for advanced users. If you have information in a particular awful format that needs to be repaired now, you can just ask ChatGPT to fix it, and use it in Zapier customized code to tidy up the data. Conclusion There are talks that ChatGPT is going to