Sales funnel
Transcript: PESSIMISTIC: Assuming the conversion ratio to be 0.3%, Number of buyers: 7174*0.3/100 =22 OPTIMISTIC: Assuming the conversion ratio to be 1.5%, Number of buyers: 5340*1.5/100=80 REALISTIC: Assuming the conversion ratio to be 0.8%, Number of buyers: 169676*0.8/100=58 PESSIMISTIC: Assuming the conversion ratio to be 0.3%, Number of buyers: 5340*0.3/100 =16 S. No. Keywords No. Of unique searches (India) 1 WEDDING INVITATION 292622 2 WEDDING INVITATIONS 43200 3 INVITATIONS 12000 4 INVITATIONS FOR WEDDING 7143 5 WEDDING INVITATION CARDS 52810 6 WEDDING CARDS 172504 7 INVITATION CARDS 115357 8 WEDDING CARD 38337 9 INVITATION CARD 41486 10 INDIAN WEDDING CARDS 62152 11 INDIAN WEDDING CARD 2247 12 WEDDING INVITATION CARDS 831 13 INDIAN WEDDING INVITATIONS 4195 14 WEDDING CARDS ONLINE 5868 15 FREE WEDDING CARDS 456 16 WEDDING CARDS DESIGN 38880 TOTAL 890088 REALISTIC: Assuming the conversion ratio to be 0.8%, Number of buyers: 305745*0.8/100 =2446 • No. of unmarried female population in India in the age group of 18-34 Gen Category: 22201986 SC: 3190356 ST: 1844766 Total: 27237108 • No. of online shoppers in India = 84 Mil as of June’15 (It was 35 Mil April’14, Expected at 100 Mil Dec’16) • Total population Indian june’15 = 1281630400 • Ratio of Online = 84000000/1281630400 *100 = 6.5% REALISTIC: Assuming the conversion ratio to be 0.8%, Number of buyers: 169676*0.8/100 =1356 OPTIMISTIC: Assuming the conversion ratio to be 1.5%, Number of buyers: 126303*1.5/100 =1895 PESSIMISTIC: Assuming the conversion ratio to be 0.3%, Number of buyers= 305745*0.3/100 =917 OPTIMISTIC: Assuming the conversion ratio to be 1.5%, Number of buyers: 410736*1.5/100 =6161 REALISTIC: Assuming the conversion ratio to be 0.8%, Number of buyers: 126303*0.8/100 =1010 OPTIMISTIC: Assuming the conversion ratio to be 1.5%, Number of buyers: 169676*1.5/100 =2544 OPTIMISTIC: Assuming the conversion ratio to be 1.5%, Number of buyers: 7174*1.5/100 =108 PESSIMISTIC: Getting T1C on page 2 of Google Search -> 6% of people go to page 2 The second page has 10 results with roughly the same probability of clicks Each search result enjoys a traffic of 0.6% Traffic: 0.6% *1195740= 7174 OPTIMISTIC: Assuming the conversion ratio to be 1.5%, Number of buyers: 305745*0.8/100 = 4586 PESSIMISTIC: Assuming the conversion ratio to be 0.3%, Number of buyers: 169676*0.3/100 = 510 • Age Wise Split of online shoppers = Age % 18-25 35 26-35 55 36-45 8 90% of online buyer population falls under unmarried female popln • 28000 Couples get married per day -> In a year = 28000*365 = 10220000 • 6.5% of this population are online shoppers -> 90% in 18-34 age group • No. of people going online per year to buy invitation cards = (28000 * 365 * 6.5 * 90)/10^4 = 597870 Since both sides of the family buy cards -> 597870*2 = 1195740 PESSIMISTIC: Assuming the conversion ratio to be 0.8%, Number of buyers: 126303*0.3/100=379 REALISTIC: T1C being the 2nd/3rd result on page 1 2nd/3rd results enjoy a traffic of 16.96%/11.46% respectively Average = 14.19% Traffic Enjoyed = 14.19 % * 890088 = 126303 Sales funnel REALISTIC: Assuming the conversion ratio to be 0.8%, Number of buyers: 410736*0.8/100 = 3286 OPTIMISTIC: T1C being the 1st result 1st result enjoys 34.35% of clicks Traffic = 34.35% * 890088 = 305745 OPTIMISTIC: T1C being the 1st result 1st result enjoys 34.35% of clicks OPTIMISTIC: 34.35%* 1195740 =410736 REALISTIC: T1C being the 2nd/3rd result on page 1 2nd/3rd results enjoy a traffic of 16.96%/11.46% respectively Average = 14.19% REALISTIC: 14.19%*1195740= 169676 PESSIMISTIC: Getting T1C on page 2 of Google Search -> 6% of people go to page 2 The second page has 10 results with roughly the same probability of clicks Each search result enjoys a traffic of 0.6% Traffic : 0.6% * 890088 = 5340 REALISTIC: Assuming the conversion ratio to be 0.8%, Number of buyers: 5340*0.8/100=43 PESSIMISTIC: Assuming the conversion ratio to be 0.3%, Number of buyers: 410736*0.3/100 =1232