5 Ways SEOs and Digital Marketers Use ChatGPT

Science fiction becomes reality! Now we can interact and use what we used to see in movies on a daily basis.

One of the recent innovations is ChatGPT. This will change the way we work.

As a programmer, I didn’t believe I could solve advanced tasks at first, but I was surprised to see how useful it was in my daily life. So after playing around with it, I found a method that I found useful and wanted to share.

Here are five examples of ChatGPT and useful methods that SEO professionals and marketers can use for their daily marketing tasks.

Create regular expressions in Analytics reports

Regular expressions can be used when creating analytics reports such as Google Search Console and Google Analytics. Regular expressions are one of the most tedious tasks I know and can really slow you down. Marketers don’t have a technical background, which makes it even more difficult.

Let’s look at an example of a GSC report that supports regular expression filtering.

Screenshot of GSC query filter by regular expression, January 2023

For marketers without a technical background, this feature can be difficult to use and limited to a few basic regular expressions that can be found by searching development related forums .

ChatGPT is now at your disposal!

Visit ChatGPT and ask:compose regular expression which starts with “How To” or “What is” case insensitive using RE2 syntax “

Screenshot of ChatGPT response, January 2023

yes!

(?i)^(?:How To|What is)

It got the job done quickly. Just copy and paste into GSC’s filter field and you’ll get all the queries that are candidates for optimizing your FAQ or HowTo schema.

Screenshot of GSC report, January 2023

It’s very easy, isn’t it?

You can also use this to create regular expressions for GA reports. For example, suppose you want to filter reports that contain the words “Samsung” and “phone” in the URL. Ask ChatGPT”compose regular expression which contains words “Samsung” and “phone” case insensitive using RE2 syntax ”.

Google’s reporting dashboard supports that syntax, so it’s important to mention “RE2 syntax” in your commands.

Create complex spreadsheet formulas

Everyone works in Excel or Google Sheets. We know that creating spreadsheet formulas can be difficult because you have to do research to find the function name you want and spend 10-15 minutes figuring out how to make it work. prize.

Just ask ChatGPT for commands like:Google Sheet formula which copies all rows from sheet1 where column "A" contains word "iphone"”.

And it didn’t take long to get the solution.

Google Sheet Formula screenshot created by ChatGPT, January 2023

But the formula it gave is =QUERY(Sheet1!A:Z, "SELECT * WHERE A CONTAINS 'iphone'", "Sheet2!A1") There are small errors. Of course, ChatGPT doesn’t always give you 100% correct answers. I have to check and fix it manually from time to time. The formula I got is 99% correct, but the third parameter shouldn’t exist.So I deleted it manually and now have =QUERY(Sheet1!A:Z, "SELECT * WHERE A CONTAINS 'iphone'") This works perfectly!

Setting up a custom pixel transform

If you’re a PPC marketer or SEO pro and want to set up custom conversions when users perform certain actions on your website, but without the help of a web developer, it can be very difficult in some situations. there is. Yes, in many cases when a user clicks on a link he can use google tag her manager, but sometimes you need to be smart. This is not a built-in feature of his GTM.

For example, a conversion event should be sent when a landing page is reached and scrolled 35% of the page. You don’t need to hire developers to get the job done. Visit ChatGPT and ask:send Facebook pixel custom conversion event once as users scroll through 35% of the page using JavaScript” And it does magic!

Screenshot of JavaScript code firing a custom Facebook pixel event, January 2023

Copy this code into your HTML Just stick it on the tag and you’re done. If you have a WordPress site, you can use plugins like WPCode to make things easier. Alternatively, you can use custom HTML tags in Google Tag Manager and add your JavaScript code there.

It saves you time looking for small everyday tasks and even if you have a developer. Doing it yourself can significantly reduce your team’s workload.

Optimize FAQs and Featured Snippets

SEO professionals may need help getting relevant questions from users in order to optimize content for specific keywords. You can use ChatGPT to get these relevant questions and make your content more useful. If you have a travel blog, you can ask: related questions regarding "cozy cities in Germany" And ChatGPT pulls out a lot of queries that really make sense.

Screenshot of ChatGPT running keyword research, January 2023

Of course some may not make sense, but they do 90% of the work. The question suggested may not have any search volume, but it’s still worth considering, as even keywords with zero search volume can generate significant traffic.

Get data from API and coding

Let’s say I have a WooCommerce store and I want to get all the products and their prices into a Google Spreadsheet. Now you can ask:google app script which fetches all product names and prices from WooCommerce REST API and adds into a spreadsheetis complete.

It gave me a fully working code:

function fetchProducts(){
var url = "https://yourshop.com/wp-json/wc/v3/products";
var options = {
  "method": "get",
  "headers": {
    "Authorization": "Basic " + Utilities.base64Encode("YOUR_CONSUMER_KEY:YOUR_CONSUMER_SECRET")
  }
};
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 price = json[i].price;
  // Do something with the product name and price
}
var sheet = SpreadsheetApp.getActiveSheet();
for (var i = 0; i < json.length; i++) {
  var name = json[i].name;
  var price = json[i].price;
  sheet.appendRow([name, price]);
}
}