Aim

• To understand consumer demographics
• To understand consumer’s product preferences
• To evaluate brand awareness
• To provide recommendations for strategic decision-making

Tools & Skills

• Microsoft Excel
• Microsoft PowerPoint
• Descriptive Analysis
• Data Visualization
• Presentation Design

Analysis

Demographics

The survey had 10,000 respondents, with a demographic skew towards males (60%) and individuals aged 15-45 years old (94%). A significant portion of respondents resided in Tier 1 cities (74%)

Production Development

56% of respondents think Codex energy drink is either poor(★), below average(★★) or average(★★★). Reduced sugar content, more natural content & wider flavor range topped the list of improvements that respondents would love to see in energy drinks. 75% of respondents preferred compactible, portable cans, innovative bottle designs and collectible packaging. 50% of respondents would love to have natural/organic ingredients in their energy drink

Brand Awareness

Less than 50% of respondents knew about Codex energy  drink before filling out the survey. Less than 50% of respondents had tried Codex energy  drink before filling out the survey. Less than one-quarter of respondents perceived the brand name/logo/design as positive. 20% of respondents have not tried Codex energy  drink because they are unfamiliar with the Codex brand.

Advertisement

Respondents often encountered energy drink advertisements through online ads (40%) and TV commercials (27%). They typically purchase energy drinks from supermarkets (45%) and online retailers (26%)

Recommendations

1. Launch new product variants that satisfy consumer expectations, such as reduced sugar content, more natural ingredients, portable and innovative packaging. Use natural or organic extracts of key energy drink ingredients, such as natural caffeine, vitamins, and sugar extracts.
2. Enhance the brand’s visual identity by refining the logo, name, design, and tagline to improve consumer perception. Strengthen brand awareness through targeted campaigns, advertisements, and strategic publicity efforts to increase recognition and engagement.
3. Advertisements and commercials should emphasize key consumer motivations for energy drink consumption, such as mental alertness, focus during work/study, increased energy, and fatigue reduction. The messaging should reinforce that Codex Energy Drink is both healthy and effective while showcasing its rich flavors and natural/organic supplements along with their added benefits. Additionally, campaigns should highlight product availability in supermarkets and online retail stores. To maximize reach and impact, priority should be given to online ads, TV commercials, and outdoor billboards.