This project presents an interactive Website Traffic Analysis Dashboard designed to monitor website performance, user engagement, traffic acquisition channels, and channel effectiveness during the April–May reporting period.

The dashboard provides stakeholders with a quick, data-driven view of how users interact with the website, which traffic sources generate the highest volume, and which channels deliver the most engaged visitors.

Website owners and marketing teams often struggle to:

• Understand where website traffic originates.
• Identify the most valuable traffic acquisition channels.
• Measure visitor engagement quality.
• Monitor daily performance trends.
• Optimize marketing spend based on channel effectiveness.

Without a centralized analytics solution, decision-making becomes reactive rather than data-driven.

Developed an interactive dashboard that:

• Tracks website traffic and engagement metrics.
• Compares performance across acquisition channels.
• Monitors daily traffic trends.
• Evaluates channel effectiveness using engagement metrics.
• Highlights top-performing traffic sources.
• Enables quick identification of optimization opportunities.

Analyzes total sessions generated by each traffic channel.

• Organic Social generated the highest traffic volume with 61K sessions.
• Direct traffic contributed 37K sessions, indicating strong brand awareness and returning visitors.
• Organic Search and Referral traffic were significant acquisition channels.
• Email and Organic Video generated negligible traffic, suggesting underutilized marketing opportunities.

Tracks daily performance patterns for:

• Sessions
• Engaged Sessions

• Daily sessions fluctuated between approximately 4.5K and 7.7K.
• Peak traffic occurred around the middle of the reporting period.
• Consistent traffic levels indicate stable user acquisition.

• Engaged sessions ranged from approximately 2.4K to 4.2K daily.
• Highest engagement coincided with traffic spikes, suggesting quality traffic during peak periods.
• Temporary dips may indicate campaign inactivity or lower-performing content periods.

Measures engagement rate across traffic channels.

• Organic Video generated the highest quality traffic with a 77.30% engagement rate.
• Referral traffic delivered highly engaged users at 66.64%.
• Organic Search maintained strong engagement while contributing substantial traffic volume.
• Direct traffic generated high volume but lower engagement compared to Organic Search and Referral.
• Unassigned traffic showed extremely poor engagement, indicating potential tracking or attribution issues.

Evaluates channel performance using:

• Engagement Rate
• Events per Session
• Engaged Sessions

• Referral traffic achieved the strongest overall efficiency, combining high engagement with high events per session.
• Organic Search delivered a strong balance of traffic volume and engagement quality.
• Organic Social drove the largest traffic volume while maintaining healthy engagement.
• Email and Unassigned channels contributed minimal value.

Organic Social generated the highest number of sessions (61K), making it the primary acquisition source.

Although traffic volume was low, Organic Video achieved the highest engagement rate (77.30%), indicating exceptionally high-quality visitors.

Referral traffic demonstrated both strong engagement (66.64%) and high channel efficiency.

Organic Search combines substantial traffic volume (33K sessions) with strong engagement (58.21%), making it one of the most reliable acquisition channels.

Email generated negligible traffic and relatively low engagement, suggesting campaign optimization opportunities.

The Unassigned channel's very low engagement rate (0.72%) may indicate tracking or tagging issues.

• Continue producing high-performing social content.
• Replicate successful campaigns.
• Expand reach across additional social platforms.

• Increase video content production.
• Repurpose high-performing social content into video formats.
• Expand distribution through video-focused channels.

• Identify top referral sources.
• Build strategic partnerships with high-performing referrers.
• Increase backlink and guest-content initiatives.

• Improve content targeting high-intent keywords.
• Strengthen technical SEO.
• Focus on pages generating the highest engagement.

• Review audience segmentation.
• Test subject lines and content personalization.
• Optimize send timing and campaign frequency.

• Investigate the Unassigned traffic source.
• Review UTM tagging standards.
• Validate analytics implementation.

• Power BI Desktop – Dashboard Development
• Power Query – Data Cleaning & Transformation
• DAX (Data Analysis Expressions) – KPI Calculations
• Microsoft Excel / CSV Dataset – Data Source
• Data Modeling – Relationship Management

• Total Users
• Total Sessions
• Session Trends
• Channel Distribution

• Engaged Sessions
• Engagement Rate
• Average Engagement Time
• Events per Session

• Traffic Channel Performance
• Channel Efficiency
• Top Performing Channels

This dashboard enables stakeholders to:

• Monitor website performance in real time.
• Identify high-performing acquisition channels.
• Improve marketing budget allocation.
• Increase user engagement.
• Make faster and more informed business decisions.
• Optimize digital marketing strategies based on measurable outcomes.

The analysis reveals that Organic Social is the primary traffic acquisition channel, while Organic Video and Referral traffic generate the most engaged users. Although overall engagement remains healthy at 55.33%, opportunities exist to improve Email performance and resolve attribution issues within Unassigned traffic.

By focusing on high-performing channels and improving traffic tracking, the organization can increase engagement, improve marketing efficiency, and maximize website growth.

Cosmos Isuru

Data Analyst | Business Intelligence Analyst | Power BI Developer | HSE/SAfety Analyst

• Power BI
• SQL
• Excel
• Data Visualization
• Business Intelligence