Loyalty/Source of Sales - Revision history

Mtabadmin at 17:19, 5 August 2013

2013-08-05T17:19:56Z

Mtabadmin at 17:14, 5 August 2013

2013-08-05T17:14:15Z

Mtabadmin at 18:41, 1 August 2013

2013-08-01T18:41:34Z

Mtabadmin at 16:29, 31 July 2013

2013-07-31T16:29:40Z

Mtabadmin at 16:10, 31 July 2013

2013-07-31T16:10:04Z

Mtabadmin at 23:55, 30 July 2013

2013-07-30T23:55:50Z

Mtabadmin at 21:56, 30 July 2013

2013-07-30T21:56:31Z

Mtabadmin at 21:13, 30 July 2013

2013-07-30T21:13:09Z

Mtabadmin at 21:10, 30 July 2013

2013-07-30T21:10:51Z

Mtabadmin at 21:08, 30 July 2013

2013-07-30T21:08:55Z

← Older revision		Revision as of 17:19, 5 August 2013
Line 190:		Line 190:
	Step 2: Run the tab and export to a spreadsheet. Sum up the Subset Total count for each column in the tab. Sum up the intersection value, where the row and column labels are the same, for each column of the tab. Divide the sum of the intersections by the sum of the column subset totals.		Step 2: Run the tab and export to a spreadsheet. Sum up the Subset Total count for each column in the tab. Sum up the intersection value, where the row and column labels are the same, for each column of the tab. Divide the sum of the intersections by the sum of the column subset totals.

−	Here is a spreadsheet example: [[File: ExampleOfIndustryLoyalty.xls]]	+
		+	Here is a link to a spreadsheet example that illustrates this process. Please feel free to download and review the spreadsheet example and let us know if you have any further questions. [[File: ExampleOfIndustryLoyalty.xls ]]

← Older revision		Revision as of 17:14, 5 August 2013
Line 189:		Line 189:

	Step 2: Run the tab and export to a spreadsheet. Sum up the Subset Total count for each column in the tab. Sum up the intersection value, where the row and column labels are the same, for each column of the tab. Divide the sum of the intersections by the sum of the column subset totals.		Step 2: Run the tab and export to a spreadsheet. Sum up the Subset Total count for each column in the tab. Sum up the intersection value, where the row and column labels are the same, for each column of the tab. Divide the sum of the intersections by the sum of the column subset totals.
		+
		+	Here is a spreadsheet example: [[File: ExampleOfIndustryLoyalty.xls]]

@@ Line 22: / Line 22: @@
 The table is based (percentaged) by the ''vehicle purchased'', and displays the incidence of buyers who disposed/traded any of 200 different models as a result of purchasing their new vehicle. If no vehicle was disposed at the time of purchase, the first vehicle listed as an "other vehicle in the household" is substituted. In addition to this information, the table also displays the frequency of customers who ''did not own a vehicle''. For any model purchased, the sum of ''Vehicles disposed/traded'' (or owned,if no vehicle was disposed) and ''Did not own a vehicle'' equals 100%.
-'''%Calculation:''' (Previous Vehicle Owned*) / (Total Buyers of a model)
+'''%Calculation:''' (Previous Vehicle Owned*) &divide; (Total Buyers of a model)
-''*Vehicle disposed or inventory vehicle if no vehicle was disposed''
+:''*Vehicle disposed or inventory vehicle if no vehicle was disposed''
 '''Interpret:'''
@@ Line 68: / Line 68: @@
 The table is based (percentaged) by the ''vehicle disposed at the time of purchase''. If no vehicle was disposed at the time of purchase, then the  first vehicle listed as an "other vehicle in the household" is  substituted. The table displays the frequency of model purchased by the  disposers - or, if no vehicle was disposed, the owners - of any of 200  different models disposed or owned. For any model disposed/owned, the sum of  all "vehicles purchased" equals 100%.
-'''% Calculation:''' (Total Buyers of a Model) / Previous Vehicle Owned*
+'''% Calculation:''' (Total Buyers of a Model) &divide; Previous Vehicle Owned*
-''*Vehicle disposed or inventory vehicle if no vehicle was disposed''
+:''*Vehicle disposed or inventory vehicle if no vehicle was disposed''
 '''Interpret:'''
@@ Line 104: / Line 104: @@
 The table is based (percentaged) on the vehicle disposed at the time of  purchase.  For any qualifying model disposed, the sum of all  "vehicles purchased" percentages equals 100%.
