Digital Marketing

ChatGPT Examples: 5 Ways SEOs and Digital Marketers Can Use ChatGPT

Science fiction becomes reality! We can now interact and use things that we used to see in movies every day.

One of the recent revolutionary technologies is ChatGPT, which will change the way we work a lot!

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

Here are five examples of ChatGPT and useful ways SEO professionals and marketers can use it in their day-to-day marketing tasks.

Configure regular expressions in your Analytics reports

Regular expressions can be used to generate analytical reports such as Google Search Console or Google Analytics. Regular expressions are some of the most tedious tasks I know of, and they can really slow down work. For marketers, it is more difficult, since they do not have a technical background.

Let’s look at an example of GSC reports, which support filtering by regular expression.

Screenshot of GSC Query Filter by Regexp Jan 2023

If you are a marketer with no technical background, you may find this feature difficult to use and limit yourself to a few basic regexps which you can find by searching development related forums.

Now you have ChatGPT at your disposal!

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

ChatGPT responseChatGPT response screenshot, Jan 2023

yes!

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

It got the job done right away. Just copy and paste into the GSC’s filter field, and you’ll have all the candidate queries to improve your FAQ or HowTo Chart.

GSC reportScreenshot of the GSC report, January 2023

Very easy, isn’t it?

You can use it to generate regexp for GA reports as well. For example, let’s say you want to filter a report that contains the words “Samsung” and “phone” in the URL. Just ask ChatGPT”compose regular expression which contains words “Samsung” and “phone” case insensitive using RE2 syntax “.

Just for reference, it is important to mention the “RE2 syntax” in the command, as Google Reporting Dashboards support this syntax.

Create complex spreadsheet formulas

Everyone works with Excel or Google Sheets. It’s in everyone’s everyday working life, and you know how difficult it can sometimes be to create spreadsheet formulas where you have to do research to find the name of the function you need and then spend 10-15 minutes figuring out how to make it work.

Now you just have to ask ChatGPT a command like: “Google Sheet formula which copies all rows from sheet1 where column "A" contains word "iphone"“.

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

Google Sheet Formula ChatGPTScreenshot of the Google Sheet Formula created by ChatGPT, January 2023

But the formula she gave =QUERY(Sheet1!A:Z, "SELECT * WHERE A CONTAINS 'iphone'", "Sheet2!A1") He has a small error. Of course, ChatGPT doesn’t always provide 100% correct answers. Sometimes you have to check and fix it manually. The formula you got is 99% correct, except that the third parameter must not be present. So I removed it manually and now I have it =QUERY(Sheet1!A:Z, "SELECT * WHERE A CONTAINS 'iphone'") which works perfectly!

Set up custom pixel transformations

If you are a PPC marketer or SEO professional and want to set up custom conversions when users perform certain actions on your website but don’t have the help of a web developer, it can be very difficult in some situations. Yes, you can use Google Tag Manager in a lot of cases when users click on the link, but you might need something. different, which is not a feature built into GTM.

For example, you need to send a conversion event when someone lands on your landing page and scrolls through 35% of the page. Now you don’t need to hire a developer to get the job done. Just go to ChatGPT and ask: “send Facebook pixel custom conversion event once as users scroll through 35% of the page using JavaScriptIt will do magic!

JavaScript code fires custom facebook pixel eventScreenshot of the JavaScript code that fires a custom Facebook pixel event, January 2023

You can copy this code and paste it into a tag in your HTML, and you’re done. If you have a WordPress site, you can use plugins like WPCode to facilitate work. Alternatively, you can use a dedicated Google Tag Manager HTML tag to add your JavaScript code there.

It saves you time to find a developer for the small daily tasks you have or even if you have a developer. team, you can greatly reduce your workload by doing it yourself.

Improved FAQ and Featured snippets

SEO professionals may need help getting relevant questions from users to optimize content for a particular keyword. You can use ChatGPT to get these questions relevant to make your content more useful. If you have a travel blog, you might ask: related questions regarding "cozy cities in Germany" And ChatGPT will attract many queries that really make sense.

ChatGPT keyword searchScreenshot of ChatGPT doing keyword research, January 2023

Of course, there may be meaningless things, but they will do 90% of the work. The questions it suggests may not have any search volume, but it’s still worth pursuing because keywords with zero search volume may generate more traffic.

Fetching data from APIs and coding

Let’s say you have a WooCommerce store and you want to bring all the products you have with their prices into Google Sheets. 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’re done.

She gave me fully functional 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]);
}
}

It may sometimes give code with a small error that you need to fix manually, like in the above example of a Google Sheets formula.
ChatGPT’s encryption capability will be especially useful when working with Zapier. If you have ever used Zapier, you know that it has a Zap called “code”, which is for advanced users. If you have data in a certain ugly format that needs fixing right now, you can just ask ChatGPT to fix it, and use it in your custom Zapier code to clean up the data.

conclusion

There is talk that ChatGPT will replace humans, and many professions will end. In my personal opinion, this will not happen, but it will make life easier in various industries and professional fields.

More resources:

  • ChatGPT: what it is and how you can use it
  • Why SEO Professionals Need to Master Redirects
  • ChatGPT for content and SEO?

Featured image: ParinPix/Shutterstock

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button