Chapter 5: Data Analysis and Interpretation A) AVAILLIBILITY & VISIBILITY SURVEY-VODAFONE (MAHARASHTRA-GOA CIRCLE)
1) Glow Sign board on the front face of shop? Operator Vodafone Airtel Idea Uninor Others
No Of shops 240 240 240 240 240
Percentage 20% 27% 28% 15% 10%
Glow Sign Board Vodafone
Airtel
15%
28%
Interpretation:
1
10%
Idea
Uninor
20%
27%
Others
2) Which operator has best visibility from outside the shop? Operator Vodafone Airtel Idea Uninor Others
No Of shops 240 240 240 240 240
Percentage 65 62 68 40 2
Best Outside Visibility Vodafone
Airtel
Idea
Uninor
Others
2% 17%
27%
28% 26%
Interpretation:
2
2) Which operator has best visibility from outside the shop? Operator Vodafone Airtel Idea Uninor Others
No Of shops 240 240 240 240 240
Percentage 65 62 68 40 2
Best Outside Visibility Vodafone
Airtel
Idea
Uninor
Others
2% 17%
27%
28% 26%
Interpretation:
2
3) Which operator has best visibility from inside the shop? Marks 5 4 3 2 1
Vodafone 65 75 52 30 18
Airtel 70 50 58 48 14
Idea 63 53 55 39 30
Uninor 40 57 70 40 33
Others 2 5 5 83 145
Best Inside Visibility 160 140 120 Vodafone
100 s p o h S
Airtel
80
Idea 60
Uninor
40
Others
20 0 5
4
3 Marks
Interpretation:
3
2
1
4) Which operator has Highest Sim on the counter of retailer? Operator Vodafone Airtel Idea Uninor Other Not Selling
No. Of shops 240 240 240 240 240 240
Percentage 20 19 17 15 12 17
Highest SIM On the Counter
Vodafone 20%
Not Selling 25%
Airtel 12%
Other 12% Idea 18%
Uninor 13%
Interpretation:
4
5) Which operator ha the highest number of product posters in the shop?
Marks 5 4 3 2 1
Vodafone 40 17% 60 25% 55 23% 45 19% 40 17%
Airtel 65 52 60 50 13
Idea 57 48 50 42 43
27% 22% 25% 21% 5%
24% 20% 21% 17% 18%
Uninor 62 55 52 48 23
26% 23% 22% 20% 10%
Others 16 25 23 55 121
7% 10% 9% 23% 50%
50% 45% 40% 35% Vodafone
e 30% g a t n 25% e c r e P 20%
Airtel Idea Uninor
15%
Other
10% 5% 0% 5
4
3 Marks
Interpretation:
5
2
1
6) Which operator has highest Etop up done by retailer Operator Vodafone Idea Airtel Uninor
No of Shops 240 240 240 240
Percentage 31% 26% 33% 10%
Highest Etopup 10% 31% Vodafone
33%
Airtel Idea 26%
Interpretation:
6
Uninor
7) How much Paper recharge does a retailer sells on an average per day for the different operators.
Highest Paper recharge Vodafone
Airtel
16%
Idea
Uninor
26%
30% 28%
Interpretation:
7
8) How much SIMs does a particular retailer sells on an av erage per month for the different operators.?
Highest Sim sold Vodafone
Airtel
16%
Idea
Uninor
26%
30% 28%
Interpretation:
8
9) For which brand does a retailer sell bonus cards?. Operator Vodafone Idea Airtel Uninor Not Selling
No of Shops 240 240 240 240 240
Percentage 22% 25% 27% 12% 14%
Interpretation:
Sales Vodafone
Airtel
Idea
14%
Uninor
Not Selling
22%
12%
25% 27%
9
10) Does a retailer sell 121 Best Deals to Vodafone customers?(YES/NO) Operator Vodafone
Yes 104
No 136
Sales Yes
No
43%
57%
Interpretation:
10
11) What is the frequency of servicing of DSE at the retailers shop for stocks? Operator Vodafone Airtel Idea Uninor
Daily 172 200 196 187
72% 83% 82% 78%
Alternate day 40 17% 32 13% 35 15% 38 16%
Once in 3 days 20 8% 8 3% 9 4% 13 5%
Very irregular 8 3% 0 0% 0 0% 0 0%
90% 80% 70% 60%
Vodafone
50%
Airtel
40%
Idea Uninor
30% 20% 10% 0% Daily
Alternate Days
Once in 3 days
Interpretation:
11
Very Irregular
12) What is the frequency of servicing of company employee at the retailers shop for servicing? Days Twice a Month Once a Month Once in 2 Months Never Visited
Vodafone 130 54% 80 33% 23 10% 7 3%
Airtel 150 73 14 3
63% 30% 6% 1%
Idea 125 60 10 45
52% 25% 4% 19%
Uninor 160 65 15 0
67% 27% 6% 0%
70% 60% 50% % 40% n i s p o h 30% S
Vodafone Airtel Idea
20%
Uninor 10% 0% Twice a Month
Once a Month
Once in 2 Months
Axis Title
Interpretation:
12
Never Visited
13) Out of below operators, which company employee pitches bonus cards to you? Operator Vodafone Airtel Idea Uninor
Yes 200 204 196 190
83% 85% 82% 79%
NO 40 36 44 50
17% 15% 18% 21%
90% 80% 70% 60%
e g a t 50% n e c r 40% e P
Yes No
30% 20% 10% 0% Vodafone
Airtel
Idea Operators
13
Uninor
14) Please provide the below details for the operators mentioned. Answer is Yes/No Parameter
Vodafone Airtel Yes No Yes No
Idea Yes No
Uninor Yes No
Merchandiser visit DSE carries enough Stock Distributor speaks with you secondary Distributors offers credit Easy availability of company staff for any stock support Sufficient POSM material DSE informs about new product A. Merchandiser Visit
100% 90% 80% 70% 60% Yes 50%
No
40% 30% 20% 10% 0% Vodafone
Airtel
Idea
14
Uninor
B. DSE carries enough Stock:
100% 90% 80% 70% 60% Yes 50%
No
40% 30% 20% 10% 0% Vodafone
Airtel
Idea
Uninor
C. Distributor speaks with you secondary:
100.00% 90.00% 80.00% 70.00% 60.00% Yes 50.00%
No
40.00% 30.00% 20.00% 10.00% 0.00% Vodafone
Airtel
Idea
15
Uninor
D. Distributors offers credit:
100% 90% 80% 70% 60% Yes 50%
No
40% 30% 20% 10% 0% Vodafone
Airtel
Idea
Uninor
E. Easy availability of company staff for any stock support: 100% 90% 80% 70% 60% Yes 50%
No
40% 30% 20% 10% 0% Vodafone
Airtel
Idea
16
Uninor
F. Sufficient POSM material:
100% 90% 80% 70% 60% Yes 50%
No
40% 30% 20% 10% 0% Vodafone
Airtel
Idea
Uninor
G. DSE informs about new product
100% 90% 80% 70% 60% Yes 50%
No
40% 30% 20% 10% 0% Vodafone
Airtel
Idea
17
Uninor
B) TRADE SATISFACTION SURVEY-VODAFONE (MAHARASHTRA-GOA CIRCLE) 1) For which of the below operator do you sell any products? Operator Shops Vodafone 240 207 Airtel 240 215 Idea 240 220 Uninor 240 190
Percentage 86% 90% 92% 79%
92% 90% 88% 86% e g 84% a t n 82% e c r e 80% P
78% 76% 74% 72% Vodafone
Airtel
Idea Operators
18
Uninor
2) Positive about the below operators regarding their network to customers visiting your shop? Operator
Yes
Vodafone Airtel Idea Uninor
232 180 235 198
No 97% 75% 98% 83%
8 60 5 42
8% 60% 5% 42%
100% 90% 80% 70% e g a t n e c r e P
60% 50%
Yes
40%
No
30% 20% 10% 0% Vodafone
Airtel
Idea Operators
19
Uninor
3) Do you tell anything positive about the below operators regarding their Service to customers visiting your shop? Operator
Yes
Vodafone Airtel Idea Uninor
197 224 230 218
No 82% 93% 96% 91%
43 16 10 22
18% 7% 4% 9%
100% 90% 80% 70% e g a t n e c r e P
60% 50%
Yes
40%
No
30% 20% 10% 0% Vodafone
Airtel
Idea Operators
20
Uninor
4) Please rate your feedback about the product offering for each of the operators given below. Operator 5 4 3 2 1 Vodafone 10 4% 5 2% 90 37% 138 57% 0 Airtel 90 37% 120 50% 29 12% 1 0% 0 Idea 30 13% 35 15% 112 47% 63 26% 0 Uninor 110 46% 80 33% 9 4% 41 17% 0
0% 0% 0% 0%
60%
50%
40% e g a t n 30% e c r e P
Vodafone Airtel Idea
20%
Uninor 10%
0% 5
4
3 Rating
21
2
1
5) Please rate your feedback about the commission offering for each of the operators given below. Operator Vodafone Airtel Idea Uninor
5
110 120 112 130
4
46% 50% 47% 54%
108 115 106 100
3
45% 48% 44% 41%
22 5 22 10
2
9% 2% 9% 4%
0 0 0 0
1
0% 0% 0% 0%
0 0 0 0
0% 0% 0% 0%
60%
50%
40% e g a t n 30% e c r e P
vodafone Airtel Idea
20%
Uninor 10%
0% 5
4
3 Rating
22
2
1
6) Please rate your feedback about the service provided by DSE(Direct Sales Executive) for each of the operators given below. Operator 5 4 3 2 1 Vodafone 170 71% 30 12% 0 0% 0 0% 40 1% Airtel 195 81% 35 15% 10 4% 0 0% 0 17% Idea 182 76% 45 19% 8 3% 5 2% 0 0% Uninor 198 83% 20 8% 20 8% 2 1% 0 0%
90% 80% 70% 60% e l t i 50% T s i x 40% A
vodafone Airtel Idea
30%
Uninor 20% 10% 0% 5
4
3
2
Axis Title
23
1
7) Please rate your feedback about the service provided by Company Sales Executive for each of the operators given below. Operator Vodafone Airtel Idea Uninor
5
160 180 130 195
4
66% 75% 54% 81%
55 28 57 26
3
23% 12% 24% 11%
18 25 35 19
2
08% 10% 14% 8%
7 7 18 0
1
3% 3% 8% 0%
0 0 0 0
0% 0% 0% 0%
90% 80% 70% 60% Vodafone 50%
Airtel Idea
40%
Uninor
30% 20% 10% 0% 5
4
3
24
2
1
8) Please rank below operators in view of the priority which you will pitch the products to an incoming customer. Operator Vodafone Airtel Idea Uninor
5
42 78 48 72
4
17% 33% 20% 30%
47 65 46 82
3
19% 27% 19% 34%
77 46 83 34
2
32% 19% 35% 14%
66 53 57 47
1
28% 22% 24% 19%
8 8 5 5
3% 3% 3% 2%
35.00% 30.00% 25.00% e l 20.00% t i T s i x A15.00%
vodafone Airtel Idea
10.00%
Uninor
5.00% 0.00% 5
4
3 Axis Title
25
2
1
9) What is the frequency of servicing of the DSE at your shop for Stocks?
Operator Vodafone Airtel Idea Uninor
Daily 172 200 196 187
72% 83% 82% 78%
Alternate day 40 17% 32 13% 35 15% 38 16%
Once in 3 days 20 8% 8 3% 9 4% 13 5%
Very irregular 8 3% 0 0% 0 0% 0 0%
90% 80% 70% 60%
Vodafone
50%
Airtel
40%
Idea Uninor
30% 20% 10% 0% Daily
Alternate Days
Once in 3 days
26
Very Irregular
10) What is the frequency of servicing of the Company employee at your shop for Servicing?
Days Twice a Month Once a Month Once in 2 Months Never Visited
Vodafone 130 54% 80 33% 23 10% 7 3%
Airtel 150 73 14 3
63% 30% 6% 1%
Idea 125 60 10 45
52% 25% 4% 19%
Uninor 160 65 15 0
67% 27% 6% 0%
70% 60% 50% % 40% n i s p o h 30% S
Vodafone Airtel Idea
20%
Uninor 10% 0% Twice a Month
Once a Month
Once in 2 Months
Axis Title
27
Never Visited
11) Which among these operators provides the fastest SIM activation customer>(Please rank accordingly). Operator Vodafone Airtel Idea Uninor
Rank
28
12) How would you grade your satisfaction on the below points on the scale of 1 to 5(5 being the best). Parameters Timeliness of the info being shared Politeness of the DSE Service of the company Employee Easy availability of the company staff for any support Frequency of POSM availability Adequacy of stocks availability Sensitivity of company employees to your issues Knowledge and hence support provided by company employee Overall personality of company employee
Vodafone
a) Timeliness Of the Information Being shared: Operator 5 4 Vodafone 148 62% 68 Airtel 168 70% 59 Idea 153 63% 66 Uninor 179 75% 49
Airtel
Idea
3
28% 25% 28% 20%
24 13 20 12
Uninor
2
10% 5% 8% 5%
0 0 1 0
1
0% 0% 1% 0%
0 0 0 0
0% 0% 0% 0%
80% 70% 60% 50%
e l t i T s 40% i x A
vodafone airtel Idea
30%
Uninor
20% 10% 0% 5
4
3 Axis Title
29
2
1
b) Politeness Of DSE: Operator Vodafone Airtel Idea Uninor
5
180 188 183 190
4
75% 78% 76% 79%
48 52 57 45
3
20% 22% 24% 19%
12 0 0 0
2
5% 0% 0% 0%
0 0 0 0
1
0% 0% 0% 0%
0 0 0 0
0% 0% 0% 0%
80% 70% 60% 50%
e l t i T 40% s i x A
vodafone airtel Idea
30%
Uninor
20% 10% 0% 5
4
3 Axis Title
30
2
1
c) Politeness Of Company Employee: Operator 5 Vodafone 208 86% Airtel 192 80% Idea 188 78% Uninor 210 88%
4
30 40 43 30
3
12% 18% 17% 13%
2 8 9 0
2
1% 3% 4% 0%
0 0 0 0
1
0% 0% 0% 0%
0 0 0 0
0% 0% 0% 0%
90% 80% 70% 60% e l t i 50% T s i x 40% A
vodafone airtel Idea
30%
Uninor 20% 10% 0% 5
4
3 Axis Title
31
2
1
d) Service Provided By DSE: Operator 5 Vodafone 150 63% Airtel 183 76% Idea 175 73% Uninor 200 83%
4
3
2
1
0 0 0 0
0% 0% 0% 0%
90% 80% 70% 60% e l t i 50% T s i x 40% A
vodafone airtel Idea
30%
Uninor 20% 10% 0% 5
4
3 Axis Title
32
2
1
e) Easy Availability Of Company Staff For any support: Operator 5 4 Vodafone Airtel Idea Uninor
3
2
0 0 0 0
1
0% 0% 0% 0%
0 0 0 0
0% 0% 0% 0%
90% 80% 70% 60% e l t i 50% T s i x 40% A
vodafone airtel Idea
30%
Uninor 20% 10% 0% 5
4
3 Axis Title
33
2
1
f)
Frequency Of POSM: Operator Vodafone Airtel Idea Uninor
5
4
3
2
0 0 0 0
1
0% 0% 0% 0%
0 0 0 0
0% 0% 0% 0%
90% 80% 70% 60% e l t i 50% T s i x 40% A
vodafone airtel Idea
30%
Uninor 20% 10% 0% 5
4
3 Axis Title
34
2
1
g) Adequacy Of Stock Availability: Operator 5 Vodafone Airtel Idea Uninor
4
3
2
0 0 0 0
1
0% 0% 0% 0%
0 0 0 0
0% 0% 0% 0%
90% 80% 70% 60% e l t i 50% T s i x 40% A
vodafone airtel Idea
30%
Uninor 20% 10% 0% 5
4
3 Axis Title
35
2
1
h) Sensitivity Of company Employee to your issues: Operator 5 4 Vodafone Airtel Idea Uninor
3
2
1
0 0 0 0
0% 0% 0% 0%
80% 70% 60% 50%
e l t i T 40% s i x A
vodafone airtel Idea
30%
Uninor
20% 10% 0% 5
4
3 Axis Title
36
2
1
i)
Knowledge and hence support provided by company employee: Operator 5 4 3 Vodafone Airtel Idea Uninor
2
0 0 0 0
90% 80% 70% 60%
e l t i 50% T s i 40% x A
vodafone airtel
30%
Idea
20%
Uninor
10% 0% 5
4
3
2
Axis Title
37
1
1
0% 0% 0% 0%
j)
Overall Personality Of company employee: Operator 5 4 Vodafone Airtel Idea Uninor