-'''% Calculation:''' (Total Buyers of a Model) / Previous Vehicle Owned*
+'''% Calculation:''' (Total Buyers of a Model) &divide; Previous Vehicle Owned*
-''*Vehicle disposed, which at the time of purchase was new.''
+:''*Vehicle disposed, which at the time of purchase was new.''
 '''Interpret:'''
@@ Line 138: / Line 138: @@
 The table is based (percentaged) by the model purchased, and displays the incidence of disposing/trading-in any of 200 different vehicles as a result of purchasing the new vehicle. In addition to disposal information, the table also displays the frequency of customers who ''did not dispose of a vehicle'' or ''did not own a vehicle''. For any model purchased, the sum of 1) ''Vehicles disposed/traded'', 2) ''Did not dispose of a vehicle'', and 3) ''Did not own a vehicle'' equals 100%.
-'''% Calculation:''' (Vehicle  Disposed*)/(Total Buyers of a Model)
+'''% Calculation:''' (Vehicle  Disposed*) &divide; (Total Buyers of a Model)
-''*Vehicle disposed or inventory vehicle if no vehicle was disposed''
+:''*Vehicle disposed or inventory vehicle if no vehicle was disposed''
 '''Interpret:'''

@@ Line 1: / Line 1: @@
-'''SOS/Owner Loyalty/Repurchase Loyalty'''
+<span style="font-size:130%">'''SOS/Owner Loyalty/Repurchase Loyalty'''</span>
 This is one of the trickier areas of analysis. The very same questions are used to determine SOS, Owner Loyalty and Repurchase Loyalty. This page will explain the terms, give examples of their use, and include Maritz information.
@@ Line 171: / Line 171: @@
-'''Calculating Industry Loyalty'''
+<span style="font-size:130%">'''Calculating Industry Loyalty'''</span>
-−
 ''NOTE: There are various methods for calculating loyalty, please understand your 'corporate' definition prior to attempting any form of loyalty analysis.''

@@ Line 22: / Line 22: @@
 The table is based (percentaged) by the ''vehicle purchased'', and displays the incidence of buyers who disposed/traded any of 200 different models as a result of purchasing their new vehicle. If no vehicle was disposed at the time of purchase, the first vehicle listed as an "other vehicle in the household" is substituted. In addition to this information, the table also displays the frequency of customers who ''did not own a vehicle''. For any model purchased, the sum of ''Vehicles disposed/traded'' (or owned,if no vehicle was disposed) and ''Did not own a vehicle'' equals 100%.
-'''%Calculation:'''
+'''%Calculation:''' (Previous Vehicle Owned*) / (Total Buyers of a model)
-−
-<u>(Previous Vehicle Owned*)</u>
-−
 (Total Buyers of a model)
 ''*Vehicle disposed or inventory vehicle if no vehicle was disposed''
@@ Line 72: / Line 68: @@
 The table is based (percentaged) by the ''vehicle disposed at the time of purchase''. If no vehicle was disposed at the time of purchase, then the  first vehicle listed as an "other vehicle in the household" is  substituted. The table displays the frequency of model purchased by the  disposers - or, if no vehicle was disposed, the owners - of any of 200  different models disposed or owned. For any model disposed/owned, the sum of  all "vehicles purchased" equals 100%.
-'''% Calculation:''' (Total Buyers of a Model)/Previous Vehicle Owned*
+'''% Calculation:''' (Total Buyers of a Model) / Previous Vehicle Owned*
 ''*Vehicle disposed or inventory vehicle if no vehicle was disposed''
@@ Line 108: / Line 104: @@
 The table is based (percentaged) on the vehicle disposed at the time of  purchase.  For any qualifying model disposed, the sum of all  "vehicles purchased" percentages equals 100%.
-'''% Calculation:''' (Total Buyers of a Model)/Previous Vehicle Owned*
+'''% Calculation:''' (Total Buyers of a Model) / Previous Vehicle Owned*
 ''*Vehicle disposed, which at the time of purchase was new.''

