These are a few of the largest challenges/alternatives for content material entrepreneurs:
- See the efficiency of content material in varied channels
- Use that knowledge to tell choices about what to publish
- Align matters with promotion channels
The most effective 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 knowledge 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 put it on the market. 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 function of ChatGPT that permits you to add information. It additionally attracts charts and writes code. On the time of this writing, Superior Information Evaluation is accessible solely to paid customers. So for those who haven’t but, pony up the $20.
- Google Analytics with at the very least 6 months of knowledge. I’ll do that in GA4, however for those who don’t have a lot knowledge there but, you possibly can return and do all of it with historic knowledge from Common Analytics.
1. Export content material efficiency knowledge from GA4
GA4 has the efficiency of your content material advertising and marketing in varied methods (visitors and engagement) and in varied channels (natural search, social media, and so on.). We simply have to get the information out with probably the most helpful dimensions and metrics.
We’ve printed an in depth information on methods to audit your content material in GA4, however right here we’re simply getting knowledge 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 here are my advisable metrics for measuring content material efficiency:
- Engagement fee
- Common engagement time
- Session Conversion fee
That is loads to offer you sturdy clues into what matters are working effectively. Click on Apply then click on Save. Go forward and Save adjustments to the present report as a result of why not. These little customizations are stuff 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 all the web site, so we have to create a filter to Embody simply the URLs that include the phrase “weblog.”
Observe: In case your weblog content material isn’t all in a standard listing, you’ll should enter one thing else that tells Analytics methods to embrace 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: for those who don’t have Web page Location, use web page path and display screen 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 screen identify.
This may assist ChatGPT know the matters of our articles. That is extra significant for our evaluation than the URLs.
After all, not all content material works everywhere. So let’s add some knowledge concerning 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. This may 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 tough 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 received our knowledge. Often, right here’s the place I’d advocate wanting on the knowledge within the report. However not in the present day. 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 wanting on the file. However not in the present day! No have to even open the file…
2. Import the information into the ChatGPT Superior Information Evaluation
The onerous half is finished. Be at liberty to shut your Google Analytics tab now. We’re finished 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 have to go to settings and activate Superior Information Evaluation, which is presently within the Beta Options part.
It is extremely 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 knowledge to an AI. Or for those who’re an company, your purchasers could have AI restrictions of their authorized agreements with you, the seller. When you’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 concerning the knowledge and confirming that it may possibly do the evaluation.
Right here’s my first immediate:
“I’m supplying you with numerous Google Analytics knowledge 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 could be very very spectacular. It should reorganize and reformat the information as many instances as essential to get what it wants. For GA4 knowledge, this implies eradicating the feedback within the first rows.
There isn’t any want to wash up the information. ChatGPT’s Superior Information Evaluation does all of it for you.
As soon as it’s finished, it should let you know it’s prepared.
|Alexander Holl, 121WATT
“Take into consideration the place you possibly can obtain digital advertising and marketing knowledge in .csv format. Some instruments that supply .csv knowledge embrace Google Search Console, GA4, YouTube Analytics, and search engine optimization instruments like Sistrix, ScreamingFrog, SEMrush and Google Adverts.
Typically, you’ll encounter knowledge that you simply’re uncertain methods to deal with. As an illustration, you might need a report out of your Google Adverts 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 Adverts account. Because the particular person accountable for search engine optimization, what can I study from this knowledge?”
3. Ask the AI to investigate the GA4 knowledge
Subsequent, give it an in depth immediate. The most effective prompts inform the AI who it’s and what abilities 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 knowledgeable and making data-driven suggestions. Mix the information from the columns to advocate new digital advertising and marketing matters that will doubtless have good visitors and engagement. Manage the matters into two teams: people who would carry out effectively in social vs. natural search”
I’m asking it to think about 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’re opposites!
To finish the evaluation, Superior Information Evaluation wanted to regulate the dataset some extra. As soon as it completed, it decided, primarily based by itself weighting of visitors and engagement, the top-performing articles in each search and social.
Amazingly, it linked to every article within the listing. I’m actually undecided how as a result of the URLs weren’t within the dataset. It shared this be aware beneath the lists: “Observe: the precise URLs are inferred primarily based on the title and never supplied within the dataset.” …however how??
4. Ask the AI to advocate new matters primarily based on the information
Technically, Google Analytics can do all the things we’ve finished to this point. You’ll be able to sort in full questions and it’ll attempt to generate a report with the reply. However there are big variations.
It doesn’t present solutions in English.
It may’t have a dialog primarily based 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 supplied. So our subsequent immediate is to ask it for new content material concepts primarily based on the GA4 knowledge.
Right here’s my third immediate:
“Counsel 10 new matters 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 here are some concepts for extra prompting enjoyable:
- Which articles did very effectively on social however terribly in search?
- Which previous articles had excessive above common engagement however far under common visitors?
- Of the articles that did the very 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 effectively in search and social. What prompts are most 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.
Facet Observe: All people needs to check search to AI…
…however there’s 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 primarily based on My Little Pony Characters.
…you’ll discover nothing. As a result of that info doesn’t exist in the present day.
Immediate ChatGPT for 10 new gluten free cupcake recipes primarily based on My Little Pony Characters.
…you’ll be amazed on the element, creativity and deliciousness! Check them out here.
Equally, Google Photos searches for photographs that exist. However an AI picture generator creates new photographs that don’t exist.
Midjourney immediate: “cupcakes primarily based on Twilight Sparkle My Little Pony character”
Obtained some other knowledge for Superior Information Evaluation to munch on?
When you’re not squeamish about importing knowledge to an AI, you might need all types of knowledge that it may possibly assist analyze.
- Give it gross sales pipeline knowledge. Ask AI to foretell future progress.
- Give it advert efficiency knowledge. Ask AI methods to optimize your spend.
- Give it CRM knowledge. Ask AI to search out correlations between alternatives and closed offers.
The alternatives are countless and thrilling. It’s a enjoyable time to export spreadsheets.
#mix #ChatGPT #GA4 #content material #advertising and marketing #insights