Ireland Assignments .ieIRELAND.ieASSIGNMENTS
Order Now Log In
  • Home
  • Services
    Writing Services
    • Essay Writing Services
    • Dissertation Writing
    • Thesis Writing Service
    • Literature Review Writing
    • Research Paper For Sale
    • Report Writing Assistance
    • Do My Assignment
    • Write My Essay
    • Buy Assignments Online
    • Irish Homework Help
    AI Support & Referencing
    • Assignment Review Service
    • AI-Free Assignment Help
    • Remove AI From Your Assignment
    • Citation and Referencing Help
    • AI Guidance for Students
    Assignment Type
    • Learner Record Writing
    • Skill Demonstration Assignments
    • Work Experience Diary
    • Reflection Journal
    • Online Exam Help
    • QQI Level 5
    • QQI Level 6
    Course
    • Nursing
    • Childcare
    • Healthcare
    • SNA (Special Needs)
    • Care of Older People
    • Child Development
    • Care Skills
    • Care Support
    • Disability Awareness
    • Infection Prevention
    • Health & Safety at Work
    Online Degree Course
    • Psychology Assignments
    • Early Childhood QQI Assignments
    • Montessori Assignments
    • Palliative Course Assignments
    • Communications FETAC Level 5 Assignments
    • Law Course Assignments
    • Management Assignments
    • Train the Trainer
    • Healthcare Assistance
    • Digital Marketing Assignment
    • QQI Assignments
    Cities
    • Dublin
    • Galway
    • Cork
    • Limerick
    • Waterford
    • Sligo
    • Dundalk
    • Carlow
    • Maynooth
  • Samples
  • Experts
  • Questions
  • Blog
  • Reviews 4.9/5
Order Now Log In
Search from Thousands of
Ireland Assignments Answers
  • 463+ Experts
  • A+ Grade
  • Free Turnitin Report
  1. Home
  2. Questions
  3. The dataset comes from an online retail company that tries to acquire: Marketing Analytics Assignment, TCD

The dataset comes from an online retail company that tries to acquire: Marketing Analytics Assignment, TCD

University Trinity College Dublin (TCD)

Assignment Brief:

The dataset comes from an online retail company that tries to acquire customers through various means such as direct mail, organic search, paid search, etc. Each row identifies one customer that was acquired and a certain acquisition cost is incurred. Some customers make subsequent purchases, and some don’t. In order to improve the performance of the company, the marketing team decided to send out discount offers to some of the customers that were acquired through direct mail. The discount offers are included in the acquisition cost.

Please read the questions carefully and answer them within the same sheet as the question:

Question 1:

Create a table for each attribute (e.g., Gender) and record the percentage of responses for each answer (e.g., % of respondents answering “male” and % answering “female”).

Please indicate what each table represents. Avoid generating meaningless table as it would incur penalty points

Question 2:

a) Correlate as many attributes and variables as possible?
b) Find the three highest and three lowest correlations?
c) Explain what those high and low values mean? Not only in mathematical terms but also contextually.
d) What are the insights that you can generate from the correlations above?

Get Solution of this Assessment. Hire Experts to solve this assignment for you Before Deadline.

Get A Free Quote

Question 3:

Select one or two attributes to use as the basis for generating segmentation schemes. Please go beyond simple segmentations like gender or age categories, unless you have a very good reason and explanation for choosing these simple segmentation strategies.

As you generate segmentation schemes, Use the data in the “Data” worksheet to fill each cell in the tables shown below. Remember to try to create segments that are homogenous internally and heterogeneous across segments for the indicated number of segments. Not all attributes will be used.

Note: You don’t need to necessarily generate 7 segments. Use your data and your own judgment of how many segments you need.

Note: Other interesting information is important to include. This will depend on you segmentation and analysis. You can use any number of rows below the table to add futhur information about each segment.

Segment name Seg 1 Seg 2 Seg 3 Seg 4 Seg 5 Seg 6 Seg 7
Number of Customer
Percentage of customer
Average Total Spend
Description of segment
Most Sources of customers
Most frequent brand used
Average Total Profit form that segment
Average profit margin
Subsequent order profit relative to the first order profit
Any other Interesting Information