@@ Line 20: / Line 20: @@
-The table is based (percentaged) by the ''vehicle purchased'', and displays the incidence of buyers who disposed/traded any of 200 different models as a result of purchasing their new vehicle. If no vehicle was disposed at the time of purchase, the first vehicle listed as an "other vehicle in the household" is substituted. In addition to this information, the table also displays the frequency of customers who ''did not own a vehicle''. For any model purchased, the sum of 1) ''Vehicles disposed/traded'' (or owned,if no vehicle was disposed), and 2) ''Did not own a vehicle equals 100%''.
+The table is based (percentaged) by the ''vehicle purchased'', and displays the incidence of buyers who disposed/traded any of 200 different models as a result of purchasing their new vehicle. If no vehicle was disposed at the time of purchase, the first vehicle listed as an "other vehicle in the household" is substituted. In addition to this information, the table also displays the frequency of customers who ''did not own a vehicle''. For any model purchased, the sum of ''Vehicles disposed/traded'' (or owned,if no vehicle was disposed) and ''Did not own a vehicle'' equals 100%.
 '''%Calculation:''' (Previous Vehicle Owned*)/(Total Buyers of a model)
@@ Line 63: / Line 63: @@
 '''Owner Loyalty'''
-Owner Loyalty answers the question, "Where did the business  go?" In other words, what did my ''former'' customers do when  they re-entered the market?
+Owner Loyalty answers the question, "Where did the business  go?" In other words, what did my ''former'' customers do when they re-entered the market?

@@ Line 13: / Line 13: @@
 '''Vehicle Disposed At Time Of Purchase''' - The simple answer to the question, "What did my customers dispose of when they bought their new vehicle?"
@@ Line 155: / Line 154: @@
 | || Honda || Acura || Mazda || Mitsubishi
 |-
-| colspan="5" style="text-align: center;" | B
+| colspan="5" | Disposed: Corp/Div
 |-
 | Honda || 30.56% || 11.49% || 6.14% || 6.01%

@@ Line 16: / Line 16: @@
-'''SOS - Source of Sales
+'''SOS - Source of Sales'''
 '''
 ''Source of Sales'' answers the question, "Where did the business come from?" In other words, what model did my ''recently acquired'' customers dispose of - or if no vehicle was disposed, what vehicle did they own - when they purchased their new vehicle?
@@ Line 36: / Line 35: @@
 {| class="wikitable"
 |-
-| || Corp/Div Purchased
+| || colspan="4" style="text-align: center;" | Corp/Div Purchased
 |-
 | || Honda || Acura || Mazda || Mitsubishi
 |-
-| Source of Sales/Owner Loyalty
+| colspan="5" | Source of Sales/Owner Loyalty
 |-
 | Honda || 30.56% || 11.46% || 6.14% || 6.01%
@@ Line 60: / Line 59: @@
 | Special Codes || 20.21% || 19.3% || 23.15% || 23.9%
 |-
-| ''Note: Numbers are examples, not actual values!''
+| colspan="5" style="text-align: center;" | ''Note: Numbers are examples, not actual values!''
 |}
@@ Line 82: / Line 81: @@
 {| class="wikitable"
 |-
-| || Source of Sales/Owner Loyalty
+| || colspan="4" style="text-align: center;" | Source of Sales/Owner Loyalty
 |-
 | || Honda || Acura || Mazda || Mitsubishi
 |-
-| Corp/Div Purchased
+| colspan="5" | Corp/Div Purchased
 |-
 | Honda || 42.56% || 21.77% || 10.27% || 5.07%
@@ Line 96: / Line 95: @@
 | Mitsubishi || 2.17% || 1.29% || 3.58% || 32.48%
 |-
-| ''Note: Numbers are examples, not actual values!''
+| colspan="5" style="text-align: center;" | ''Note: Numbers are examples, not actual values!''
 |}
@@ Line 118: / Line 117: @@
 {| class="wikitable"
 |-
-| || Repurchase Loyalty
+| || colspan="4" style="text-align: center;" | Repurchase Loyalty
 |-
 | || Accord || Civic || CRX || Prelude
 |-
-| Corp/Div Purchased
+| colspan="5" | Corp/Div Purchased
 |-
 | Honda || 48.88% || 48.88% || 38.94% || 27.28%
@@ Line 152: / Line 151: @@
 {| class="wikitable"
 |-
-| || Corp/Div Purchased
+| || colspan="4" style="text-align: center;" | Corp/Div Purchased
 |-
 | || Honda || Acura || Mazda || Mitsubishi
 |-
-| || Disposed: Corp/Div
+| colspan="5" style="text-align: center;" | B
 |-
 | Honda || 30.56% || 11.49% || 6.14% || 6.01%