Question: Marketing project Task: Using Excel: explore customer groups, identify meaningful segments. Evaluate segments, select target segments Design marketing activity: a. New programs (service bundles), or
Marketing project Task: Using Excel: explore customer groups, identify meaningful segments. Evaluate segments, select target segments Design marketing activity: a. New programs (service bundles), or b. Promotional activities (message, ad, price-off, loyalty perks, etc).This is exactly what real telco marketers do You learn to: Turn data into insights Apply a target evaluation framework Propose realistic marketing actions Skills you practice: Pivot table analysis Storytelling with data Linking analysis to decision making, program formulation Reward: 1-3 points for solution (based on quality),+2 points if you volunteer to present next week. Gender: 2Marital status: 2Age groups (generations): 4Education: 2Profession: ~10Work experience groups: 4Family size: 9=11,520 possible customer profiles Give me a ideas for a solution to the problem, we have a data set in excel and are using pivot tables to anolize the data
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
