Sci-fi becomes a reality! We can now connect and use things we were utilized 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 at first didn’t believe that it might fix advanced jobs however was amazed by seeing how helpful it can be in my daily life. So I started playing around and found the ways I’ve found it beneficial and wished to share.
Here are five ChatGPT examples and helpful methods SEOs and online marketers can utilize it for everyday marketing tasks.
Make Up Routine 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 one of the most boring jobs I know, and it may truly decrease work. For marketers, it is even tougher 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 without any technical background, you might find it tough to use this function and limit yourself to the few fundamental regexps which you can discover by browsing dev-related forums.
Now you have ChatGPT at hand!
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 action, January 2023
(? i)^(?: How To|What is)
It did the job instantly. Simply copy and paste in the GSC’s filter field, and you will have all the inquiries which are prospects to optimize 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 as well. For example, let’s say you want to filter a report which has in the URL words”Samsung”and” phone “. Just ask ChatGPT “compose regular expression which contains words”Samsung”and” phone”case insensitive using RE2 syntax”. Simply to keep in mind, it is important to point out “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 everybody’s daily work life, and
you understand how it is often hard to compose spreadsheet formulas as you should research to find the function name you need and after that 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 solution. Screenshot of Google Sheet Solution created by ChatGPT, January 2023
However, the formula it gave =QUERY(Sheet1!A: Z, “SELECT * WHERE An INCLUDES ‘iphone'”, “Sheet2!A1”) has a little error. Of course, ChatGPT is not constantly providing 100% proper responses, but you may be misinterpreted. You should inspect in some cases and fix it by hand. The formula I got is 99% right, other than 3rd specification should not exist. So I removed it manually and now have =QUERY(Sheet1!A: Z, “SELECT * WHERE A CONTAINS ‘iphone'”) which works perfectly!
Setup Custom Pixel Conversions
If you are a pay per click marketer or simply an SEO who wishes to establish custom conversions when users perform certain actions on the site however do not have a web designer’s help, it might be rather tough in some circumstances. Yes, you can use Google Tag Supervisor oftentimes when users click on the link, but you could need smth. various, which is not an integrated function of GTM.
It conserves you time to find a developer for small day-to-day tasks you have or even if you have a dev. group, you can considerably reduce their workload by doing it yourself.
Enhance Frequently Asked Question and Featured Bits
SEO professionals may require help getting associated questions from users to optimize content for a particular keyword. You can utilize ChatGPT to get these related questions to make your content more valuable. If you have a travel blog, you may ask: related questions relating to “cozy cities in Germany” and ChatGPT will draw lots of questions which really make sense.
Screenshot of ChatGPT carrying out keyword research, January 2023
Of course, there may be ones that don’t make sense, but they will do 90% of the task. The questions it suggests may haven’t any search volume, but it is still worth going after them due to the fact that zero-search volume keywords might drive considerable traffic.
Fetch Data from APIs and Coding
Let’s say you have a WooCommerce Shop and wish to fetch all products you have with their costs 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 gave me a fully practical code:
function fetchProducts() products”; var options = ; var response = UrlFetchApp.fetch(url, options); var json = JSON.parse(response.getContentText()); for (var i = 0; i < json.length; i++) var name = json [i] name; var cost = json [i] rate; var sheet = SpreadsheetApp.getActiveSheet(); for (var i = 0; i < json.length; i++)
It in some cases may provide 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 helpful when dealing with Zapier. If you have ever used Zapier, you know it has a Zap called “code,” which is for advanced users. Now it isn’t. If you have data in a particular unsightly format that requires to be fixed now, you can simply ask ChatGPT to repair and use it in Zapier custom code to tidy up the information.
There are talks that ChatGPT is going to replace humans, and lots of professions are simply going to die out. In my individual viewpoint, it will not occur, however it will make life simpler in various market fields.
Included Image: ParinPix/SMM Panel