The project delved into analyzing the comprehensive impact of viral video marketing on Squatty Potty's brand performance. Leveraging data-driven insights, I examined key metrics such as paid views per dollar spent, engagement rates (shares, likes, and comments), organic views generated from paid views, website visit conversion rates, and overall sales conversions. The analysis also extended to Facebook campaign targeting, assessing conversions and impressions across various demographic groups. Additionally, I explored the revenue per conversion across different sales channels, offering projections for future marketing initiatives based on historical performance. This approach provided actionable strategies for optimizing viral video campaigns, enhancing customer targeting, and improving sales channel efficiency.

Key Skills:
• Viral Marketing Analysis: Understanding the mechanics of viral content and its impact on brand visibility and engagement.
• Social Media Analytics: Evaluating engagement metrics across platforms to gauge audience interaction and content virality.
• Conversion Rate Optimization: Analyzing pathways from content viewership to website visits and conversions to refine marketing strategies.
• Customer Segmentation: Targeting specific audience groups based on behavior and preferences to maximize campaign effectiveness.
• Financial Analysis: Assessing revenue per conversion to inform pricing strategies and marketing budget allocation.
• Strategic Planning: Crafting recommendations to leverage insights for future marketing efforts, balancing cost, engagement, and revenue generation.
• Data Visualization: Utilizing charts and graphs to illustrate key findings and trends enhances understanding and decision-making.