You can use it to compose 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 ”.
Just to note, it is important to mention “RE2 syntax” in the command, as Google’s reporting dashboards support that syntax.
Compose Complex Spreadsheet Formulas
Everyone uses Google Sheets or Excel for work. Everyone who works on a daily basis is aware of how difficult it can be to create spreadsheet formulae since you have to do research to discover the function name you need before spending ten to fifteen minutes working 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" contains word "iphone"“.
And it didn’t take long to get the solution.
Screenshot of Google Sheet Formula created by ChatGPT, January 2023But, the formula it gave =QUERY(Sheet1!A:Z, "SELECT * WHERE A CONTAINS 'iphone'", "Sheet2!A1") has a small error. Of course, ChatGPT doesn’t always provide 100% correct answers. You should check sometimes and fix it manually. The formula I got is 99% correct, except the 3rd parameter shouldn’t be there. So I removed it manually and now have =QUERY(Sheet1!A:Z, "SELECT * WHERE A CONTAINS 'iphone'") which works perfectly!
Setup Custom Pixel Conversions
It could be difficult at times if you’re a PPC marketer or SEO expert who wants to set up unique conversions when customers take specific activities on the website without the assistance of a web developer. Yes, you can utilise Google Tag Manager when consumers click on the link, but sometimes you’ll need something else that GTM doesn’t already have.
For instance, when a visitor lands on your landing page and scrolls through 35% of the page, you need to send a conversion event. Now you may complete the task without hiring a developer. Simply visit ChatGPT and ask:
“send Facebook pixel custom conversion event once as users scroll through 35% of the page using JavaScript” and it will do the magic!
Screenshot of JavaScript code firing custom Facebook pixel event, January 2023
You can finish by copying and pasting this code into your HTML head> tag. If your website is powered by WordPress, you can utilize plugins like WPCode to simplify the process. As an alternative, you can add your JavaScript code using a custom HTML tag from Google Tag Manager.
Even if you have a development team, you can drastically lessen their workload by doing it yourself. It saves you time to locate a developer for tiny everyday duties you have.
Optimize FAQ and Featured Snippets
To improve content for a certain keyword, SEO experts can need assistance from people who have similar inquiries. To make your content more beneficial, you can use ChatGPT to get these pertinent queries. If you run a travel blog, you can pose relevant queries about “cosy cities in Germany” and ChatGPT will generate a tonne of questions that are actually reasonable.
Screenshot of ChatGPT performing keyword research, January 2023Of course, there may be ones that don’t make sense, but they will do 90% of the job. The questions it suggests may not have any search volume, but it is still worth going after them because zero-search volume keywords may drive significant traffic.
Fetch Data from APIs and Coding
Consider a scenario in which you want to download all of the products and prices from your WooCommerce store into a Google Sheet. Now, all you need to do is search for a Google app script that pulls all product names and prices from the WooCommerce REST API and puts them to a spreadsheet, and you’re done.
It provided me with a totally 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]);
}
}
Sometimes, like in the case of the Google Spreadsheet formula in the example above, it may provide a code with a minor error that you must manually correct.
When utilizing Zapier, ChatGPT’s coding capabilities will be very beneficial. If you have ever used Zapier, you are aware of its “code” Zap, which is intended for more experienced users. You can ask ChatGPT to correct data that is in an unsightly format that has to be fixed right now, then use the results in custom Zapier code to clean up the data.
Conclusion
There are rumors that ChatGPT will displace people and cause the demise of several professions. It won’t happen, in my opinion, but it will make life simpler in various professions and businesses.
