Examples Of ChatGPT For Analytics And Data

1. Compose Regular Expressions In Analytics Reporting

Regular expressions can be used in composing analytic reports such as Google Search Console (GSC) or Google Analytics (GA).

Regular expressions are one of the most boring tasks I know, and it may really slow down work. For marketers, it is even tougher, as they typically don’t have a technical background.

Let’s look at an example of GSC’s reporting, which supports filtering by regexp (regular expression).

Examples Of ChatGPT For Analytics And Data 1

Screenshot of GSC Query Filter by Regexp, January 2023

 

If you are a marketer with no technical background, you may find it hard to use this feature and limit yourself to the few basic regexps, which you can find by searching dev-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.

 

Screenshot of ChatGPT response, January 2023

Yup!

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

It got the job done instantly.

Copy and paste the pattern in GSC’s filter field, and you will have all the queries that are candidates to optimize for FAQ or HowTo schema.

Examples Of ChatGPT For Analytics And Data 2Examples Of ChatGPT For Analytics And Data 3

Screenshot of GSC report, January 2023

Pretty easy, isn’t it?

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 the 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.

2. Compose Complex Spreadsheet Formulas

Everyone works with Excel or Google Sheets at some time.

Spreadsheets are a part of daily work life for many of us. But composing spreadsheet formulas can be arduous, as you must research to find the function name you need and then spend 10 to 15 minutes figuring out how to make it work.

Now, it just takes you a minute to ask ChatGPT with 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.

Examples Of ChatGPT For Analytics And Data 4

Screenshot of Google Sheet Formula created by ChatGPT, January 2023

But, 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 always check its answers, as you may need to fix them manually.

The formula I got is 99% correct, except that the third 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!

I always recommend using punctuation in ChatGPT to help it better understand the prompt.

For example, use a colon to end the prompt or quotes around any text that isn’t part of the prompt.

3. Composing SQL queries

With the introduction of GA4, marketers may often need to fetch data from BigQuery, as Google now offers a free connection of GA4 to BigQuery.

To query the dataset, you would need to learn SQL – or just ask ChatGPT to build a specific query for you to extract valuable data without sampling from the dataset.

Examples Of ChatGPT For Analytics And Data 5

Screenshot of an SQL sample using ChatGPT, January 2023

Examples Of ChatGPT For Digital Marketing

When using ChatGPT for market research and your brand marketing, always remember that it was trained on data up to the third quarter of 2021 and thus may not be the best tool for dealing with current trends.

But it is a handy tool for many other tasks you may have. Let’s take a look at some of them.

4. Generate Audience Personas

Let’s say you’ve launched a new SaaS company and want to know who your audience is so that you can build your marketing efforts around them.

You can ask ChatGPT to create audience personas.

The prompt I would use is Create audience personas for the “physical threat detection software.”

Examples Of ChatGPT For Analytics And Data 6

Screenshot of an audience persona created by ChatGPT, January 2023

And the results are just a great place to start.

This doesn’t mean you should fire your marketing leader, but now, they have a tool that can 10x boost their performance and deliver faster results.

5. SWOT Analysis

This is a really cool prompt you can use for your brand or competitive analysis.

You can ask to do a SWOT analysis of any company.

For example, I used the prompt SWOT analysis of “Washington Post” , and the results were a very interesting starting point.

Examples Of ChatGPT For Analytics And Data 7

Screenshot of SWOT analysis by ChatGPT, January 2023

6. S.M.A.R.T. Goals

SMART goals are important because they provide a clear framework for setting and achieving objectives.

With ChatGPT, you can get ideas for your company using the prompt S.M.A.R.T. goals for SaaS “<company name>.”

Examples Of ChatGPT For Analytics And Data 8

Screenshot of SMART Goals by ChatGPT, January 2023

7. Craft A Newsletter

You can use ChatGPT to craft an outline for the newsletter campaign you want to run.

Let’s say you have a sale on Black Friday and want to send a newsletter to promote your offer.

Just ask, Craft an email campaign newsletter on Black Friday for SaaS “<company name>” which offers 20% discount. Include a catchy call to action button at the end of the email.

Examples Of ChatGPT For Analytics And Data 9

Screenshot of an email newsletter generated by ChatGPT, January 2023

Examples Of ChatGPT For Productivity

8. Craft Pitch Emails

Again, if you are a SaaS startup, you definitely need to sell your software.

Your sales team needs to pitch prospective customers and respond to hundreds of emails, which is exhausting and can be a slow process.

Increasing the productivity of your sales team can help you sell more and increase your revenue.

The example prompt you can use here is Craft a pitch email for selling “physical threat detection software.”

Examples Of ChatGPT For Analytics And Data 10

Screenshot of a pitch email example generated by ChatGPT, January 2023

