Marketing and Retail Analytics: Yj98Zmqlka

da_pramit@ymail.
com
Marketing and Retail Analytics

YJ98ZMQLKA
This file is meant for personal use by [email protected] only.

Sharing or publishing the contents in part or full is liable for legal action.
Quiz- Some basic terms in Retail(1/2)
1. What is a SKU ?
Stock Keeping Unit - SKU' A store's or catalog's product and service
identification code, often portrayed as a machine-readable bar code that
helps the item to be tracked for inventory. These codes are not regulated
nor standardized. When a company receives items from a vendor, it has a
choice of maintaining the vendor's SKU or creating its own.
[email protected]
2. What is a UPC ?
YJ98ZMQLKA
The Universal Product Code (UPC) is a barcode symbology (i.e., a specific

type of barcode) that is widely used in the United States, Canada, the
United Kingdom, Australia, New Zealand, and in other countries for
tracking trade items in stores. Its most common form, the UPC-A, consists
of 12 numerical digits, which are uniquely assigned to each trade item

Quiz- Some basic terms in Retail(2/2)
3. What does CPG stand for? What does FMCG stand
for?
Consumer packaged goods (CPG) are consumable goods such as food and
beverages, tobacco, and cleaning products. In general, CPGs are things
that get used up and have to be replaced frequently, in contrast to items
that people usually keep for a long time, such as cars and furniture. In
YJ98ZMQLKAIndia and in some other countries CPG companies are called as FMCG
[email protected]
companies, which stands for Fast Moving Consumer Goods.

4. What are the 3 most important
attributes(variables)that we look at when trying to
understand customer behavior ?
1. What does a consumer buy?
2. How often does he buy and when does he buy what he buys?
3. How much does he spend?

Quiz- Some basic terms in Marketing(1/2)
1. What is a campaign ?
2. What is a promotion?
3. What is meant by a “prospect pool”?

[email protected]
YJ98ZMQLKA
4. Can you name some companies that sell data?

Why do you need external data sets, when you can
get internal data ?

Format Definition
Formats Description Key categories retailed Typical size Sq.ft. Example
A large superstore,
combining a supermarket Food, groceries, apparel, 15,000-100,000 Big Bazaar, Hypercity, Spencer,
and departmental store, furnishings, consumer Star India Bazaar, Vishal
offering full lines of grocery durables Megamart
Hyper markets and general merchandise all
under one roof
A large self service outlet Food, groceries, medicines 3,000-15,000 FoodWorld, Trinethra,
offering food and household Subshiksha, Food baazar
Super markets goods
[email protected]
YJ98ZMQLKA
Small size, easily accessible Food, groceries, medicines 500-2,000 In&Out
stores offering a quick
Convenience shopping, fast check out
experience and extended
stores working hours
A large self service outlet Apparel, Jewellery, watches, 10,000-50,000 Shopper’s Stop, Lifestyle,
offering a variety of fashion accessories, footwear, Pantaloon, Westside
Departmental merchandise furniture, furnishings
stores
Large speciality stores

Electronics, office supplies,
focussed on one or a few 20,000-100,000 Best Buy – Circuit City, Staples
apparel
categories of merchandise,
Category killers offering a wide selection at
low prices
5
Format Definition (Contd.)
Formats Description Key categories retailed Typical size Sq.ft. Example
Warehouse style large Food, groceries •100,000 + Metro cash and carry, Costco,
stores, offering goods in bulk Sam’s Club
Warehouse at discount prices to
clubs members
Retail outlet offering products Apparel, footwear, tyres, food •1,000-5,000 Nike, Adidas, Colourplus,
Single brand of a single brand services, furniture McDonalds, Gautier, Gucci, TBZ
outlets
[email protected]
YJ98ZMQLKA
Retail outlet offering multiple Footwear, apparel, •1,000-20,000 Planet Sports, Planet Fashion,
Multibrand branded products belonging electronics, books Crosswords
speciality to a single category class
stores

6
Why an Analytics Health Check is necessary ?
Most Analytics consultancies do an Analytics Health Check of

