Consumer Insights: Search Data Analysis and L'Oreal Case Study

Key Exploratory Questions in Search Behavior

• Search engines reveal nuanced patterns regarding human behavior, geographic preferences, and curiosities:

  • Jokes search timing: People search Google for jokes least often on one specific day of the week, driven by workplace and leisure routines.

  • Dogs versus cats geographic divergence: While dogs lead cats in Google search volume across the United States, the United Kingdom, all of Europe, and all of South America, specific individual countries invert this trend with cats coming out on top.

  • Common auto-complete query patterns: Typing "Why is…" into Google generates auto-completion suggestions where the third most common completion departs from baseline scientific or philosophical curiosity.

Core Applications of Consumer Search Data

• Search data serves five primary utility functions in consumer insights and marketing strategy:

  • Uncovering private desires and anxieties: Capturing honest consumer behavior where traditional surveys fail.

  • Identifying seasonal and temporal patterns: Mapping category demand across yearly, weekly, and daily cycles.

  • Mapping regional and national variation: Understanding geographic nuances in search terminology and volume.

  • Analyzing competitive dynamics: Tracking brand market leadership and promotional responsiveness over time.

  • Spotting emerging trends: Identifying nascent consumer interest and evaluating whether it represents a fad or a trend.

Private Desires, Anxieties, and Economic Indicators

• Consumer honesty in search queries:

  • Individuals display higher honesty in Google search queries than in direct human interactions or traditional survey methodologies.

  • Search queries reveal implicit behavioral intention prior to official data collection.

• Stress monitoring in Europe:

  • Relative search volume for "stress" in France vs. the rest of Europe between $2004\text{-}01$ and $2021\text{-}07$ displays distinct volumetric spikes.

  • Key search spikes and associated terms include hand spinner, привет, and Anti-stress conference, with normalized interest indices reaching values of $10$, $20$, $30$, $40$, $50$, $60$, $70$, $80$, $90$, and $100$.

• Financial and Economic Attitudes Revealed by Search (FEARS) Index:

  • Construction: An aggregated daily index built from search volume tracking economic anxiety terms including "recession," "unemployment," and "bankruptcy."

  • Empirical finding: An increase in the FEARS index directly correlates with financial capital shifting out of equity mutual funds and moving into bond funds.

• Unemployment tracking and economic forecasting:

  • When individuals experience job loss, they do not immediately register in official government statistical repositories.

  • Sequential consumer behavior: Individuals first perform search queries such as "Where's the unemployment office?" prior to filing formal claims for unemployment benefits.

  • Search volume provides an early behavioral indicator of consumer intent prior to official metric publication.

  • Statistical correlation: Pearson correlation coefficient $r = 0.79$ between Google searches for "unemployment office" and official U.S. initial jobless claims.

• Temporal shifts in intent:

  • Alcohol consumption search queries spike on December $31\text{st}$ (e.g., searches for "vodka"), whereas post-consumption recovery queries spike on January $1\text{st}$ (e.g., searches for "hangover").

Seasonal and Temporal Patterns in Consumer Search

• Category temporal periodicity:

  • Product categories operate on structured annual, weekly, and daily temporal clocks.

  • Seasonal dish consumption in France ($2004$ to present): "Soup" searches reach peak values during cold winter months around January $1$, whereas "Barbecue grill" searches peak during summer months around June.

• Comparative pizza search patterns (United States vs. France over $90\text{-}\text{day}$ periods):

  • United States pizza search dynamics:

  • Weekly peak: Highest interest consistently occurs on Saturday and Sunday.

  • Key annual event spikes: Spikes occur on the day before Thanksgiving, Christmas Eve, New Year's Day (January $1$), and Super Bowl Sunday in February.

  • France pizza search dynamics:

  • Weekly peak: Highest interest consistently occurs on Sunday.

  • Specific calendar and promotional spikes: Spikes occur on Monday $11$ November (Holiday), the France vs. Ukraine World Cup Qualifier, Christmas Eve, Monday $1$ January, and Tuesdays due to promotional price reductions at Domino's.

Regional and National Variations in Consumer Demand

• Identical search terms exhibit varying underlying meanings and volume profiles across different geographical regions.

