代写BUSI2131 Marketing Analytics Academic Year 2023-24 Spring Semester代做留学生SQL 程序

日期：2024-04-26 05:42

BUSI2131 Marketing Analytics

Academic Year 2023-24

Spring Semester

--- Coursework Guideline ---

One 2,000 word individual coursework (100%) - Electronic submission via Moodle. Deadline Date for Submission of Coursework: 15:00, 2nd May 2024.

Task

As a marketing analyst employed by a marketing consultancy firm, you are presented with information regarding four clients. Your assignment is to select two of these clients to conduct appropriate marketing analyses. You will then compile and submit a comprehensive marketing analytics report.

The report must include the following components:

1. Executive summary: A concise summary that specifies which two clients you choose and highlights the main findings and recommendations of each.

2. Report for the first client you choose (please specify client ID and/or name).

3. Report for the second client you choose (please specify client ID and/or name).

(Note: You do not need to repeat the following client information in your report)

Word Limit and Formatting

2,000 words (10% buffer is allowed). The overall word count does not include executive summary, tables, figures, references and appendix.

There is no specific requirement for the font, spacing and margins. However, you should format the report in professional way.

Harvard citation style. should be used for citations and referencing sources. See your Student Handbookfor further details.

Submission Due Date and Methods

15:00 Thursday 2nd May 2024 [Beijing Time]; online via Moodle.

Client Information

Client 1: E-Shop

E-Shop is an e-commerce site specializing in the sale of clothing and a variety of merchandise. Customers can browse through an array of products and make purchases through its online website.

E-Shop has provided a summary of their website data for the past four years.

Utilizing this data, please prepare a report to offer insights into E-Shop’s web traffic and overall performance, and provide recommendations to enhance E-Shop’s future performance.

Spreadsheet	Description
TrafficByChannel	Overview of all traffic channels.
GenderAgeSummary	The acquisition, behavior and conversion data for different age groups and gender groups.
AgeGender_Users	Users by Age and Gender Groups
AgeGender_Sessions	Sessions by Age and Gender Groups
AgeGender_Revenue	Revenue by Age and Gender Groups
AgeGender_ConversionRate	Ecommerce Conversion Rate by Age and Gender Groups

Client 2: La Retail

La Grocery is a well-established company operating in the retail food sector, having a large number of registered customers. La Grocery mainly sell products from 5 categories, namely the fish and seafood products, meat products, fruits, wines, and sweet products such as cookies and donuts. La Grocery offers products to customers through three channels: Customers can buy from its physical stores, order from catalogs, or order from company’s website.

La Retail has offered you a sample of data they have for customer relationship management. Based on the data provided, you need to conduct appropriate analyses to provide insights about La Retail’s customers and their behaviours, and give recommendations on its marketing strategies.

Complain_Record: “1” represents that the customer made complain(s) to the company in the last 99 days; “0” otherwise	Fruits: Amount spent on fruits products in the last 99 days
Year_of_Birth: The year in which the customer was born	Sweet_Products: Amount spent on sweet products in the last 99 days
Education: The customer’s level of education	Wines: Amount spent on wine products in the last 99 days
Marital: The customer’s marital status	Num_Deals_Purchases: Number of purchases made with discount
Kid_home: Number of small children in the customer’s household	Num_Catalog_Purchases: Number of purchases made using catalogue
Teen_home: Number of teenagers in the customer’s household	Num_Store_Purchases: Number of purchases made directly in stores
Income: The customer’s yearly household income	Num_Web_Purchases: Number of purchases made through company’s website
Fish_Products: Amount spent on fish products in the last 99 days	Num_Web_Visits: Number of visits to company’s website in the last month.
Meat_Products: Amount spent on meat products in the last 99 days	Recency: Number of days since the last purchase

Client 3: EAZER

EAZER is seeking to expand their international retail business and sharpen their focus on the Business-to-Consumer (B2C) marketplace.

Website:https://www.amazon.com/stores/page/BA3FECB1-F7C1-4EC9-8C6A-F201E05C89C1?ingress=6&visitId=0e5fc5cc-df1f-40ab-80c0-a0815d978471&store_ref=storeRecs_dp_aplus

EAZER’s sales team has shared you with a comprehensive dataset, including their sales records of a list of products on Amazon, records of product returns, summary of customer demographics, and an array of product reviews. Your task consists of two components:

1. Perform. an in-depth analysis of the provided data to assess the performance of EAZER’s products, identifying trends, patterns, and areas for potential improvement.

2. Formulate strategic marketing recommendations based on your analysis to increase EAZER’s sales, enhance customer satisfaction, and solidify the company's presence in the B2C marketplace.

Note: You may choose to focus your analysis on one or two specific products, or you may opt to conduct an analysis across the entire product family.

Client 4: MZK

MZK specializes in the field of electric garden equipment, specifically designed for the North American market, and is committed to providing innovative, eco-friendly, and battery-powered garden tools tailored to the needs of the North American market.

Website:https://www.amazon.com/stores/page/F61781CF-EBB5-4CC7-B3D0-4CE3B8524D72?ingress=0&visitId=96b0f09a-ffab-4310-8e1b-f0f1dee8484b

MZK has offered you their strategic plan on developing a social media account on Facebook, and a list of their competitors’ Facebook accounts. Please analyse the social media account data of these competitive brands and, in conjunction with MZK’s strategic plan, make suggestions for the operation and content planning of MKZ’s social media account.

List of Competitive brands’ Facebook accounts:

Black+Decker:https://www.facebook.com/BlackAndDecker

DEWALT:https://www.facebook.com/DEWALT

Snow Joe:https://www.facebook.com/SnowJoeCo

Worx:https://www.facebook.com/worxus

Makita:https://www.facebook.com/CLKSupertools

Greenworks:https://www.facebook.com/greenworksusa

EGO:https://www.facebook.com/egopowerplus

Litheli:https://www.facebook.com/LitheliUSA

Penalties for Late Submissions

If the coursework is submitted after the official deadline without an extension having been obtained, 5 percentage points will be deducted for each working day that the

coursework is late. This means that if you score 60 and you have a 5 percent penalty, your final mark will be 55. The only exemption to this would be if there is evidence of genuine extenuating circumstances. This is a general University regulation applied

equally across all Schools and Faculties and is not open for student negotiation.

See your Student Handbookfor further details.

Plagiarism

Plagiarism is serious academic misconduct and will not be permitted.

There are three principles to bear in mind when using other people’s work:

• You MUST acknowledge other people’s words and ideas.

• Don’t reproduce ideas unquestioningly, even when you’ve acknowledged them.

• Do use these ideas to help you think of ideas of your own. See your Student Handbookfor further details.

Marking Rubric (100%)

1. Analysis & insight (40%)

2. Data visualisation & exhibits (10%)

3. Marketing solutions, recommendations (35%)

4. Writing/text quality (5%)

5. Use of literature/ research (10%)