Assignment 3 Marketing Campaign Analysis

docx

School

Columbia University *

*We aren’t endorsed by this school

Course

5100

Subject

Marketing

Date

Feb 20, 2024

Type

docx

Pages

3

Uploaded by UltraMoon13225

Report
1. Taskabella conducted this marketing campaign using an experimental design. What was the conversion rate? Explain whether or not you believe the advertising campaign was effective. (15 points) The conversion rate was approximately 2.54%, calculated from 15,000 handbag purchases out of about 590,000 users targeted. Luxury products, such as Taskabella's handbags, can exhibit lower conversion rates because of their higher   price and targeted   markets. Therefore, the observed conversion rate of 2.54% is significantly remarkable. 2. What was the increase in revenue, assuming $40/handbag, resulting from the campaign? (15 points) The increase in revenue resulting from the campaign was $600,000 calculated by multiplying the 15,000 handbags sold with the price of $40 per handbag. 3. What was the ROI of the campaign based on revenue (10 points)   Total Revenue = Number of Handbags Sold * Price per Handbag = 15000*40 = 600000 Total Cost = (Total Impressions / 1000) * Cost per Thousand Impressions = 14500000/1000*9 = 130500 ROI = (Total Revenue - Total Cost) / Total Cost = 359.77% 4. What age group(s) represent Taskabella’s major customer demographic? Explain the rationale for your answer (50% of sales)?   (10 points) All 3 age groups are of similar level. The second group has a high proportion of 34.8%. The third group is slightly lower, at 34.0%. The first group accounts for 31.2% of total sales. 5. What income group(s) represent Taskabella’s major customer demographic (50% of sales)? (10 points) There is no group dominating that come closer to 50% of sales. The highest group, accounting for 26.9% of sales, was the third group with annual income range from 50K to 100K. The 4 th group with income from 100K to 150K ranked second with the 25.5% of sales. The group ranked third is much lower with a percentage of just 16.6. It is the group of customers with income ranging from 150K to 200K.
6. What is the minimum threshold-level of impressions (the nearest 15) required for the campaign to be effective?   Develop a graphic to illustrate your answer. (10 points) We can see from the graph that 38 [(30+45)/2=37.5] is proper threshold for the campaign to be effective. At this level the conversion rate jumps to above 2.5% and keep increasing. 7. At what level of impressions (rounded to the nearest 15) does the conversion in the treatment group plateau? Develop a graphic to illustrate your answer.   (10 points) We can see from the graph that staring from [90, 105], the conversion in the treatment group exceeds 15% for the first time and remain at a high level ever since.
8. The marketing campaign manager wants to operationalize your insights, and asks for a range of impressions to purchase.   What is your recommendation? Explain the rationale for your recommendation. (10 points) I would recommend a range of 30 to 90 impressions. The lower bound, 30, starting slightly below the threshold, can ensure that the campaign captures the initial increase in conversion rate effectiveness. The upper bound, 90, indicates that any further invest would have a diminishing marginal returns 9. Based on your presentation of the results of your analysis to the leadership team of Taskabella, the president of Region 3 believes she should focus all of her marketing budget on the demographic segment that you identified in Question 4.   Do you agree with her decision?   Explain the rationale for your answer. (10 points) Given the relatively balanced contribution of each age group to total sales, it would be more proper to adopt a diversified marketing strategy that targets all age groups, with perhaps a bit more focus on Age Group 2, since it currently has the highest sales proportion. Completely focusing the marketing budget on just one demographic segment could potentially lead to missed opportunities and reduced sales in the other segments.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help