These are a few of the largest challenges/alternatives for content material entrepreneurs:
- See the efficiency of content material in numerous channels
- Use that information to tell choices about what to publish
- Align subjects with promotion channels
The perfect instruments for these jobs are very highly effective, however they’re new to lots of people, so doing this sort of content material evaluation feels daunting. However embrace the instruments and really, it’s by no means been simpler.
On this article, we’ll present the step-by-step course of for combining ChatGPT-4’s Superior Information Evaluation with information exported from GA4.
You’ll not solely see the previous efficiency of your content material, however you’ll get new concepts for what to create and the place to advertise. In case you’d like to sit down again and simply watch it, right here’s a video:
What you’ll want:
To do that enjoyable bit of research, you’ll want simply two instruments.
- Superior Information Evaluation, which is the characteristic of ChatGPT that allows you to add recordsdata. It additionally attracts charts and writes code. On the time of this writing, Superior Information Evaluation is offered solely to paid customers. So in case you haven’t but, pony up the $20.
- Google Analytics with a minimum of 6 months of information. I’ll do that in GA4, however in case you don’t have a lot information there but, you’ll be able to return and do all of it with historic information from Common Analytics.
1. Export content material efficiency information from GA4
GA4 has the efficiency of your content material advertising and marketing in numerous methods (visitors and engagement) and in numerous channels (natural search, social media, and many others.). We simply must get the information out with essentially the most helpful dimensions and metrics.
We’ve revealed a detailed guide on how to audit your content in GA4, however right here we’re simply getting information to export. We’ll let AI do the evaluation. Right here’s the method:
Go to the Engagement > Pages and Screens report.
Subsequent, customise the report by clicking on the pencil within the high proper. Now choose the metrics most helpful for content material advertising and marketing evaluation. Drag your favs to the highest, take away those you don’t like, add higher ones by clicking “Add metric” on the backside after which looking.
Listed below are my beneficial metrics for measuring content material efficiency:
- Customers
- Periods
- Engagement charge
- Common engagement time
- Conversions
- Session Conversion charge
That is loads to offer you sturdy clues into what subjects are working nicely. Click on Apply then click on Save. Go forward and Save modifications to the present report as a result of why not. These little customizations are belongings you’ll do on a regular basis.
Again on the report, we are able to now construct a content material efficiency report. First, choose a pleasant, lengthy date vary. I’m utilizing 6 months.
Actually, we simply need our content material advertising and marketing pages, not your complete web site, so we have to create a filter to Embrace simply the URLs that include the phrase “weblog.”
Observe: In case your weblog content material isn’t all in a typical listing, you’ll need to enter one thing else that tells Analytics methods to embody solely these URLs.
Right here’s methods to make a GA4 filter to indicate simply your content material advertising and marketing URLs:
- Click on Add filter + button.
- Click on on the “Choose dimension dropdown” and choose Web page Location. Observe: in case you don’t have Web page Location, use web page path and display class
- Click on on the “Choose dimension values” dropdown and sort weblog.
- Click on on All values containing ‘weblog’
- Click on Apply
Right here’s what your filter will appear like:
Now our report reveals simply our content material advertising and marketing and simply our favourite metrics. Subsequent, let’s set the report to indicate the title tags of our articles. Click on on the dropdown menu above the primary column within the report and choose Web page title and display identify.
It will assist ChatGPT know the subjects of our articles. That is extra significant for our evaluation than the URLs.
In fact, not all content material works all over the place. So let’s add some information in regards to the supply of visitors to those articles. We’ll do that with a secondary dimension.
Click on on the plus signal (+) above the primary column within the report. Seek for “medium” and choose Session medium. It will add one other column to the report between the primary column and the metrics.
Now the report ought to appear like this:
Did this course of really feel troublesome or complicated?
Begin over and do all of it once more. And once more. You’ll quickly notice that it actually takes simply 20 clicks and takes lower than one minute. Simply half-hour in GA4 and also you’ll be capable to do what most entrepreneurs won’t ever study.
Okay. We’ve bought our information. Often, right here’s the place I’d advocate trying on the information within the report. However not right this moment. You’re going to make use of our plucky new analysis assistant to do the evaluation for you.
- Click on the share icon within the high proper nook of Google Analytics
- Click on Obtain file
- Choose Obtain CSV
Often, right here’s the place I’d advocate trying on the file. However not right this moment! No must even open the file…
2. Import the information into the ChatGPT Superior Information Evaluation
The exhausting half is finished. Be happy to shut your Google Analytics tab now. We’re carried out with GA4 for now.
We’re going to make use of the ChatGPT-4 Superior Information Evaluation so that you’ll want a paid account and also you’ll must go to settings and activate Superior Information Evaluation, which is at the moment within the Beta Options part.
It is rather highly effective.
Right here’s how we’ll get the file in and begin the coaching prompts.
- Click on + New Chat within the high left to start out a brand new dialog.
- Click on GPT-4 and choose Superior Information Evaluation from the dropdown menu
Warning! Your organization could have insurance policies about importing information to an AI. Or in case you’re an company, your shoppers could have AI restrictions of their authorized agreements with you, the seller. If you happen to’re undecided, ask earlier than importing.
- Subsequent, within the immediate subject, we’ll click on the plus icon to add the file.
- Add a immediate telling it in regards to the information and confirming that it could do the evaluation.
Right here’s my first immediate:
“I’m supplying you with quite a lot of Google Analytics information about visitors to the orbitmedia.com weblog. It reveals the efficiency of all of our content material advertising and marketing content material since Jan 1. Are you able to reply questions on this dataset?”
The AI will load the dataset and attempt to learn the information. Watching it at work may be very very spectacular. It should reorganize and reformat the information as many instances as essential to get what it wants. For GA4 information, this implies eradicating the feedback within the first rows.
There isn’t any want to scrub up the information. ChatGPT’s Superior Information Evaluation does all of it for you.
As soon as it’s carried out, it is going to inform you it’s prepared.
 |