the organization that they consult to gauge how much
awareness exists within the firm and how much needs to be
built.
[email protected]
YJ98ZMQLKA
Let us do a quick Analytics health check for ourselves and see

where we stand !!

Targeted Marketing – You have a budget for targeting shoppers in Spencer.
Prepare a marketing analytics strategy for each of these two options?
Send coupons to customers who Send coupons to customers who

shop in your top 10 stores are your top 100K shoppers
across 100 stores
[email protected]
YJ98ZMQLKA

Top 10 stores visa-vis top 100k shoppers
Top 10 stores Top 100k shoppers

On what basis do you identify your On what basis do you identify your
top 10 stores ? top 100k shoppers ?
Rank stores by revenue ? A person who buys a TV for Rs.100k
but visits only once a year, or a
Rank stores by margins/profits?
[email protected] person who visits every week, but
spends only Rs.10,000 ?
YJ98ZMQLKA
Rank stores by number of goods

sold ? Not just the top 100k shoppers but
top 100K shoppers who are either
Rank stores by some other metric ? buyers of this brand or this
(Revenue per sq. ft) category- what if there are not
enough shoppers who buy into this
brand ?
Proxy brand

Grow top line through Marketing
[email protected]
YJ98ZMQLKA
Focus on growth of your market Focus on growing the spend from

share through mass marketing – a existing customers
la Microsoft - a la Apple

Mass marketing versus growing share of wallet of existing customers?
Focus on growth of your market Focus on growing the spend from

share through mass marketing existing customers
How do you calculate the market How do you calculate the share of
share ? wallet of your customers ?
Syndicated data- IRI, Nielsen,

[email protected]
YJ98ZMQLKA How will you get data about what
IMRB your customers are buying from
other stores ?
How do you increase market
share ? Can you use Analytics to use
- mass advertising share of wallet numbers for a
- new customer acquisition small section of your customers
through campaigns and extrapolate to the rest of the
population ?

Would you try and beat your competitor on price for key products as
compared to adopting a low price strategy for items that are bought
by price sensitive customers ?
[email protected]
YJ98ZMQLKA
Every Day low price for many key Reduce price of items that are
products bought by price sensitive
customers

Through these Caselets we have covered some important
concepts- Can you define them in simple terms ?
Targeted marketing
Share of wallet
Price sensitive customers – Pricing segmentation

[email protected]
YJ98ZMQLKA

Customer Loyalty
How would you define customer loyalty?
Customer loyalty means different things to different people, but the following questions
best summarize what Retailers are looking for when they want to understand customer
loyalty.
1. “Who are the best customers of the Retailer?”
2. “How much of the Retailer’s business is reliant on these customers?”
3. “How well is the Retailer meeting the needs of these customers?”( Does the Retailer
have the right range and assortment of the products that the customer wants and at
the right price points)
[email protected]
4. “How can the Retailer reward these customers ?“
YJ98ZMQLKA
Some common applications of a loyalty segmentation are:

• Prevent defection of the most valuable customers by keeping them engaged and
rewarding them often
• Re-activate customers who have become less loyal by re-engaging them with exciting
offers
• Increase the loyalty of less engaged customers through personalized and relevant
targeting
• Target campaigns at a local level, by understanding regional and store level differences

Consumer Analytics
The most important aspect of Analytics in Retail is to gain a
very comprehensive understanding of the consumer
The key to understanding consumer behavior is through

building different kinds of segments :
1. RFM :- This segmentation technique gives you a measure of

[email protected]
the loyalty of the customer. ( Should be refreshed at least

YJ98ZMQLKA
once in a quarter as there movements across segments in

shorter time frames).
2. Consumer Lifestyle Segmentation:- Run a cluster Analysis

on the consumer level data of Retailers to arrive at this
segmentation. ( How many segments are recommended ?)

Actions to be taken using RFM segments
Super-Savvy Savvy Diligent Intermittent Lapsing Lost
[email protected]
YJ98ZMQLKA
Devoted Potential Borderline
Incentivize & Preserve Expand & Nurture Re-acquire
A targeted communications strategy will drive required behaviour from all customer groups

