Case $3-$Mkt $570$

Here is an assignment that is aimed to help you utillize ChatCPT for marketing analytics. Below is a fictitious company and a dataset that includes information for this company to make some decisions.

Background:

Glow Beauty Inc., a mid$-$sized cosmetics company in North America, plans to introduce a new vegan and cruelty$-$free makeup line. The line will include foundation, lipstick, and eye makeup. The company aims to optimize its launch strategy by analyzing the market, setting prices, planning promotions, and deciding on distribution channels.

Attached you will find an Excel sheet that includes the following worksheets.

$1$ Customer Surveys $(200$ entries$)$: Data on customer preferences for cosmetics$,$ focusing on brand loyalty, product type preference, and willingness to try vegan products.

$2$ Competitor Prices $(5$ competitors$)$: Information on similar vegan cosmetics products by competitors, including price points and market share.

$3$ Sales Data $($last $3$ years, $500$ entries per year$)$: Sales records showing product type, customer demographics, and purchase quantities.

$4$ Marketing Campaign Results $($last $3$ campaigns$)$: Data on different marketing channels with metrics like reach, engagement, and conversion rates.

Explanation of each worksheet is as follows:

Customer Surveys

Customer$\_$ID: Unique identifier for each customer.

Age: Customer's age.