Mini Project: Analyzing My Blog Website Traffic Using Excel (Beginner Data Analytics)

Mini Project: Analyzing My Blog Website Traffic Using Excel (Beginner Data Analytics)

In this project, I analyzed the traffic data from my own Blogger website to learn the basics of data analysis and data visualization. I looked at how many visitors my blog gets, which posts are the most popular, and how traffic changes over time. I created simple charts to make the data easier to understand and to spot patterns. Finally, I wrote a short blog-style report explaining what I discovered and what these results mean for improving my blog. This project helped me understand my audience better and practice using data to make decisions.

Step-by-Step Instructions

Step 1: Get the Data (From Blogger / Google Analytics)

I collected data from my Blogger stats. I looked for:

• Page views (how many times pages were visited)

• Dates (when visits happened)

• Pages (which blog posts or pages were viewed)

I copied this data into a table using Google Sheets or Excel.

Data Used

For this project, I used my blog’s daily page views data from 23-Jan to 21-Feb. The data includes two columns: Date and Page Views. This shows how many times my blog was visited each day.

The data shows that my blog usually gets a small number of visitors each day, but sometimes there are big spikes in traffic. The biggest spike happened on 10-Feb with 1573 page views, which is much higher than normal. This could mean one post became popular or was shared somewhere. Most other days stay below 100 views, which shows my blog traffic is still growing but not very high yet.

Step 2 : Make 1 Simple Chart

In Excel or Google Sheets:

• Select your Date and Page views columns

• Insert → Line Chart

• This chart will show:

• Normal days (low traffic)

• The big spike on 10-Feb (1573 views)

Traffic Trend Chart

This chart shows how my blog traffic changes over time. Most days have low traffic, but there is a very big spike on 10-Feb. This makes it easy to see patterns and unusual days.

Step 3: Add Final Numbers 

In Sheets/Excel, calculate:

• Total page views:
  =SUM(B2:B31)
=2396

• Average per day:
  =AVERAGE(B2:B31)
=79.867

• Highest day:
  =MAX(B2:B31)
1573

• Lowest day:
  =MIN(B2:B31)
=1

In this project, I calculated the total, average, highest, and lowest page views. The highest page views in one day was 1573 on 10-Feb, and the lowest was 1 view on some days. This shows that my traffic is not the same every day and sometimes changes a lot.

Conclusion

This mini project helped me understand how data analytics can be used to analyze website traffic. I learned that charts make data easier to understand and that one special day can change the overall results a lot. In the future, I want to analyze which posts get the most views and where my visitors come from so I can improve my blog.