Alternatively, there is a Chrome add-on that you may use.

9. Craft A Social Media Post

Let’s say you’ve published articles and want to push them to social media.

You would need a well-crafted and compelling text to post on social media so that users will click on your post.

Examples Of ChatGPT For Analytics And Data 11

Screenshot of social media posts crafted by ChatGPT, January 2023

I bet you would spend at least 15 minutes composing such a compelling social media post. But now, you can do it in one minute.

10. Write Ad Copy

If you are a PPC marketer, you deal a lot with creating ad copy – and having an extra resource to provide you with thought starters could save hundreds of hours a month for you.

The sample prompt I used is Write a Google ad text with a title of up to 30 characters and a description of up to 90 characters for SaaS “physical threat detection software.”

Examples Of ChatGPT For Analytics And Data 12

Screenshot of an ad copy by ChatGPT, January 2023

You may also include blog post article text from which to generate the ad copy, which will be more specific to you.

The sample prompt would be: Write a Google ad text with a title of up to 30 characters and a description of up to 90 characters for SaaS “<company type>” from the text below.

Just replace the prompt with the company type with your version.

11. Craft A Job Description

All companies need to hire, meaning they must write job descriptions.

Now, ChatGPT can help with that, too.

For example, Job description of Social Media Manager for real estate company.

Examples Of ChatGPT For Analytics And Data 13

Screenshot of a job description generated by ChatGPT, January 2023

Always remember you can finetune the prompt by adding more details to it, which will make the answer even better.

Examples Of ChatGPT For Technical SEO

12. Generate FAQ Schema

You can have ChatGPT generate FAQ schema code from a text you provide.

Examples Of ChatGPT For Analytics And Data 13

Screenshot of an FAQ schema generated by ChatGPT, January 2023

Of course, you may use a CMS plugin for that, too.

But what if you use Wix, for example, which doesn’t have a plugin? Should you copy and paste schema code into the editor? In this case, ChatGPT is a handy tool and assistant at your disposal.

You can generate any kind of schema by using a similar example.

13. Generate HowTo Schema

In the case of the HowTo schema, you can enter a similar prompt as we did for FAQ, and ChatGPT will do 99% of the job.

The prompt would be,Generate HowTo schema on how to bake a cake from the steps below and suggest images with each step.

Examples Of ChatGPT For Analytics And Data 15

Screenshot of a HowTo schema generated by ChatGPT, January 2023

Why 99% and not 100%? Simply because you need to replace sample image URLs.

It did, however, add HowTo schema steps with real images.

Just upload images in your CMS and replace the sample image path in the suggested schema.

14. Create Robots.txt Rules

SEO pros deal with robots.txt a lot.

Now you have a tool that can help you create any robots.txt rules with ease.

Below is an example of how to prevent Google from crawling your PPC campaign landing pages, which are located in directory /landing/but let Google ads bot in.

The prompt you can use is Robots.txt rule which blocks Google’s access to directory /landing/ but allows Google ads bot.

Examples Of ChatGPT For Analytics And Data 16

Screenshot of a robots.txt rule created by ChatGPT, January 2023

After you’ve done edits, always test your robots.txt.

15. Generate htaccess Redirect Rules

SEO pros often deal with migrations and may need to redirect a lot of stuff, depending on what type of server one has.

You can now generate htaccess or Nginx redirect rules using ChatGPT.

The prompt I used is For redirecting folder1 to folder2 generate nxig and htaccess redirect rules,

The results are just neat.

Examples Of ChatGPT For Analytics And Data 17

Screenshot of a Python script generated by ChatGPT, January 2023

16. Connect To APIs And Coding

SEO pros often need to connect to various APIs and fetch data, but may lack programming skills.

Now you have ChatGPT at your disposal for basic tasks which require programming.

In the example below, I asked ChatGPT to get Google autosuggestion using the known “pytrends” library.

Examples Of ChatGPT For Analytics And Data 18

Screenshot of a Python script generated by ChatGPT, January 2023

You can basically use ChatGPT for coding in all programming languages.

The same prompt may be composed to ask the same, but in PHP: Get Google Keyword Suggestions using PHP.

For running PHP on your local machine, you may use the free environment XAMPP; for running Python, you may use Jupiter.

If you are a PPC marketer who wants to set up custom conversions when users perform certain actions on the website but don’t have a web developer’s help, it could be quite challenging in some situations.

Yes, you can use Google Tag Manager in many cases when users click on the link, but you could need something different, which is not a built-in feature of GTM.

For example, you need to send a conversion event when one 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 JavaScript, and it will do the magic!

Examples Of ChatGPT For Analytics And Data 19

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

You can copy and paste this code in your <head> tag of HTML, and you are done.

If you have a WordPress site, you can use plugins such WPCode to make the job easier.