Collapsing the RFM segments
Segment 1 Segment 5
High_High_High 36 3.60% Low_Low_High 259 25.90%
High_High_Medium 1 0.10% Low_Low_Medium 120 12.00%
High_Medium_High 115 11.50% Low_Low_Low 44 4.40%
Medium_High_High 2 0.20% Low_High_Low 0 0.00%
15.40% Low_Medium_Low 2 0.20%
42.50%
Segment 6
High_Very Low_High 0 0.00%
Segment 2 High_Very Low_Medium 0 0.00%
High_Medium_Medium 9 0.90% High_Very Low_Low 0 0.00%
Medium_Medium_High 97 9.70% 0.00%
Medium_High_Medium 0 0.00%
Medium_Medium_Medium 10 1.00% Segment 7
11.60% Medium_Very Low_High 0 0.00%
[email protected] Medium_Very Low_Medium 0 0.00%
YJ98ZMQLKA Segment 3 Medium_Very Low_Low 0 0.00%
High_Low_High 3 0.30% Low_Very Low_High 5 0.50%
High_Low_Medium 0 0.00% Low_Very Low_Medium 5 0.50%
High_Low_Low 0 0.00% Low_Very Low_Low 3 0.30%
High_High_Low 0 0.00% 1.30%
High_Medium_Low 1 0.10% Segment 8
Medium_Low_High 121 12.10% High_High_Very Low 0 0.00%
Medium_Low_Medium 30 3.00% High_Medium_Very Low 0 0.00%
Medium_Low_Low 15 1.50% High_Low_Very Low 0 0.00%
Medium_High_Low 0 0.00% High_Very Low_Very Low 0 0.00%
Medium_Medium_Low 2 0.20% Medium_High_Very Low 0 0.00%
17.20% Medium_Medium_Very Low 0 0.00%
Medium_Low_Very Low 6 0.60%
Segment 4 Medium_Very Low_Very Low 0 0.00%
Low_High_High 0 0.00% Low_High_Very Low 0 0.00%
Low_High_Medium 0 0.00% Low_Medium_Very Low 0 0.00%
Low_Medium_High 65 6.50% Low_Low_Very Low 35 3.50%
Low_Medium_Medium This file8 is meant
0.80%
for personal useLow_Very Low_Very Low
by [email protected] only. 6 0.60%
7.30%
Sharing or publishing the contents in part or full is liable for legal action. 4.70%
Segmentation
Products are categorised using Customer Lifestyle Attributes
Each product is categorised using a series of attributes
• Low Price
• Reliance • Fresh • Branded
Own • Unpacked • South Indian
[email protected]
YJ98ZMQLKA
• Reliance • Conventional • Quick
Select
Top products that account for 95% sales are flagged with such attributes
We look for the balance of key attributes in each customers shopping …

Can you come up with 50 pre-identified Customer Lifestyle
Attributes for Reliance Retail ?
We make use of over 50 attributes for profiling customers who then can be grouped into 6 to 12 more
manageable high level Lifestyles segments. The numerous dimensions give us a deeper understanding of
particular shopping behaviour of various customer groups.
For example we can easily identify customers who have a tendency to buy into large non-food items (electrical
etc). This will be used in targeting for Reliance Digital.
• Basic Cooking • Italian • Reliance Dairy Life

• Branded • Jain • Reliance Dairy Pure
• Chinese • Kids • Reliance Healthy Life
[email protected]
• Collection items
YJ98ZMQLKA • Long-life • Reliance Premium
• Conventional • Low Fat • Reliance own label
• Experimental • Low price • Reliance Select
• Exotic • Non food - All • Reliance Value
• Fresh • Non food - Essentials • Serve One
• Halal • Non food - Kids • Small pack
• Healthy • Non food - Perishables • South Indian
• High Calorie • Non food - Value added • Supplements Alternative
• High price • Organic • Thai
• Hygiene • Pre packed • Unpacked
• Imported • Ready to Eat • Value pack
• Instant • Vegetarian lenient
• Vegetarian pure

