top of page
Mindshare.jpeg

The Contest:

Mindshare is a global media agency network across 86 countries that creates new media experiences for global clients and their consumers. Mindshare’s Advanced Analytics team organized its second annual virtual hackathon for graduate students and challenged them to create a media plan for two hypothetical perfume brands in a span of 24 hours. The assignment included data analysis, modeling, media strategy, and more.

​

Challenge: â€‹

Haute is a well-known perfume brand with two major product lines: Ambré Aromatique (a new product launched in 2019) and Léger Floral (an established brand). Student teams were given audience measurement and historical performance data for  Haute and were tasked with pitching their ideas on how the brand can grow its business and plan its media.

​

Key client questions included:

  • Who is our target audience? How should we reach out to them?

  • How did media drive our brand consideration and sales revenue in 2018-2019?

  • How shall we plan media for 2020 to maintain the same growth rate?

​​

Methods:

In order to answer client questions, my team and I developed an analytical framework to tackle each key pillar and each data set accordingly. We utilized audience demographics and consumption data to identify the right target audience for Haute, while media and sales performance data were used to devise a media strategy for 2020. Tools and techniques used include Excel (PivotTable, graphing) and Tableau (graphing, visualization, dashboard)

 

Key Findings:

  • Women aged 25-54 is the key target market

  • Digital, Pinterest, Magazines, and Search showed high-performing KPIs and are recommended for future media strategy to drive brand growth. Facebook and Youtube didn't yield desired results

  • Seasonality affects perfume sales considering that perfumes are popular holiday gifts

​

My Role:

Marketing Analyst: I led Fordham University's competition in devising a game plan for the 24-hour hackathon based on each member's strengths and technical skills. As the marketing analyst, I utilized Excel PivotTable and Tableau to analyze historical performance data, identify key insights, and visualize findings with Tableau charts and dashboards. I also developed a script to deliver our team's story to the jury board, was one of the main presenters in the pitch, and took charge of the Q&A portion.

-- pitch deck --

-- tableau dashboard --

Screen Shot 2022-02-27 at 7.50.26 PM.png
Screen Shot 2022-02-27 at 7.50.05 PM.png
bottom of page