Advertising Integration Analysis (AIA)

Consumer Packaged Goods

The Challenge

The Client is an American beer brewing company.  They approached Management Science Associates, Inc. (MSA) seeking to better understand how advertising leads to increased brand loyalty and sales by linking various measures of advertising quality and effectiveness to key sales indicators for their flagship light beer.

This data heavy project involved integrating multiple data sources; ad tracking, behavioral tracking, copy tests, GRPs, PR and marketing mix coefficients, across brands, ethnic groups, age groups, gender and geographic regions.

What Did MSA Do

MSA’s Advertising Integration Analysis (AIA) solution was the perfect approach to clarifying both short-term and long-term impacts of advertising within the category and for the brand.  In this case, we applied our AIA solution using five analytical analysis steps:

  1. Create a large dataset by integrating ad tracking and behavioral tracking data based on age groups, gender, regions and ethnicity.  Then tabulate and graph all of the variables to get an overall understanding of data trends.

  2. Create 2-dimensional maps to visualize which ad tracking and behavioral tracking variables are key drivers of ‘brand attachment’ vs. ‘behavioral motivations’ and how they relate to each other.  Create 2-dimensional maps for the category, key brands, and for ethnic groups, age groups, gender and geographic regions for the subject brand.

  3. Use Factor Analysis to consolidate the data and help manage the correlation between similar variables.

  4. Use Structural Equation Modeling (SEM) to quantify the relationships between measures, such as awareness and loyalty, and to see how they vary across demographic groups and brands.

  5. Create a second dataset integrating the ad tracking data with GRPs, copy tests, marketing mix coefficients and PR data.  Use this secondary data set to model the impact of TV advertising on awareness via Regression Analysis.

 

business technology professionals

The Results

MSA’s solutions transform complex challenges into measurable results through real-world client success stories.

Ready to work with us?

case studies

See More Case Studies

Ticket Sales Forecasting

An internationally acclaimed symphony orchestra with over a 100-year history needed a reliable solution for estimating future ticket sales, especially subscription-based sales, to help better manage their internal budgeting process and program management.

Learn more
warehouse workers looking at tablets

Data Warehousing

Fortune 500 company had eight disparate data streams, which required significant manual intervention to align and analyze for monitoring and measuring business performance. Process was inefficient, time consuming and costly.

Learn more