Streamlining data analysis with AI

AI for Marketing

Adel Nehme

VP Content, DataCamp

Why marketers need strong analytical skills

AI for Marketing

The AI augmented analytics workflow

AI for Marketing

What's behind the drop?

AI for Marketing

The dataset

Article Title September October November December January
Ultimate Guide to SEO in 2025 12500 11800 11200 10500 9800
10 Content Marketing Strategies That Work 8900 9200 9500 9800 10100
How to Build an Email List Fast 15200 13100 11500 9200 7800
Social Media Marketing for Beginners 6700 6900 7100 7200 7400
Google Analytics 4 Complete Tutorial 11400 9200 7800 6100 4900
Content Calendar Template and Tips 5800 6000 6200 6300 6500
... ... ... ... ... ...
AI for Marketing

Step by step analysis with AI

  • Goal: Build a line plot showing total traffic month over month across our blog.
  • Context: Dataset contains a set of blog articles with month over month traffic.
AI for Marketing

Traffic decline visualized

AI for Marketing

Uncovering the declining articles

  • Goal: Build a multiline plot where each article is visualized as an individual line on the plot.
  • Limitations: Only include articles with average traffic above 5,000 a month.
AI for Marketing

Exploratory data analysis with AI

AI for Marketing

Exploratory data analysis with AI

AI for Marketing

Isolate the declining articles

  • Goal: Isolate the articles with the biggest traffic decline from September to January.
  • Limitations: Return articles ordered by most decreasing to least decreasing.
AI for Marketing

The culprits

AI for Marketing

Next steps

  • Goal: Create an executive report.
  • Context: Report content and details.
  • Limitations: Report length and format.
AI for Marketing

From data to report

AI for Marketing

Bad prompts vs good prompts

Element Good Prompt Bad Prompt
Goals Create a line chart showing total monthly traffic to visualize trends clearly. Show me the traffic.
Goals Identify the top 3 articles that experienced the largest traffic decline over time. Analyze this.
Context This data represents blog traffic from our main marketing site. Here's some data.
Context We noticed a decline in the dashboard metrics and want to identify the root cause. Look at this.
Limitations Only include articles that had more than 5,000 visits in September. Find the problems.
Limitations Focus your analysis on articles with a decline greater than 2,000 visitors. Tell me what's wrong.
AI for Marketing

Context management

AI for Marketing

Data privacy and PII

AI for Marketing

Quality and iteration

AI for Marketing

Let's practice!

AI for Marketing

Preparing Video For Download...