1 of 121

AI-Powered Data Analysis

Insights and Actions for Email, Video and SEO

Presentation Title

Subtitle

Month, #, Year

2 of 121

Report

Analysis

Idea

Action!

AI and GA4

3 of 121

High-skill GA4 user

Report

Analysis

Idea

Impact!

AI and GA4

4 of 121

Low-skill GA4 user

Report

Analysis

Idea

Impact!

AI and GA4

5 of 121

High-skill AI user

Report

Analysis

Idea

Impact!

AI and GA4

6 of 121

Low-skill AI user

Report

Analysis

Idea

Impact!

AI and GA4

7 of 121

High-skill GA4 / AI user

Report

Analysis

Idea

Impact!

AI and GA4

8 of 121

Before you start uploading data…

Check your policies and legal agreements

9 of 121

Go to Settings & Beta

10 of 121

Turn this on…

11 of 121

Start your prompts from here

12 of 121

Now you’ve got the upload button!

13 of 121

Optimize titles for CTR in SERPS

Site-wide SEO analysis (GSC, GA4)

14 of 121

Include only blog URLs

Exclude branded queries

Exclude URLs with no clicks

EXPORT

15 of 121

We don’t care about this data…

EXPORT

Title tags and URLs in one report

16 of 121

Prompt

It’s got it…

17 of 121

Prompt

Check the file

18 of 121

19 of 121

What do we think of these recommendations?

20 of 121

Estimate the traffic impact

Around 700 clicks / month

21 of 121

Suggest internal links

Connect the best cheese to the best mousetraps

22 of 121

It categorizes all the articles into topics

23 of 121

High traffic pages link to �high engagement pages �on the same topics!

Prompt gives it

two criteria

24 of 121

On-page SEO edits based on GSC data

Improving the relevance of a specific page

25 of 121

Include only one URL

Exclude branded queries

EXPORT

26 of 121

Prompt

It’s got it…

27 of 121

Prompt

Check it

28 of 121

Prompt

Paste in the content of the page

29 of 121

It starts to analyze

30 of 121

The Prompt:�

  • Focus on missing keyphrases
  • Don’t sacrifice clarity or flow
  • Highlight the recommendations

31 of 121

What do you think?

32 of 121

How about these?

33 of 121

Which topics for which channels?

Ask for channel-specific recommendations (GA4)

34 of 121

Customize the report

35 of 121

Add the metrics that relate to content performance

36 of 121

Big date range

Dimension

Secondary dimension

37 of 121

Create a filter to just include the blog content

38 of 121

EXPORT

39 of 121

Delete these useless rows

40 of 121

This is what a

struggling AI looks like…

41 of 121

42 of 121

Use some Clean Up Prompts

43 of 121

Prompt

Channels

44 of 121

It suggests which would work in each channel

Ask it for new article topics

45 of 121

What do the top articles

have in common?

Recommendations for new articles with those traits

46 of 121

It’s best recommendation

47 of 121

Outline for the article…

48 of 121

source:

Or use a Persona Prompt

AI and GA4

49 of 121

Social Media Engagement Analysis

Let AI analyze your top performing social posts

50 of 121

LinkedIn Analytics

ctrl+c…

51 of 121

ctrl+v…

Unstructured data

52 of 121

Ask the AI for help…

53 of 121

Download

54 of 121

Manual clean up

55 of 121

It does more cleanup

Give it the file

56 of 121

Prompt

Analysis

57 of 121

Text analysis

58 of 121

Ask it to categorize

Social posts on which topics get the most engagement?

59 of 121

These get the most comments

These get the most shares

60 of 121

Full funnel campaign analysis

Combine data from the ESP and GA4

61 of 121

Email Metrics vs. Website Metrics

Engagement

rate

Average

engagement time

AI and GA4

62 of 121

Full-Funnel Email Metrics

Engagement

rate

Average

engagement time

AI-generated

Combined Report

AI and GA4

63 of 121

EXPORT

Big date range

64 of 121

65 of 121

Report: Traffic acquisition

Dimension: Session campaign

Secondary dimension: Date

Date range: same as ESP report

Filter: source medium contains “email”

66 of 121

EXPORT

67 of 121

68 of 121

Prompt it to

merge the datasets

69 of 121

70 of 121

GA4 Data

71 of 121

ESP Data

72 of 121

No real insights yet...

Prompt it with a role.

73 of 121

Try a Long Shot Prompt

AI and GA4

74 of 121

Benchmark performance

by topic

75 of 121

Use the utm_content parameter�and you won’t need it to categorize

76 of 121

Insights that combine �ESP and GA4 data

77 of 121

Correlations between topics and performance across the entire funnel

78 of 121

Recommendations

Prompt

79 of 121

More Strategy Prompts

80 of 121

Predicted performance

81 of 121

Campaign timing analysis

Have AI correlate dates, days and seasonality

82 of 121

Report: Traffic acquisition

Dimension: Session campaign

Secondary dimension: Date

Filter: source medium contains “newsletter”

83 of 121

84 of 121

Average engagement and conversion rates for months and days

85 of 121

86 of 121

Chris Penn has other ideas for email timing

87 of 121

88 of 121

Conversion rates of specific articles

Which articles are inspiring visitors to subscribe?

89 of 121

Visitors can subscribe from any article.

90 of 121

AI and GA4

91 of 121

First, let’s customize our Pages and screens report

92 of 121

Keep it simple.

  • Sessions
  • Users
  • Conversions

93 of 121

Now add a filter…

94 of 121

…so you’re just looking

at the blog posts

95 of 121

EXPORT

(call it traffic.csv)

Now you’ve got your traffic data!

96 of 121

Add a filter to your Pages and screens report to show just your email signup thank you page

97 of 121

Add secondary dimension to this report…

98 of 121

…showing the “Page Referrer”

99 of 121

These are the posts visitors were reading just before the subscribed

100 of 121

EXPORT

(call it conversions.csv)

Now you’ve got your conversion data!

101 of 121

You don’t need these rows.

Clean up the data.

102 of 121

103 of 121

104 of 121

105 of 121

Let’s check out this new file…

106 of 121

Looks pretty good!

107 of 121

108 of 121

These are the articles from which visitors are most likely to subscribe

109 of 121

Video Performance Analysis

Let’s give it YouTube data

110 of 121

Click on “Advanced Mode”

Go to Channel Analytics

111 of 121

Use a nice long date range

Add a bunch of metrics

112 of 121

EXPORT

113 of 121

114 of 121

Give it a role and

ask it to categorize

115 of 121

The correlation between topics and engagement!

116 of 121

Much better!

117 of 121

118 of 121

119 of 121

120 of 121

Collect everything.�Connect everything.

121 of 121

Thank you.

Reach out anytime.

Andy Crestodina

Co-founder / CMO

773.353.8301

andy@orbitmedia.com

��