Question 4:

Write a 300-word summary of your selected segmentation scheme (from question 3) and how you arrived at the segmentation. Include descriptive names for your segments that would be understandable to the marketing manager at the online retail company.

Question 5:

The company has been sending out discount offers to customers that their source is from direct mail. The offers are added to the marketing cost in the data. Please note that the interest rate is always 8 percent and each customer makes one purchase per month.

Hint: You need to calculate the retention rate from the variable “NumberOfMonthsAlive”. You can create pivot tables to see the count of customers that survive a different number of months and calculate the average retention rate per month from there.

a) Please fill in the below table using pivot tables.

Column 1 Direct Mail Other Customers
Avg revenue per customer over the months they make a purchase
Orders per months
Number of Customers
Rentention rate per month
Avg Profit Margin
Average cost of servicing per month
Acquisition cost
Yearly interest rate 0.08 0.08
Shared with
Ireland Assignments Editorial Team

A student shared this brief with our team; personal details have been removed. Our editorial team works on tasks like this and can guide you on how to approach it.

Get Help By Expert

Maintain high grades by hiring top assignment experts of irelandassignments.ie and produce top-quality marketing analytics assignments. We are a well-known marketing assignment service provider in Ireland for TCD students.

Submit Your Assignment Questions & Get Plagiarism Free Answers.

Buy Now
Get the Answer to This Question

Tell us about your assignment in 3 quick steps and get a free, no-obligation quote.

1 Basics 2 Details 3 Contact
The basics
Over 10,000 words? Choose 10,000+ and type your exact count.
Step 1 of 3 · takes under a minute
About your assignment
What help do you need?
Do you have the brief or marking rubric?
Step 2 of 3 · last step is your contact details
Where should we send your quote?
Attach your brief, rubric or notes (optional, up to 10 files)
PDF, Word, PowerPoint, Excel or images · up to 100MB in total
Uploading…
Free quote No payment to submit 100% confidential

To Get Answer
Please Fill the following Details

If you think the question is incomplete, then you can upload your assignment brief.

Facing Issues with Assignments? Talk to Our Experts Now!Download Our App Now!

Request a Call Back
Irish assignment expert ready to help a student

Have Questions About Our Services?
Download Our App!

Get the App Today!

iphone android
QRcode
Ireland Assignments .ieIRELAND.ieASSIGNMENTS

Ireland Assignments

Ireland Assignment's offers plagiarism free assistance to the students around the globe. We understand the value of top grades to a student. And that is the reason we are here to assist you with ultimate professionalism. By availing our services we assure you better grades. Raise your academic grades with our Ireland assignment help.

Useful Links

Useful Links

Useful Links
  • Home
  • Services
  • Samples
  • Blog
  • User Reviews
  • Questions
  • Experts
  • Submit Questions
Legal & Policies

Legal & Policies

Legal & Policies
  • Privacy Policy
  • Warranty
  • Copyright Notice
  • Terms & Conditions
  • About Us
  • Contact Us
  • How Ordering Works
  • FAQs
  • University Assignment Help
  • Final Year Project Help
  • Semester Assignment Help
  • Social Care Project Help
  • Care of the Surgical Patient
Cities

Cities

Cities
  • Dublin
  • Galway
  • Cork
  • Limerick
  • Waterford
  • Sligo
  • Dundalk
  • Carlow
  • Maynooth
GDPR
info@irelandassignments.ie
Secure Payment

77 Camden Street Lower, Dublin, D2 XE80, Ireland

Student Login·Facebook

Disclaimer: Ireland Assignments connects students with subject experts for academic guidance, model answers and study resources such as journals, articles and e-books. We do not offer ghostwriting, as it is academic misconduct. We are not sponsored or endorsed by Quality and Qualifications Ireland (QQI) or any college or university. All trademarks, logos and institution names belong to their owners and are used for identification only.

Ireland Assignments rated 4.9/5 based on 15,000+ student reviews on WhatsApp

Copyright © 2026 Ireland Assignments, All Right Reserved