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.

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
“

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.

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.

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!

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.

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 spreadsheet
is 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]);
}
}
You may see code with minor errors that need to be fixed manually, like the example Google Sheets formula above.
ChatGPT’s coding capabilities are especially useful when using Zapier. If you’ve ever used Zapier, you know there is a Zap called “Code” for advanced users. If you have certain ugly formatted data that you need to fix now, you can ask ChatGPT to fix it and use it in your Zapier custom code to clean up your data.
Conclusion
There is talk of ChatGPT replacing humans, and many jobs are just disappearing. My personal opinion is that it won’t happen, but it will make life easier in different industries and specialties.
Other resources:
Featured Image: ParinPix/Shutterstock
var s_trigger_pixel_load = false; function s_trigger_pixel(){ if( !s_trigger_pixel_load ){ striggerEvent( 'load2' ); console.log('s_trigger_pix'); } s_trigger_pixel_load = true; } window.addEventListener( 'cmpready', s_trigger_pixel, false);
window.addEventListener( 'load2', function() {
if( sopp != 'yes' && !ss_u ){
!function(f,b,e,v,n,t,s) {if(f.fbq)return;n=f.fbq=function(){n.callMethod? n.callMethod.apply(n,arguments):n.queue.push(arguments)}; if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0'; n.queue=[];t=b.createElement(e);t.async=!0; t.src=v;s=b.getElementsByTagName(e)[0]; s.parentNode.insertBefore(t,s)}(window,document,'script', 'https://connect.facebook.net/en_US/fbevents.js');
if( typeof sopp !== "undefined" && sopp === 'yes' ){ fbq('dataProcessingOptions', ['LDU'], 1, 1000); }else{ fbq('dataProcessingOptions', []); }
fbq('init', '1321385257908563');
fbq('track', 'PageView');
fbq('trackSingle', '1321385257908563', 'ViewContent', { content_name: 'chatgpt-examples', content_category: 'trends-digital seo' }); } });