These dimensions make up each customers Segmentation
‘Lifestyles DNA’ or persona
This customer buys a lot of items that are

‘Instant’ and ‘Serve One’
• We study product
attributes of all items in
your basket
• We can then see when
you are frequently buying
[email protected]
YJ98ZMQLKA
products with the same

attribute
• We then compare you to
the Rest of Reliance
shopper to see where
your purchasing behaviour
is most extreme

Customer Life segments Segmentation
Price sensitive
Bargain Hunters Heavy users of discount coupons and offers Value driven buyers who often end up with the lowest priced items Don’t like to
experiment with their shopping list, stick to a limited product range Price is the most important factor in their shopping decisions
Economy Spenders This group goes for value for money product combos and bulk packs Buy pre-packaged cereal and dals from Value range but not a
lot from the fresh range products.
Conventional
Conventional The most traditional customer group They don’t like to buy in bulk, shop frequently but have smaller baskets Know what they want
and stick to it They tend to be older and buy conventional food items
Predominant
Typical Brands Regularly buy similar items, mostly traditional meals Not big spenders, but buy popular brands that are tried and tested rather than
own label products
Controlled by Kids Families where kids who dictate shopping list This customer group visit the store frequently They need to buy lots of Non-food
items for kids, so prefer to have everything at one store Their baskets are larger and they are more inclined towards promotions
Nutrition First
[email protected]
YJ98ZMQLKA
Wholesome Living Relatively older shoppers who don’t experiment much Stick to traditionally healthy habits of eating Don’t fret about calorie
count Buy wholesome nutritious foods
Calorie Conscious Usually working couples with no kids Tend to be health conscious and buy low-cal items Unlikely to buy anything with high fat or
high calories May have an inclination towards organic product range
No Time for Kitchen

Too Cool to Cook Younger adults, living away from family, mostly with friends Like to spend their time at work/on activities rather than in kitchen
Often pick up quick and/or ready-to-eat meals
Busy Connoisseurs Young professionals who enjoy fine food but can’t make time for cooking Buy wide range of food items on-the-go Prefer to shop
for Grocery and Non-food at one single place for convenience
Delicatessen Diners
Gourmet Lovers This customer group has developed a palette over time They are well travelled and know their food Tend to be slightly older adults
who enjoy cooking Don’t hesitate in venturing out to specialist stores
Global Organics Environmentally conscious customers who buy lots of organic foods They are often experimental cooks who like to cook from scratch
Influenced by non-conventional cooking techniques
Experimentalists First ones to try novel and exotic things Appreciate fine food and like to cook at home as well Buy from a wide range of food.
Most frequent complaint from clients/stakeholders- we get tables,
charts and models but little insights and recommendations
1. Look at the different elements of your data and think how it is
useful for a retailer
2.Does he want to know more about his stores and how they are
performing ?
3. Will he be interested in knowing consumer behavior ?
4. Which categories are doing well and which categories are not ?
[email protected]
YJ98ZMQLKA
5. Which brands are doing well in my stores and which are not ?
6. Analysis using the data
Store level ( build it with the class)
Brand level
Category level
Customer segment level

Create Insights and prepare a dashboard from
the loyalty data set
• Enterprise level dashboards
• Store level dashboards
• Consumer level dashboards

[email protected]
YJ98ZMQLKA
• Vendor dashboards/scorecards

Survey – some points to remember
• Establishing the Aim(s) of Your Research

• If your research is too broad, you will have to ask too many
questions; too narrow and you will not be researching the
topic thoroughly enough
• Determining Your Sample Group
[email protected]
YJ98ZMQLKA
1. Random selections from a stratified sample

2. Pure random sample (utopian in a large data scenario)
• Methodology
• Face to face
• Mail

Direct Marketing Life Cycle without Analytics
Campaign Brief
Campaign Planning, Scheduling
• Campaign Details and Documentation
• DM Costs •Random Population