Alternatively, you can use Google Tag Manager custom HTML tag to add your JavaScript code there.

It saves you the time of having to find a developer for small daily tasks. And even if you do have a dev team, you can significantly reduce their workload by doing it yourself.

Examples Of ChatGPT For Keyword Research

17. Get Keyword Ideas

Examples Of ChatGPT For Analytics And Data 20

Screenshot of long-tail keywords generated by ChatGPT, January 2023

An example prompt you can use is Generate a list of long  and short tail keyword ideas on the topic “machine learning.”

Now SEO tools have a serious competitor that’s free to use.

The only caveat is that, as I’ve mentioned already, ChatGPT is trained on data up to the third quarter of 2021 and isn’t connected to the internet. Thus, it may fail to work in cases when you need more recent data.

For example, I asked who won Fifa 2022 World Cup, and it failed to answer.

Examples Of ChatGPT For Analytics And Data 21

Screenshot from ChatGPT, January 2023

18. Get The Search Intent Of The Search Query

You have a lot of data in your GSC, which now you can copy and paste into ChatGPT to get more insights.

For example, you can copy-paste a list of search queries and ask for the intent of the query using the prompt What is the user intent behind these queries?.

Examples Of ChatGPT For Analytics And Data 22

Screenshot of a search intent generated by ChatGPT, January 2023

19. Cluster Semantically Relevant Keywords

Again, you can use ChatGPT to organize the keywords you rank for – and not only those – into clusters: Cluster list of keywords based on their semantic relevance.

Examples Of ChatGPT For Analytics And Data 23

Screenshot of ChatGPT, January 2023

Another case is to identify pages that rank for semantically relevant queries and restructure your URLs under silos.

For example, bring all pages that are about social media or under /social-media/ silo, which can help you boost ranking and help Google better understand your website structure.

20. Generate Related Keywords And Synonyms

It is always good to mention your content-related keywords and synonyms.

You can do it at scale by using ChatGPT.

Just ask:Generate related keywords or the list of keywords below.

Examples Of ChatGPT For Analytics And Data 24

Screenshot from ChatGPT, January 2023

21. Generate Article Titles Based On Keywords

As you have keywords you want to write articles about, it is time to brainstorm titles for your articles.

The prompt I used is Suggest titles based on keywords list below.

Examples Of ChatGPT For Analytics And Data 25

Screenshot from ChatGPT, January 2023

Examples Of ChatGPT For On-Page SEO

22. Generate Meta Descriptions

You can copy and paste text into ChatGPT and ask it to create a meta description from it.

The prompt I used is Generate concise and compelling meta description of up to 200 characters from the provided text.

Examples Of ChatGPT For Analytics And Data 26

Screenshot of a meta description generated by ChatGPT, January 2023

23. Optimize For PAA Box And Featured Snippets

SEO professionals may need help getting related questions from users to optimize content for a specific keyword.

You can use ChatGPT to get these related questions to make your content more helpful.

If you have a travel blog, you may ask: Related questions regarding “cozy cities in Germany,” and ChatGPT will draw many queries which really make sense.

Examples Of ChatGPT For Analytics And Data 27

Screenshot of ChatGPT performing keyword research, January 2023

Of 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.

24. Generate FAQ For The Product With Answers

If you have an ecommerce store and want to enhance your product pages with an FAQ section, you can ask ChatGPT to help you.

The example prompt I used is Generate FAQ for the Galaxy A23 5G with answers. Based on the results generate also FAQ schema.

Examples Of ChatGPT For Analytics And Data 28

Screenshot of ChatGPT generating FAQ for a product, January 2023

And you can shoot two rabbits with one shot, as you will also get an FAQ schema you can use.

Examples Of ChatGPT For Analytics And Data 29

Screenshot of ChatGPT generating an FAQ schema, January 2023

Pretty simple, isn’t it?

If you worry about being penalized by Google for AI-written content, I think you are okay as long as you fact-check and revise it for errors.

But I am strictly against generating full article copy using ChatGPT because you must fact-check it and likely spend more time revising it than writing from scratch. With the rise of AI detectors, Google may eventually be able to detect it.

Treat ChatGPT as an assistant that you can use wisely when you next an extra hand.

25. Suggest Heading Tags

Let’s say you have a big chunk of text and want to get ideas about what subheadings to add to make your content more structured.

You can ask ChatGPT to do that time-consuming editorial task for you just by asking, Suggest H2 subheadings to content below without modifying the text.

Examples Of ChatGPT For Analytics And Data 30

Screenshot of ChatGPT generating subheadings, January 2023

Of course, it might not always offer exactly what you wanted, but you may play with the prompt and add more context to it – or take ChatGPT hints and work from there by adding your edits to subheadings.

 

wpChatIcon
wpChatIcon