Alexander Holl, 121WATT |
“Take into consideration the place you’ll be able to obtain digital advertising and marketing information in .csv format. Some instruments that provide .csv information embody Google Search Console, GA4, YouTube Analytics, and web optimization instruments like Sistrix, ScreamingFrog, SEMrush and Google Advertisements.
Typically, you’ll encounter information that you just’re uncertain methods to deal with. As an example, you may need a report out of your Google Advertisements account, such because the “Paid and Natural Report.” This report is, in my view, probably the most underrated assets for SEOs. Ask Superior Information Evaluation a query like: “I’m going to add a knowledge file from my Google Advertisements account. Because the particular person answerable for web optimization, what can I study from this information?”
3. Ask the AI to research the GA4 information
Subsequent, give it an in depth immediate. The perfect prompts inform the AI who it’s and what expertise to make use of. Additionally, be particular about what you’re on the lookout for, however not so particular that the solutions are constrained.
Right here’s my second immediate:
“You’re a digital advertising and marketing analyst and an professional and making data-driven suggestions. Mix the information from the columns to advocate new digital advertising and marketing subjects that will seemingly have good visitors and engagement. Set up the subjects into two teams: people who would carry out nicely in social vs. natural search”
I’m asking it to contemplate excessive performers in search and social individually as a result of what works in a single usually doesn’t work within the different. Search and social aren’t simply totally different, they are opposites!
To finish the evaluation, Superior Information Evaluation wanted to regulate the dataset some extra. As soon as it completed, it decided, based mostly by itself weighting of visitors and engagement, the top-performing articles in each search and social.
Amazingly, it linked to every article within the record. I’m actually undecided how as a result of the URLs weren’t within the dataset. It shared this word beneath the lists: “Observe: the precise URLs are inferred based mostly on the title and never offered within the dataset.” …however how??
4. Ask the AI to advocate new subjects based mostly on the information
Technically, Google Analytics can do every thing we’ve carried out to date. You possibly can sort in full questions and it’ll attempt to generate a report with the reply. However there are enormous variations.
It doesn’t present solutions in English.
It will probably’t have a dialog based mostly on earlier questions.
It solely reveals you issues it has.
ChatGPT with Superior Information Evaluation (and different generative AIs) can create new solutions that aren’t within the dataset we offered. So our subsequent immediate is to ask it for new content material concepts based mostly on the GA4 information.
Right here’s my third immediate:
“Recommend 10 new subjects that aren’t on this dataset. Divide them into two teams: good for social and good for search.”
Not impressed with the output? Keep in mind, you’re solely three prompts deep into this AI-powered evaluation experiment.
My most profitable ChatGPT experiments contain 10+ prompts. Listed below are some concepts for extra prompting enjoyable:
- Which articles did very nicely on social however terribly in search?
- Which previous articles had excessive above common engagement however far under common visitors?
- Of the articles that did one of the best in social media, what did their titles have in frequent?
- I wish to perceive the variations within the titles between the articles that labored nicely in search and social. What prompts are almost definitely to assist me discover these insights?
- Create a brand new metric that blends visitors and engagement known as “Awesomeness” and present the highest 5 articles for that new metric in two teams: social and search
That final one was enjoyable however wanted extra prompting.
Aspect Observe: All people desires to check search to AI…
…however there may be actually no comparability. Search can’t do what we did right here. Search can’t provide you with new and novel responses.
Search retrieves info that already exists. Generative AI can produce new info.
Search Google for 10 new gluten free cupcake recipes based mostly on My Little Pony Characters.
…you’ll discover nothing. As a result of that info doesn’t exist right this moment.
Immediate ChatGPT for 10 new gluten free cupcake recipes based mostly on My Little Pony Characters.
…you’ll be amazed on the element, creativity and deliciousness! Check them out here.
Equally, Google Pictures searches for photos that exist. However an AI picture generator creates new photos that don’t exist.
Midjourney immediate: “cupcakes based mostly on Twilight Sparkle My Little Pony character”
Received another information for Superior Information Evaluation to munch on?
If you happen to’re not squeamish about importing information to an AI, you may need all types of information that it could assist analyze.
- Give it gross sales pipeline information. Ask AI to foretell future development.
- Give it advert efficiency information. Ask AI methods to optimize your spend.
- Give it CRM information. Ask AI to search out correlations between alternatives and closed offers.
The alternatives are limitless and thrilling. It’s a enjoyable time to export spreadsheets.
