Data Analysis

I was excited to dive into data work for an exciting project at The Recording Academy!

Objective: examine the effect of splitting up the two websites, and analyzing the data for a better understanding of trends and audience behavior on both sites.

Project Brief: In this project, I conducted a detailed analysis using Microsoft Excel to determine whether the Recording Academy and the Grammys should maintain separate websites. This decision was based on analyzing various Key Performance Indicators (KPIs) such as pages per session, bounce rate, and average time on site, alongside user engagement metrics during key events like the Grammy Awards.

Website Strategy for the Recording Academy and the Grammys:

Prepare the data by transforming it.

Calculate business KPIs.

Using A/B Test to see if the differences are statistically significant.

Use Excel to create charts and analyze data.

Make recommendations for the organization.

I have created a line chart displaying the daily number of visitors to the Grammy.com website, utilizing data from the Grammys Data sheet, with the dates plotted along the horizontal axis. The chart reveals noticeable spikes in visits during December and March each year, indicating that the Grammy promotions likely begin in the winter of the preceding year, with the highest spike occurring on the day the Grammy Awards are hosted.

In this section of the analysis, I focus on evaluating the strategic decision by the Recording Academy to split its online presence into two separate websites. The objective is to assess whether this structural change has led to improvements in several critical Key Performance Indicators (KPIs), namely bounce rate, pages per session, and average time on site. These metrics are pivotal for understanding user engagement and site efficacy post-implementation. Detailed calculations and insights derived from this analysis are presented below.

In my analysis for the Recording Academy, I evaluated the impact of transitioning from one website to two separate sites on key performance indicators (KPIs). Here are the main points:

Pages per Session: I calculated this metric by dividing total pageviews by total sessions. Results show a pages per session of 2.78 for the Recording Academy data, 2.25 for the Grammys data, and 1.86 for combined Grammys + TRA data. This KPI is crucial for assessing user engagement and indicates a variation in engagement across the different datasets.
Bounce Rate: By calculating the ratio of bounced sessions to total sessions, I determined the bounce rate, which reflects the percentage of visitors who leave the site without interaction. The Recording Academy data showed a bounce rate of 33.7%, the Grammys data had 40.2%, and the combined dataset was at 41.6%. This metric is essential for understanding the effectiveness of the homepage in retaining visitors.
Average Time on Site: I computed this by averaging the session duration in seconds. The average time on site was 128.50 seconds for the Recording Academy, 82.99 seconds for the Grammys, and 102.85 seconds for the combined data. This KPI helps gauge the overall engagement and content effectiveness on the website.

KPI

Null Hypothesis

There is not a statistically significant difference in the pages per session between the Grammys + TRA and the Recording Academy.

Alt. Hypothesis

There is a statistically significant difference in the pages per session between the Grammys + TRA and the Recording Academy.

A/B Testing

Objective:

To determine if there is a statistically significant difference in the pages per session metric between two websites at a 95% confidence level.

Methodology:

Conducted an A/B test to compare the 'pages per session' metric for two separate websites.
Utilized a two-tailed test approach to evaluate the data.

Results:

P-Value: The p-value obtained from the test was less than 0.05, indicating a statistically significant difference between the two websites.

Conclusion:

Based on the A/B test results and the p-value, I confidently rejected the null hypothesis in favor of the alternative hypothesis. This confirms that there are significant differences in the pages per session between the two websites, providing evidence at the 95% confidence level. The analysis demonstrated a clear variance in user engagement between the two websites, which can inform further strategic decisions regarding website optimization and user experience improvements.

CoMMUNIcate Findings

User Engagement: The data revealed a significant spike in website visits during the Grammy Awards, with visitors increasing from around 30,000 to over 1.3 million on award days. This demonstrated a heightened interest in Grammy-related content, suggesting the importance of a dedicated Grammy site to cater to this peak in visitor interest.

KPI Analysis: The analysis highlighted distinct differences in user engagement between the two sites. The Recording Academy site showed higher pages per session, lower bounce rates, and longer average time on site compared to the Grammys site, indicating different user expectations and interactions with each website.

Mobile Usage: Approximately 73.7% of site visits were from mobile devices, underscoring the necessity of optimizing mobile user experiences. Maintaining separate sites allows for focused optimization strategies tailored to the distinct audiences of each site, which could enhance overall user engagement and satisfaction.

Conclusion: Based on the analysis, I recommended keeping the websites separate. This strategy supports enhanced user engagement by allowing tailored content and functionality for each audience, thereby maximizing the effectiveness of each site.

Project Impact: This strategic recommendation is expected to improve user satisfaction and engagement, demonstrating my ability to leverage data analytics to inform and support strategic business decisions in digital media management.

Fun Fact: Ray Starck, the VP of Digital Strategy, decided to split the websites into grammy.com and recordingacademy.com to better serve the Recording Academy's various audience needs.
*In this project I worked on real data in Excel from both websites owned by The Recording Academy, the non-profit organization behind the famous Grammy Awards.

Home

Page updated

Report abuse