• European Sneaker Campaign Scenario (Nike Consumer Insights Analysis):

  • Context: Regional media allocation across France, Germany, Italy, Spain, and the United Kingdom under media budget constraints.

  • Raw Google Trends search scores ($0\text{-}100$ scale) by country and month:

  • England: Jan ($13$), Feb ($14$), Mar ($14$), Apr ($14$), May ($14$), Jun ($14$), Jul ($13$), Aug ($13$), Sep ($13$), Oct ($14$), Nov ($15$), Dec ($35$). Annual peak occurs in December.

  • France: Jan ($20$), Feb ($21$), Mar ($22$), Apr ($22$), May ($20$), Jun ($20$), Jul ($18$), Aug ($19$), Sep ($21$), Oct ($22$), Nov ($21$), Dec ($21$). Twin peaks occur in Spring (March/April) and Autumn (October).

  • Germany: Jan ($12$), Feb ($16$), Mar ($17$), Apr ($15$), May ($12$), Jun ($12$), Jul ($13$), Aug ($13$), Sep ($11$), Oct ($10$), Nov ($25$), Dec ($30$). Strong end-of-year peak in November and December.

  • Italy: Jan ($27$), Feb ($26$), Mar ($33$), Apr ($38$), May ($34$), Jun ($25$), Jul ($25$), Aug ($25$), Sep ($26$), Oct ($26$), Nov ($21$), Dec ($21$). Highest overall volumetric search baseline, with a prominent Spring peak across March, April, and May.

  • Spain: Jan ($8$), Feb ($8$), Mar ($9$), Apr ($8$), May ($7$), Jun ($7$), Jul ($8$), Aug ($9$), Sep ($10$), Oct ($9$), Nov ($10$), Dec ($15$). Lowest absolute search index, peaking in December.

Competitive Dynamics and Promotion Timing

• E-Commerce promotional event optimization:

  • Wireless earbuds regional brand manager scenario across Shopee, Lazada, and Amazon platforms.

  • Key promotional mega-events evaluated: $9.9$, $10.10$, $11.11$ (Single's Day), $12.12$, Black Friday / Cyber Monday, Amazon Prime Day, and Prime Big Deal Days.

  • Platform market dominance dynamics: Shopee captures peak interest during $11.11$, whereas Amazon commands peak interest during Black Friday within the same urban markets.

Case Study: Strategic Hair Category Analysis for L'Oreal

• Evaluation of hair style variations for brand decision-making (Marie Gulin at L'Oreal):

  • Ombré hair definition:

  • Characteristics: Smooth, blended color gradient transitioning from dark roots to light ends, typically executed from the jawline downward.

  • Dip-dye distinction: Dip-dye serves as the sharper, less blended structural variant of ombré.

  • Technical process: Bleaching or lightening applied exclusively to the lower portion of the hair.

  • Tie-Dye (Rainbow / Tie-dye) hair definition:

  • Characteristics: Complex, high-maintenance multicolored rainbow effect.

  • Technical process: Requires bleaching hair to a pale base before applying multiple vibrant or neon dyes (e.g., pink, green, purple).

  • Splat hair definition:

  • Characteristics: Temporary, brand-based vivid splashes of color that are accessible to apply.

  • Technical process: Usually packaged in consumer retail kits containing bleach and one or more vibrant shades.

Consumer Sentiment Analysis on Social Media

• Social media feedback on the Ombré aesthetic demonstrates divided market perceptions:

  • Negative structural interpretations:

  • Faith: "I think it always just looks like bad roots."

  • Heather: "I absolutely think it just looks like you’re too broke or lazy to get your hair colored, on anyone."

  • Vanessa: "This is all cause of the recession guys"

  • Amanda: "HELL NO! It looks like they couldn’t afford to dye their roots."

  • Positive consumer adoption responses:

  • KRT: "I love, Love, LOVE ombre hair!!"

  • Morgan: "I love this trend! I have an appointment to get it done next week."

  • srm: "I love my ombre hair!! I never have to get my roots done[.]"

Conceptual Framework: Fads vs. Trends

• Fad definition:

  • A short-lived burst of popularity driven primarily by novelty, artificial hype, or social imitation that experiences rapid acceleration and equally rapid decline.

• Trend definition:

  • A sustained pattern of structural change that develops over an extended timeline, demonstrates durability, and reflects underlying shifts in consumer behavior, core values, or social lifestyles.

Course Logistics and Semiotic Preparation

• Semiotic literature readings for upcoming module:

  • Note on semiotics

  • Kapferer on brand identity

• Applied search data assignment guidelines:

  • Integration of Google Trends search data into group project analysis.

  • Breakout room team collaboration structure with immediate support available via Telegram.