selected based on
• Post Campaign Expectations availability of budgets
Carpet bombing of a million customers •No selection criteria
No tangible return on investment used
Exhausted your marketing budget as per •Anyone in the prospect
plan
[email protected] pool can get an email
YJ98ZMQLKA Danger of repeating
A very happy boss- you have covered the same
most customers !! promotional mail to
a prospect within X
months again and
Learnings from thus violating US
campaign lost state laws
No Analysis of
campaigns done
Mail House
Intimation
Direct Marketing Life Cycle with Analytics embedded
Campaign Brief Campaign Planning, Scheduling
and Documentation Files Selection Process
• Campaign Details
begins
• Targeting Details • Program Brief
Strategy • Target Audience • Program Timelines
• DM Costs • Mail File Delivery Channels
• Post Campaign Expectations • Point of Contacts
Suppression
Optimized budget spend

[email protected]
YJ98ZMQLKA High conversion rate
Campaign Tracking
Quantifiable ROI
Improvement of next campaign Direct Marketing
Legal Compliance
Solicitation History
Privacy
•Response/Statistical Models –
Mail House Mail File Cutting and Segmentation Create Deciles
Intimation Shipping Design of Experiments
This file is meant for personal use by [email protected] only.• Selection Strategy
[email protected]
YJ98ZMQLKA
Thank you!


Marketing and Retail Analytics: Yj98Zmqlka

Uploaded by

Copyright:

Available Formats

Marketing and Retail Analytics: Yj98Zmqlka

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Marketing and Retail Analytics: Yj98Zmqlka

Uploaded by

Copyright:

Available Formats

da_pramit@ymail.

Marketing and Retail Analytics

This file is meant for personal use by [email protected] only.

The Universal Product Code (UPC) is a barcode symbology (i.e., a specific

This file is meant for personal use by [email protected] only.

companies, which stands for Fast Moving Consumer Goods.

This file is meant for personal use by [email protected] only.

3. What is meant by a “prospect pool”?

4. Can you name some companies that sell data?

This file is meant for personal use by [email protected] only.

Large speciality stores

This file is meant for personal use by [email protected] only.

Most Analytics consultancies do an Analytics Health Check of

Let us do a quick Analytics health check for ourselves and see

This file is meant for personal use by [email protected] only.

Send coupons to customers who Send coupons to customers who

This file is meant for personal use by [email protected] only.

Top 10 stores Top 100k shoppers

Rank stores by number of goods

This file is meant for personal use by [email protected] only.

Focus on growth of your market Focus on growing the spend from

This file is meant for personal use by [email protected] only.

Focus on growth of your market Focus on growing the spend from

Syndicated data- IRI, Nielsen,

This file is meant for personal use by [email protected] only.

This file is meant for personal use by [email protected] only.

Price sensitive customers – Pricing segmentation

This file is meant for personal use by [email protected] only.

Some common applications of a loyalty segmentation are:

This file is meant for personal use by [email protected] only.

The key to understanding consumer behavior is through

1. RFM :- This segmentation technique gives you a measure of

the loyalty of the customer. ( Should be refreshed at least

once in a quarter as there movements across segments in

2. Consumer Lifestyle Segmentation:- Run a cluster Analysis

This file is meant for personal use by [email protected] only.

Super-Savvy Savvy Diligent Intermittent Lapsing Lost

Incentivize & Preserve Expand & Nurture Re-acquire

This file is meant for personal use by [email protected] only.

Products are categorised using Customer Lifestyle Attributes

Each product is categorised using a series of attributes

We look for the balance of key attributes in each customers shopping …

This file is meant for personal use by [email protected] only.

• Basic Cooking • Italian • Reliance Dairy Life

This file is meant for personal use by [email protected] only.

‘Lifestyles DNA’ or persona

This customer buys a lot of items that are

products with the same

This file is meant for personal use by [email protected] only.

No Time for Kitchen

This file is meant for personal use by [email protected] only.

• Store level dashboards

• Consumer level dashboards

This file is meant for personal use by [email protected] only.

• Establishing the Aim(s) of Your Research

1. Random selections from a stratified sample

This file is meant for personal use by [email protected] only.

• DM Costs •Random Population

Optimized budget spend