8/14/2019 Promo Tracking MSG Nov07

1/35

10/22/2008

ANALYSIS Total Sales for Month $56,857.41 MONTH: November-07

AmericInn wizard card Birthdays 1/2 Bday cold Bdays Trick or Treat RR certs cmmty supt

$5.00 $1.00 $130.68 $157.85 $420.40 $60.00 $54.00 $5.00

100 1 297 287 286 500 100 100

2 7 57 24 45 76 44 3

2.00% 700.00% 19.19% 8.36% 15.73% 15.20% 44.00% 3.00%

1.50 3.29 2.61 2.42 2.82 2.55 2.64 2.67

3 23 149 58 127 194 116 8

$15.63 $38.34 $39.78 $37.52 $45.81 $37.74 $39.68 $27.13

$8.60 $23.60 $17.69 $18.61 $22.16 $20.56 $18.73 $9.47

$31.26 $268.38 $2,267.25 $900.41 $2,061.49 $2,868.44 $1,745.76 $81.40

$4.68 $22.65 $578.54 $183.53 $445.96 $445.59 $397.70 $28.58

$12.20 $164.22 $877.86 $288.91 $576.68 $1,502.32 $770.33 $23.40

244.04% 16421.60% 671.76% 183.03% 137.17% 2503.86% 1426.54% 468.00%

0

rs TG email Diner return sweet tooth Holiday VIP open mgr card survey TOTALS

$25.00 $- $161.20 $255.00 $- $- $- $1,280.13

1022 0 520 500 100 0 0 3,913

9 0 2 42 0 0 0 315

0.88% 0.38% 8.40% 0.00% 8.05%

3.44 #DIV/0! 2.00 2.60 #DIV/0! #DIV/0! #DIV/0! 2.63

31 0 4 109 0 0 0 829

$41.57 #DIV/0! $27.38 $38.13 #DIV/0! #DIV/0! #DIV/0! $39.21

$21.86 #DIV/0! $16.17 $21.39 #DIV/0! #DIV/0! #DIV/0! $15.72

$374.15 $- $54.75 $1,601.41 $- $- $- $12,350.46

$65.16 $- $5.98 $222.73 $ - $- $- $2,414.15 19.55%$171.75 $- $(128.86) $643.26 $- $- $- $4,951.04 40.09%

686.98% #DIV/0! -79.93% 252.26% #DIV/0! #DIV/0! #DIV/0! 386.76%

as % of Total Revenue 21.72% Discounts as % of TTL Sales 4.25%

8/14/2019 Promo Tracking MSG Nov07

2/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION: Super 8

15% off hotel referral

30.0%Date # cstmr Ttl Sales $ Discnt After Disc Prod Cost Net ProfitTotal 7 $95.76 $13.05 $82.71 $28.73 $53.98

8-Nov 2 $21.98 $3.30 $18.68 $6.59 $12.0912-Nov 1 $16.24 $1.80 $14.44 $4.87 $9.5713-Nov 2 $19.57 $2.25 $17.32 $5.87 $11.45

27-Nov 2 $37.97 $5.70 $32.27 $11.39 $20.88

8/14/2019 Promo Tracking MSG Nov07

3/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION:

Super 8 November-0715% off hotel referral

Date of Mailing:Expiration Date:

Number of pieces mailed 100

Number of pieces returned 4Response Return % 4.00%

Avg # Customers/ piece returned 1.75Avg Purchase per coupon $23.94

After Discount $20.68

Total Revenues $95.76

Cost of Prizes/ProductsOther related expensesMailing list cost per piece cost

Postage $-Paper & Printing $5.00 $0.05Cost of Promotion $5.00

Cost of Goods $28.73 30.00%

Discount $ $13.05 13.63%Cost of Food & Discount $41.78 43.63%

- Total Expenses $46.78

Net Profit/loss $48.98 51.15%

Avg Profit/ piece returned $13.50Avg Profit/ piece mailed $0.49

Avg Cost/ piece mailed $0.05Return on Investment 979.64%

Tips generated @ 15% $14.36If tip after discount $12.41

Summary

Super 8

15% off hotel referralCost of Promotion $5.00Total Pieces sent 100Total Pieces Returned 4% Returned 4.00%Average # customers 1.75Total # of customers 7

Average Purchase $23.94

Average Profit per redeemed $13.50Total Revenue $95.76

Total Discounts $13.05Net Profit $48.98ROI 979.64%

Notes:These are referrals from localhotel.Front desk personnel are signedup as rewards members andreceive points for purchases ofguests who they refer. to us.We give the hotels business sizecards to give the guests which aregood for 15% off food purchased.

8/14/2019 Promo Tracking MSG Nov07

4/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION: AmericInn

15% off hotel referral

30.0%Date # cstmr Ttl Sales $ Discnt After Disc Prod Cost Net ProfitTotal 3 $31.26 $4.68 $26.58 $9.38 $17.20

26-Nov 1 $10.29 $1.54 $8.75 $3.09 $5.6627-Nov 2 $20.97 $3.14 $17.83 $6.29 $11.54

8/14/2019 Promo Tracking MSG Nov07

5/35

8/14/2019 Promo Tracking MSG Nov07

6/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION: wizard card

10% off total food

30.0%Date # cstmr Ttl Sales $ Discnt After Disc Prod Cost Net Profit

Total 23 $268.38 $22.65 $245.73 $80.51 $165.226-Nov 4 $46.28 $4.17 $42.11 $13.88 $28.23

15-Nov 2 $23.06 $1.85 $21.21 $6.92 $14.29

16-Nov 2 $55.46 $4.40 $51.06 $16.64 $34.423 $28.97 $2.90 $26.07 $8.69 $17.38

18-Nov 4 $34.56 $1.50 $33.06 $10.37 $22.69

19-Nov 3 $39.35 $3.76 $35.59 $11.81 $23.7927-Nov 5 $40.70 $4.07 $36.63 $12.21 $24.42

8/14/2019 Promo Tracking MSG Nov07

7/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION:wizard card

10% off total foodDate of Mailing: 1-Sep-07Expiration Date: 30-Sep-08

Number of pieces mailed 1Number of pieces returned 7

Response Return % 700.00%

Avg # Customers/ piece returned 3.29

Avg Purchase per coupon $38.34After Discount $35.10

Total Revenues $268.38

Cost of Prizes/ProductsOther related expenses

Mailing list cost $1.00 per piece costPostage $-Paper & Printing $-

Cost of Promotion $1.00

Cost of Goods $80.51 30.00%

Discount $ $22.65 8.44%Cost of Food & Discount $103.16 38.44%- Total Expenses $104.16

Net Profit/loss $164.22 61.19%

Avg Profit/ piece returned $23.60

Avg Profit/ piece mailed $164.22Avg Cost/ piece mailed $1.00Return on Investment 16421.60%

Tips generated @ 15% $40.26If tip after discount $36.86

Summary

wizard card

10% off total foodCost of Promotion $1.00Total Pieces sent 1Total Pieces Returned 7% Returned 700.00%Average # customers 3.29

Total # of customers 23Average Purchase $38.34

Average Profit per redeemed $23.60

Total Revenue $268.38Total Discounts $22.65Net Profit $164.22

ROI 16421.60%

Notes:This is a discount card given topeople who purchased a cardfrom the local high school tobenefit the athletic department.

Our offer is 10% off their foodpurchase.Last year we did 15% off.The card is good for an entireyear.

8/14/2019 Promo Tracking MSG Nov07

8/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION: Birthdays

$10 off dinner

30.0%Date # cstmr Ttl Sales $ Discnt After Disc Prod Cost Net Profit

Total 149 $2,267.25 $578.54 $1,688.71 $680.18 $1,008.541-Nov 2 $37.29 $10.00 $27.29 $11.19 $16.10

2 $45.22 $10.00 $35.22 $13.57 $21.65

2-Nov 2 $46.78 $10.00 $36.78 $14.03 $22.753-Nov 2 $24.86 $9.99 $14.87 $7.46 $7.41

3 $34.59 $9.49 $25.10 $10.38 $14.72

4 $63.28 $10.00 $53.28 $18.98 $34.302 $27.98 $10.00 $17.98 $8.39 $9.592 $51.27 $10.00 $41.27 $15.38 $25.892 $25.27 $10.00 $15.27 $7.58 $7.69

4-Nov 2 $22.56 $10.00 $12.56 $6.77 $5.796-Nov 4 $27.31 $8.99 $18.32 $8.19 $10.13

7-Nov 2 $51.53 $9.98 $41.55 $15.46 $26.092 $14.74 $8.99 $5.75 $4.42 $1.338-Nov 3 $39.26 $9.49 $29.77 $11.78 $17.99

2 $34.06 $10.00 $24.06 $10.22 $13.84

9-Nov 2 $36.46 $10.00 $26.46 $10.94 $15.523 $45.47 $10.00 $35.47 $13.64 $21.832 $44.98 $10.00 $34.98 $13.49 $21.492 $32.27 $10.00 $22.27 $9.68 $12.59

2 $41.92 $10.00 $31.92 $12.58 $19.3412-Nov 5 $58.03 $10.00 $48.03 $17.41 $30.62

6 $75.42 $10.00 $65.42 $22.63 $42.79

2 $29.28 $10.00 $19.28 $8.78 $10.5012-Nov 2 $19.97 $9.99 $9.98 $5.99 $3.9914-Nov 4 $49.84 $10.00 $39.84 $14.95 $24.89

15-Nov 2 $25.98 $9.99 $15.99 $7.79 $8.2016-Nov 2 $33.48 $8.99 $24.49 $10.04 $14.4516-Nov 2 $24.56 $10.00 $14.56 $7.37 $7.19

2 $37.31 $10.00 $27.31 $11.19 $16.12

2 $30.98 $10.00 $20.98 $9.29 $11.692 $42.75 $10.00 $32.75 $12.83 $19.932 $30.23 $11.00 $19.23 $9.07 $10.16

2 $22.74 $10.00 $12.74 $6.82 $5.92

17-Nov 2 $34.53 $9.99 $24.54 $10.36 $14.18

2 $55.97 $13.99 $41.98 $16.79 $25.19

2 $43.71 $10.00 $33.71 $13.11 $20.60

4 $61.11 $10.00 $51.11 $18.33 $32.78

18-Nov 2 $27.98 $10.00 $17.98 $8.39 $9.59

19-Nov 2 $22.98 $10.00 $12.98 $6.89 $6.09

2 $34.15 $12.99 $21.16 $10.25 $10.92

3 $63.46 $10.00 $53.46 $19.04 $34.4220-Nov 2 $22.02 $9.99 $12.03 $6.61 $5.42

2 $23.81 $9.74 $14.07 $7.14 $6.93

23-Nov 4 $48.57 $9.99 $38.58 $14.57 $24.01

2 $27.52 $9.99 $17.53 $8.26 $9.27

24-Nov 7 $45.33 $9.99 $35.34 $13.60 $21.74

25-Nov 2 $24.56 $8.99 $15.57 $7.37 $8.2027-Nov 2 $22.98 $9.99 $12.99 $6.89 $6.1028-Nov 2 $44.53 $10.00 $34.53 $13.36 $21.17

29-Nov 2 $23.76 $10.00 $13.76 $7.13 $6.632 $51.97 $10.00 $41.97 $15.59 $26.384 $42.26 $10.00 $32.26 $12.68 $19.58

30-Nov 2 $23.56 $10.00 $13.56 $7.07 $6.49

4 $119.95 $14.00 $105.95 $35.99 $69.97

2 $47.47 $11.99 $35.48 $14.24 $21.245 $56.09 $10.00 $46.09 $16.83 $29.26

4 $71.31 $10.00 $61.31 $21.39 $39.92

8/14/2019 Promo Tracking MSG Nov07

9/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION:Birthdays

$10 off dinnerDate of Mailing: 2-Oct-07Expiration Date: 31-Oct-07

Number of pieces mailed 297Number of pieces returned 57

Response Return % 19.19%

Avg # Customers/ piece returned 2.61

Avg Purchase per coupon $39.78After Discount $29.63

Total Revenues $2,267.25

Cost of Prizes/ProductsOther related expenses

Mailing list cost per piece costPostage $130.68 $0.44Paper & Printing $-

Cost of Promotion $130.68

Cost of Goods $680.18 30.00%Discount $ $578.54 25.52%

Cost of Food & Discount $1,258.72 55.52%- Total Expenses $1,389.40

Net Profit/loss $877.86 38.72%

Avg Profit/ piece returned $17.69

Avg Profit/ piece mailed $2.96Avg Cost/ piece mailed $0.44Return on Investment 671.76%

Tips generated @ 15% $340.09If tip after discount $253.31

Summary

Birthdays$10 off dinner

Cost of Promotion $130.68

Total Pieces sent 297Total Pieces Returned 57

% Returned 19.19%

Average # customers 2.61

Total # of customers 149Average Purchase $39.78

Average Profit per redeemed $17.69

Total Revenue $2,267.25Total Discounts $578.54

Net Profit $877.86

ROI 671.76%

Notes:

8/14/2019 Promo Tracking MSG Nov07

10/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION: 1/2 Bday

1/2 off entre

30.0%Date # cstmr Ttl Sales $ Discnt After Disc Prod Cost Net Profit

Total 58 $900.41 $183.53 $716.88 $270.12 $446.761-Nov 4 $37.04 $4.49 $32.55 $11.11 $21.44

2 $19.98 $4.99 $14.99 $5.99 $9.00

2-Nov 2 $20.48 $6.99 $13.49 $6.14 $7.353-Nov 7 $151.60 $7.49 $144.11 $45.48 $98.63

5 $84.99 $15.98 $69.01 $25.50 $43.51

4-Nov 2 $13.99 $6.99 $7.00 $4.20 $2.809-Nov 2 $48.48 $8.49 $39.99 $14.54 $25.45

12-Nov 2 $21.21 $10.00 $11.21 $6.36 $4.853 $41.47 $10.00 $31.47 $12.44 $19.03

14-Nov 1 $24.49 $10.49 $14.00 $7.35 $6.652 $30.98 $4.49 $26.49 $9.29 $17.20

15-Nov 2 $32.27 $7.49 $24.78 $9.68 $15.10

16-Nov 2 $32.48 $8.49 $23.99 $9.74 $14.2517-Nov 2 $37.98 $5.99 $31.99 $11.39 $20.6020-Nov 2 $11.28 $4.49 $6.79 $3.38 $3.41

2 $44.77 $7.49 $37.28 $13.43 $23.851 $35.49 $9.24 $26.25 $10.65 $15.60

26-Nov 4 $50.04 $8.99 $41.05 $15.01 $26.0429-Nov 2 $20.77 $4.49 $16.28 $6.23 $10.05

1 $12.28 $4.99 $7.29 $3.68 $3.612 $16.27 $4.50 $11.77 $4.88 $6.89

30-Nov 2 $28.56 $5.99 $22.57 $8.57 $14.00

2 $30.56 $6.99 $23.57 $9.17 $14.402 $52.95 $13.99 $38.96 $15.89 $23.08

8/14/2019 Promo Tracking MSG Nov07

11/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION:1/2 Bday

1/2 off entreDate of Mailing: 3-Oct-07Expiration Date: 31-Oct-07

Number of pieces mailed 287Number of pieces returned 24

Response Return % 8.36%

Avg # Customers/ piece returned 2.42

Avg Purchase per coupon $37.52After Discount $29.87

Total Revenues $900.41

Cost of Prizes/ProductsOther related expenses

Mailing list cost per piece costPostage $157.85 $0.55Paper & Printing $-

Cost of Promotion $157.85

Cost of Goods $270.12 30.00%Discount $ $183.53 20.38%

Cost of Food & Discount $453.65 50.38%

- Total Expenses $611.50

Net Profit/loss $288.91 32.09%

Avg Profit/ piece returned 18.61

Avg Profit/ piece mailed $1.01Avg Cost/ piece mailed $0.55Return on Investment 183.03%

Tips generated @ 15% $135.06If tip after discount $107.53

Summary

1/2 Bday1/2 off entre

Cost of Promotion $157.85

Total Pieces sent 287Total Pieces Returned 24% Returned 8.36%Average # customers 2.42

Total # of customers 58Average Purchase $37.52

Average Profit per redeemed $18.61

Total Revenue $900.41Total Discounts $183.53Net Profit $288.91

ROI 183.03%

Notes:These cards are mailed outto members 6 months orhalf way to their nextbirthday. On this offer wegive them 1/2 off any one

item from our menu. Mostpeople get 1/2 off anentre.

8/14/2019 Promo Tracking MSG Nov07

12/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION: cold Bdays

entre up to $10

30.0%Date # cstmr Ttl Sales $ Discnt After Disc Prod Cost Net Profit

Total 127 $2,061.49 $445.96 $1,615.53 $618.45 $997.081-Nov 4 $47.53 $10.00 $37.53 $14.26 $23.277-Nov 4 $49.32 $10.00 $39.32 $14.80 $24.52

4 $49.08 $10.00 $39.08 $14.72 $24.362 $44.52 $11.00 $33.52 $13.36 $20.16

8-Nov 2 $26.27 $10.00 $16.27 $7.88 $8.39

5 $92.98 $10.00 $82.98 $27.89 $55.099-Nov 2 $38.77 $10.00 $28.77 $11.63 $17.14

4 $90.66 $5.00 $85.66 $27.20 $58.463 $43.54 $10.00 $33.54 $13.06 $20.48

2 $52.77 $10.00 $42.77 $15.83 $26.9411-Nov 10 $178.85 $5.00 $173.85 $53.66 $120.20

13-Nov 4 $51.96 $10.00 $41.96 $15.59 $26.372 $44.98 $10.00 $34.98 $13.49 $21.4914-Nov 2 $30.30 $8.99 $21.31 $9.09 $12.2215-Nov 3 $28.94 $9.99 $18.95 $8.68 $10.27

16-Nov 2 $24.31 $10.00 $14.31 $7.29 $7.022 $31.77 $11.00 $20.77 $9.53 $11.24

17-Nov 3 $43.75 $10.00 $33.75 $13.13 $20.632 $26.97 $10.00 $16.97 $8.09 $8.88

2 $53.98 $10.00 $43.98 $16.19 $27.792 $27.48 $10.00 $17.48 $8.24 $9.24

18-Nov 2 $46.71 $10.00 $36.71 $14.01 $22.70

19-Nov 2 $33.75 $10.00 $23.75 $10.13 $13.632 $19.77 $10.00 $9.77 $5.93 $3.842 $42.48 $10.00 $32.48 $12.74 $19.74

21-Nov 2 $26.27 $10.00 $16.27 $7.88 $8.392 $40.77 $10.00 $30.77 $12.23 $18.54

23-Nov 2 $54.47 $10.00 $44.47 $16.34 $28.1324-Nov 3 $50.25 $10.00 $40.25 $15.08 $25.18

25-Nov 4 $61.01 $10.00 $51.01 $18.30 $32.7126-Nov 2 $15.98 $10.00 $5.98 $4.79 $1.19

2 $48.27 $10.00 $38.27 $14.48 $23.79

4 $65.04 $10.00 $55.04 $19.51 $35.53

27-Nov 2 $34.98 $10.00 $24.98 $10.49 $14.49

2 $48.48 $10.00 $38.48 $14.54 $23.94

28-Nov 1 $9.99 $9.99 $- $3.00 $(3.00)

3 $66.04 $10.00 $56.04 $19.81 $36.23

4 $33.81 $10.00 $23.81 $10.14 $13.67

3 $46.55 $10.00 $36.55 $13.97 $22.59

29-Nov 5 $41.44 $10.00 $31.44 $12.43 $19.01

2 $42.22 $10.00 $32.22 $12.67 $19.552 $26.27 $10.00 $16.27 $7.88 $8.39

30-Nov 2 $43.76 $10.00 $33.76 $13.13 $20.63

3 $25.98 $10.00 $15.98 $7.79 $8.19

3 $58.47 $14.99 $43.48 $17.54 $25.94

8/14/2019 Promo Tracking MSG Nov07

13/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION:cold Bdays

entre up to $10Date of Mailing: 30-Sep-07Expiration Date: 31-Oct-07

Number of pieces mailed 286Number of pieces returned 45

Response Return % 15.73%

Avg # Customers/ piece returned 2.82

Avg Purchase per coupon $45.81After Discount $35.90

Total Revenues $2,061.49

Cost of Prizes/ProductsOther related expenses 20

Mailing list cost per piece costPostage $117.26 $0.41Paper & Printing $283.14 $0.99

Cost of Promotion $420.40

Cost of Goods $618.45 30.00%Discount $ $445.96 21.63%

Cost of Food & Discount $1,064.41 51.63%- Total Expenses $1,484.81

Net Profit/loss $576.68 27.97%

Avg Profit/ piece returned $22.16

Avg Profit/ piece mailed $2.02Avg Cost/ piece mailed $1.47Return on Investment 137.17%

Tips generated @ 15% $309.22If tip after discount $242.33

Summary

cold Bdaysentre up to $10

Cost of Promotion $420.40

Total Pieces sent 286Total Pieces Returned 45

% Returned 15.73%

Average # customers 2.82

Total # of customers 127Average Purchase $45.81

Average Profit per redeemed $22.16

Total Revenue $2,061.49Total Discounts $445.96

Net Profit $576.68

ROI 137.17%

Notes:

8/14/2019 Promo Tracking MSG Nov07

14/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION: RR certs

30.0%Date # cstmr Ttl Sales $ Discnt After Disc Prod Cost Net Profit

Total 116 $1,745.76 $397.70 $1,348.06 $523.73 $824.331-Nov 1 $14.49 $10.00 $4.49 $4.35 $0.14

4 $56.33 $10.00 $46.33 $16.90 $29.43

2-Nov 2 $30.52 $10.00 $20.52 $9.16 $11.362 $62.27 $10.00 $52.27 $18.68 $33.592 $20.27 $10.00 $10.27 $6.08 $4.19

1 $23.99 $10.00 $13.99 $7.20 $6.793-Nov 8 $17.78 $10.00 $7.78 $5.33 $2.45

8 $38.22 $10.00 $28.22 $11.47 $16.755-Nov 3 $39.59 $10.00 $29.59 $11.88 $17.71

6-Nov 4 $46.57 $10.00 $36.57 $13.97 $22.609-Nov 2 $32.27 $10.00 $22.27 $9.68 $12.59

2 $38.77 $10.00 $28.77 $11.63 $17.1410-Nov 2 $37.96 $10.00 $27.96 $11.39 $16.5711-Nov 4 $29.86 $10.00 $19.86 $8.96 $10.90

2 $43.46 $5.99 $37.47 $13.04 $24.43

2 $40.55 $10.00 $30.55 $12.17 $18.392 $41.98 $9.49 $32.49 $12.59 $19.90

13-Nov 1 $9.49 $9.49 $- $2.85 $(2.85)2 $42.27 $7.95 $34.32 $12.68 $21.64

14-Nov 1 $38.78 $6.79 $31.99 $11.63 $20.364 $49.84 $10.00 $39.84 $14.95 $24.89

15-Nov 2 $24.27 $2.00 $22.27 $7.28 $14.99

2 $26.98 $6.49 $20.49 $8.09 $12.4016-Nov 2 $26.55 $10.00 $16.55 $7.97 $8.59

2 $52.49 $6.79 $45.70 $15.75 $29.95

2 $32.73 $10.00 $22.73 $9.82 $12.9117-Nov 4 $58.81 $10.00 $48.81 $17.64 $31.17

3 $27.34 $7.95 $19.39 $8.20 $11.1919-Nov 1 $23.77 $4.99 $18.78 $7.13 $11.65

2 $22.79 $10.00 $12.79 $6.84 $5.9520-Nov 4 $63.69 $7.95 $55.74 $19.11 $36.6321-Nov 2 $48.77 $6.79 $41.98 $14.63 $27.35

2 $19.47 $10.00 $9.47 $5.84 $3.63

23-Nov 3 $40.95 $6.99 $33.96 $12.29 $21.68

2 $50.27 $6.79 $43.48 $15.08 $28.40

3 $73.70 $20.98 $52.72 $22.11 $30.61

24-Nov 2 $19.73 $10.00 $9.73 $5.92 $3.81

2 $59.64 $10.39 $49.25 $17.89 $31.36

4 $91.89 $5.99 $85.90 $27.57 $58.33

4 $88.49 $7.95 $80.54 $26.55 $53.99

25-Nov 2 $43.98 $10.00 $33.98 $13.19 $20.794 $57.23 $5.99 $51.24 $17.17 $34.07

27-Nov 1 $16.49 $9.95 $6.54 $4.95 $1.59

28-Nov 2 $20.47 $10.00 $10.47 $6.14 $4.33

8/14/2019 Promo Tracking MSG Nov07

15/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION:RR certs

0Date of Mailing:Expiration Date:

Number of pieces mailed 100Number of pieces returned 44

Response Return % 44.00%

Avg # Customers/ piece returned 2.64

Avg Purchase per coupon $39.68After Discount $30.64

Total Revenues $1,745.76

Cost of Prizes/ProductsOther related expenses

Mailing list cost per piece costPostage $-Paper & Printing $54.00 $0.54

Cost of Promotion $54.00

Cost of Goods $523.73 30.00%Discount $ $397.70 22.78%

Cost of Food & Discount $921.43 52.78%- Total Expenses $975.43

Net Profit/loss $770.33 44.13%

Avg Profit/ piece returned $18.73

Avg Profit/ piece mailed $7.70Avg Cost/ piece mailed $0.54Return on Investment 1426.54%

Tips generated @ 15% $261.86If tip after discount $202.21

Summary

RR certs$-

Cost of Promotion $54.00

Total Pieces sent 100Total Pieces Returned 44

% Returned 44.00%

Average # customers 2.64

Total # of customers 116Average Purchase $39.68

Average Profit per redeemed $18.73

Total Revenue $1,745.76Total Discounts $397.70

Net Profit $770.33

ROI 1426.54%

Notes:

8/14/2019 Promo Tracking MSG Nov07

16/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION: Trick or Treat

multiple offers

30.0%Date # cstmr Ttl Sales $ Discnt After Disc Prod Cost Net Profit

Total 194 $2,868.44 $445.59 $2,422.85 $860.53 $1,562.321-Nov 2 $27.98 $2.80 $25.18 $8.39 $16.792-Nov 2 $51.48 $2.40 $49.08 $15.44 $33.64

3 $52.96 $8.49 $44.47 $15.89 $28.582 $43.98 $6.99 $36.99 $13.19 $23.80

3-Nov 2 $33.48 $2.50 $30.98 $10.04 $20.94

3 $38.44 $3.75 $34.69 $11.53 $23.162 $23.27 $5.49 $17.78 $6.98 $10.802 $28.05 $6.74 $21.31 $8.42 $12.905 $64.61 $4.70 $59.91 $19.38 $40.53

2 $41.96 $6.99 $34.97 $12.59 $22.384-Nov 4 $25.56 $2.10 $23.46 $7.67 $15.79

3 $32.56 $2.00 $30.56 $9.77 $20.795-Nov 2 $15.98 $4.25 $11.73 $4.79 $6.946-Nov 2 $14.07 $2.37 $11.70 $4.22 $7.48

2 $23.98 $2.40 $21.58 $7.19 $14.39

4 $46.54 $4.65 $41.89 $13.96 $27.933 $36.97 $5.50 $31.47 $11.09 $20.38

7-Nov 2 $22.76 $2.50 $20.26 $6.83 $13.432 $153.98 $2.75 $151.23 $46.19 $105.04

2 $29.56 $7.49 $22.07 $8.87 $13.202 $17.06 $4.99 $12.07 $5.12 $6.95

8-Nov 2 $57.42 $3.15 $54.27 $17.23 $37.04

2 $25.05 $4.49 $20.56 $7.52 $13.054 $52.12 $2.50 $49.62 $15.64 $33.983 $38.46 $0.90 $37.56 $11.54 $26.02

9-Nov 2 $26.23 $2.20 $24.03 $7.87 $16.1610-Nov 2 $31.90 $5.00 $26.90 $9.57 $17.33

2 $21.98 $5.49 $16.49 $6.59 $9.905 $68.33 $4.50 $63.83 $20.50 $43.33

12-Nov 2 $30.32 $2.07 $28.25 $9.10 $19.152 $24.05 $1.95 $22.10 $7.22 $14.893 $59.04 $3.75 $55.29 $17.71 $37.58

2 $13.98 $1.40 $12.58 $4.19 $8.39

13-Nov 3 $47.51 $5.59 $41.92 $14.25 $27.67

14-Nov 2 $22.27 $2.00 $20.27 $6.68 $13.59

3 $28.82 $9.99 $18.83 $8.65 $10.18

2 $35.97 $9.00 $26.97 $10.79 $16.18

2 $14.07 $- $14.07 $4.22 $9.85

15-Nov 2 $36.04 $5.49 $30.55 $10.81 $19.74

6 $84.43 $8.49 $75.94 $25.33 $50.61

16-Nov 3 $40.02 $7.49 $32.53 $12.01 $20.522 $53.33 $4.86 $48.47 $16.00 $32.47

3 $51.59 $4.48 $47.11 $15.48 $31.63

17-Nov 2 $19.23 $1.93 $17.30 $5.77 $11.53

8 $68.72 $6.99 $61.73 $20.62 $41.11

1 $14.99 $3.75 $11.24 $4.50 $6.74

2 $33.98 $7.49 $26.49 $10.19 $16.3018-Nov 2 $18.73 $1.87 $16.86 $5.62 $11.24

1 $13.28 $1.10 $12.18 $3.98 $8.20

2 $32.98 $3.30 $29.68 $9.89 $19.7920-Nov 2 $26.48 $2.65 $23.83 $7.94 $15.89

2 $33.38 $4.41 $28.97 $10.01 $18.9621-Nov 2 $51.53 $6.99 $44.54 $15.46 $29.08

2 $36.26 $6.99 $29.27 $10.88 $18.39

23-Nov 6 $118.28 $8.95 $109.33 $35.48 $73.8524-Nov 2 $59.64 $10.39 $49.25 $17.89 $31.36

2 $30.61 $2.75 $27.86 $9.18 $18.685 $52.90 $10.04 $42.86 $15.87 $26.996 $13.05 $89.79 $(76.74) $3.92 $(80.66)

26-Nov 2 $17.48 $4.37 $13.11 $5.24 $7.8727-Nov 2 $30.56 $2.39 $28.17 $9.17 $19.00

1 $30.48 $3.95 $26.53 $9.14 $17.394 $57.53 $6.99 $50.54 $17.26 $33.28

28-Nov 2 $16.27 $6.79 $9.48 $4.88 $4.602 $12.78 $6.38 $6.40 $3.83 $2.573 $30.26 $9.99 $20.27 $9.08 $11.19

2 $26.97 $7.49 $19.48 $8.09 $11.393 $33.84 $3.00 $30.84 $10.15 $20.69

29-Nov 2 $30.48 $4.99 $25.49 $9.14 $16.35

2 $42.46 $7.95 $34.51 $12.74 $21.772 $43.02 $4.87 $38.15 $12.91 $25.242 $33.32 $2.70 $30.62 $10.00 $20.621 $13.99 $3.50 $10.49 $4.20 $6.29

2 $44.35 $4.00 $40.35 $13.31 $27.0530-Nov 1 $21.99 $5.50 $16.49 $6.60 $9.89

2 $70.46 $4.70 $65.76 $21.14 $44.62

8/14/2019 Promo Tracking MSG Nov07

17/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION:Trick or Treat

multiple offersDate of Mailing: october Expiration Date: 30-Nov-07

Number of pieces mailed 500Number of pieces returned 76

Response Return % 15.20%

Avg # Customers/ piece returned 2.55

Avg Purchase per coupon $37.74After Discount $31.88

Total Revenues $2,868.44

Cost of Prizes/ProductsOther related expenses

Mailing list cost per piece costPostage $-Paper & Printing $60.00 $0.12

Cost of Promotion $60.00

Cost of Goods $860.53 30.00%Discount $ $445.59 15.53%

Cost of Food & Discount $1,306.12 45.53%

- Total Expenses $1,366.12

Net Profit/loss $1,502.32 52.37%

Avg Profit/ piece returned $20.56

Avg Profit/ piece mailed $3.00Avg Cost/ piece mailed $0.12Return on Investment 2503.86%

Tips generated @ 15% $430.27If tip after discount $363.43

Summary

Trick or Treatmultiple offers

Cost of Promotion $60.00

Total Pieces sent 500Total Pieces Returned 76% Returned 15.20%Average # customers 2.55

Total # of customers 194Average Purchase $37.74

Average Profit per redeemed $20.56

Total Revenue $2,868.44Total Discounts $445.59Net Profit $1,502.32

ROI 2503.86%

Notes:These were scratch cardshanded out in October.The offers were mostly 10%off food bill, with some 20%off, a few 50% off entree,

and a few free entre, andmany free desserts/appetizers..

8/14/2019 Promo Tracking MSG Nov07

18/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION: Holiday VIP

$5 off

30.0%Date # cstmr Ttl Sales $ Discnt After Disc Prod Cost Net Profit

Total 109 $1,601.41 $222.73 $1,378.68 $480.42 $898.2616-Nov 2 $32.52 $5.00 $27.52 $9.76 $17.7617-Nov 2 $19.48 $5.00 $14.48 $5.84 $8.64

2 $38.92 $5.00 $33.92 $11.68 $22.242 $33.56 $5.00 $28.56 $10.07 $18.496 $104.18 $5.00 $99.18 $31.25 $67.93

2 $39.22 $5.00 $34.22 $11.77 $22.452 $49.97 $5.00 $44.97 $14.99 $29.98

18-Nov 6 $75.06 $5.00 $70.06 $22.52 $47.542 $39.98 $5.00 $34.98 $11.99 $22.99

2 $33.98 $5.00 $28.98 $10.19 $18.7920-Nov 2 $43.48 $5.00 $38.48 $13.04 $25.44

2 $18.48 $5.00 $13.48 $5.54 $7.944 $31.84 $5.00 $26.84 $9.55 $17.2921-Nov 3 $50.26 $5.00 $45.26 $15.08 $30.18

3 $42.09 $5.00 $37.09 $12.63 $24.46

2 $33.96 $8.00 $25.96 $10.19 $15.772 $34.27 $6.00 $28.27 $10.28 $17.992 $46.64 $5.00 $41.64 $13.99 $27.65

23-Nov 2 $21.02 $5.00 $16.02 $6.31 $9.71

2 $19.48 $5.00 $14.48 $5.84 $8.644 $54.00 $5.00 $49.00 $16.20 $32.802 $19.48 $5.00 $14.48 $5.84 $8.64

2 $21.02 $5.00 $16.02 $6.31 $9.713 $56.84 $5.00 $51.84 $17.05 $34.792 $27.98 $5.00 $22.98 $8.39 $14.59

24-Nov 4 $48.50 $5.00 $43.50 $14.55 $28.9525-Nov 6 $72.58 $5.00 $67.58 $21.77 $45.81

26-Nov 2 $32.46 $5.00 $27.46 $9.74 $17.7227-Nov 2 $32.76 $5.00 $27.76 $9.83 $17.93

2 $41.97 $5.00 $36.97 $12.59 $24.382 $24.56 $5.00 $19.56 $7.37 $12.19

28-Nov 2 $15.48 $5.00 $10.48 $4.64 $5.84

29-Nov 3 $39.04 $5.00 $34.04 $11.71 $22.33

2 $27.05 $5.00 $22.05 $8.12 $13.94

30-Nov 3 $17.48 $2.75 $14.73 $5.24 $9.49

2 $19.98 $5.00 $14.98 $5.99 $8.99

2 $30.56 $6.99 $23.57 $9.17 $14.40

2 $23.98 $5.00 $18.98 $7.19 $11.79

2 $23.56 $5.00 $18.56 $7.07 $11.49

2 $29.93 $7.49 $22.44 $8.98 $13.46

2 $29.48 $5.00 $24.48 $8.84 $15.644 $104.33 $11.50 $92.83 $31.30 $61.53

8/14/2019 Promo Tracking MSG Nov07

19/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION:Holiday VIP

$5 offDate of Mailing: 14-Nov-07Expiration Date: 30-Nov-07

Number of pieces mailed 500

Number of pieces returned 42Response Return % 8.40%

Avg # Customers/ piece returned 2.60

Avg Purchase per coupon $38.13After Discount $32.83

Total Revenues $1,601.41

Cost of Prizes/ProductsOther related expenses

Mailing list cost per piece costPostage $205.00 $0.41Paper & Printing $50.00 $0.10

Cost of Promotion $255.00

Cost of Goods $480.42 30.00%

Discount $ $222.73 13.91%Cost of Food & Discount $703.15 43.91%- Total Expenses $958.15

Net Profit/loss $643.26 40.17%

Avg Profit/ piece returned $21.39

Avg Profit/ piece mailed $1.29Avg Cost/ piece mailed $0.51Return on Investment 252.26%

Tips generated @ 15% $240.21If tip after discount $206.80

Summary

Holiday VIP

$5 offCost of Promotion $255.00

Total Pieces sent 500Total Pieces Returned 42

% Returned 8.40%

Average # customers 2.60Total # of customers 109Average Purchase $38.13Average Profit per redeemed $21.39

Total Revenue $1,601.41Total Discounts $222.73

Net Profit $643.26ROI 252.26%

Notes:These were $5 off coupons sentto top 500 guests withThanksgiving thank you card.We also included a card with anoffer to receive $10 bonuscoupon with every purchase of$50 in gift certificates.

8/14/2019 Promo Tracking MSG Nov07

20/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION: sweet tooth

1/2 off pumpkin bread pudding

30.0%Date # cstmr Ttl Sales $ Discnt After Disc Prod Cost Net Profit

Total 4 $54.75 $5.98 $48.77 $16.43 $32.3515-Nov 2 $20.99 $2.99 $18.00 $6.30 $11.7020-Nov 2 $33.76 $2.99 $30.77 $10.13 $20.64

8/14/2019 Promo Tracking MSG Nov07

21/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION:sweet tooth

1/2 off pumpkin bread puddingDate of Mailing: 8-Nov-07Expiration Date: 30-Nov-07

Number of pieces mailed 520

Number of pieces returned 2Response Return % 0.38%

Avg # Customers/ piece returned 2.00

Avg Purchase per coupon $27.38After Discount $24.39

Total Revenues $54.75

Cost of Prizes/ProductsOther related expenses

Mailing list cost per piece costPostage $109.20 $0.21Paper & Printing $52.00 $0.10

Cost of Promotion $161.20

Cost of Goods $16.43 30.00%

Discount $ $5.98 10.92%Cost of Food & Discount $22.41 40.92%- Total Expenses $183.61

Net Profit/loss $(128.86) -235.35%

Avg Profit/ piece returned 16.17

Avg Profit/ piece mailed $(0.25)Avg Cost/ piece mailed $0.31Return on Investment -79.93%

Tips generated @ 15% $8.21If tip after discount $7.32

Summary

sweet tooth

1/2 off pumpkin bread puddingCost of Promotion $161.20

Total Pieces sent 520Total Pieces Returned 2

% Returned 0.38%

Average # customers 2.00

Total # of customers 4Average Purchase $27.38

Average Profit per redeemed $16.17

Total Revenue $54.75Total Discounts $5.98

Net Profit $(128.86)ROI -79.93%

Notes:

This was an offer in ournewsletter. The cost of mailingwas split between two

restaurants.This month we mailed with firstclass stamps because of lateprinting and only to top 500members.

8/14/2019 Promo Tracking MSG Nov07

22/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION: TG email

free app/dessert

30.0%Date # cstmr Ttl Sales $ Discnt After Disc Prod Cost Net Profit

Total 31 $374.15 $65.16 $308.99 $112.25 $196.75

23-Nov 5 $69.11 $6.79 $62.32 $20.73 $41.59

25-Nov 9 $71.11 $7.99 $63.12 $21.33 $41.79

2 $36.97 $6.99 $29.98 $11.09 $18.89

2 $28.96 $7.95 $21.01 $8.69 $12.32

27-Nov 2 $25.97 $6.99 $18.98 $7.79 $11.19

30-Nov 2 $43.51 $5.99 $37.52 $13.05 $24.47

3 $42.54 $5.99 $36.55 $12.76 $23.79

4 $27.97 $9.48 $18.49 $8.39 $10.10

2 $28.01 $6.99 $21.02 $8.40 $12.62

8/14/2019 Promo Tracking MSG Nov07

23/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION:TG email

free app/dessertDate of Mail ing: 21-Nov-07Expiration Date: 30-Nov-07

Number of pieces mailed 1022

Number of pieces returned 9

Response Return % 0.88%

Avg # Customers/ piece returned 3.44

Avg Purchase per coupon $41.57

After Discount $34.33

Total Revenues $374.15

Cost of Prizes/Products

Other related expenses

Mailing list cost $25.00 per piece cost

Postage $-

Paper & Printing $-

Cost of Promotion $25.00

Cost of Goods $112.25 30.00%

Discount $ $65.16 17.42%

Cost of Food & Discount $177.41 47.42%

- Total Expenses $202.41

Net Profit/loss $171.75 45.90%

Avg Profit/ piece returned $21.86

Avg Profit/ piece mailed $0.17

Avg Cost/ piece mailed $0.02

Return on Investment 686.98%

Tips generated @ 15% $56.12

If tip after discount $46.35

Summary

TG emailfree app/dessert

Cost of Promotion $25.00Total Pieces sent 1022Total Pieces Returned 9% Returned 0.88%

Average # customers 3.44Total # of customers 31Average Purchase $41.57Average Profit per redeemed $21.86Total Revenue $374.15

Total Discounts $65.16

Net Profit $171.75ROI 686.98%

Notes:

This was an appreciationemail sent out the daybefore Thanksgiving with afree appetizer/dessertcoupon attached.

8/14/2019 Promo Tracking MSG Nov07

24/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION: cmmty supt

30.0%Date # cstmr Ttl Sales $ Discnt After Disc Prod Cost Net Profit

Total 8 $81.40 $28.58 $52.82 $24.42 $28.403-Oct 2 $32.86 $10.00 $22.86 $9.86 $13.00

14-Nov 4 $29.56 $8.58 $20.98 $8.87 $12.11

30-Nov 2 $18.98 $10.00 $8.98 $5.69 $3.29

8/14/2019 Promo Tracking MSG Nov07

25/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION:cmmty supt

0Date of Mailing: ongoingExpiration Date:

Number of pieces mailed 100Number of pieces returned 3

Response Return % 3.00%

Avg # Customers/ piece returned 2.67

Avg Purchase per coupon $27.13After Discount $17.61

Total Revenues $81.40

Cost of Prizes/ProductsOther related expenses

Mailing list cost per piece costPostage $-Paper & Printing $5.00 $0.05

Cost of Promotion $5.00

Cost of Goods $24.42 30.00%Discount $ $28.58 35.11%

Cost of Food & Discount $53.00 65.11%- Total Expenses $58.00

Net Profit/loss $23.40 28.75%

Avg Profit/ piece returned $9.47

Avg Profit/ piece mailed $0.23Avg Cost/ piece mailed $0.05Return on Investment 468.00%

Tips generated @ 15% $12.21If tip after discount $7.92

Summary

cmmty supt$-

Cost of Promotion $5.00

Total Pieces sent 100Total Pieces Returned 3

% Returned 3.00%

Average # customers 2.67

Total # of customers 8Average Purchase $27.13

Average Profit per redeemed $9.47

Total Revenue $81.40Total Discounts $28.58

Net Profit $23.40

ROI 468.00%

Notes:

8/14/2019 Promo Tracking MSG Nov07

26/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION: Diner return

$10 off-salmon

30.0%Date # cstmr Ttl Sales $ Discnt After Disc Prod Cost Net Profit

Total 0 $- $- $- $- $-

8/14/2019 Promo Tracking MSG Nov07

27/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION:Diner return

$10 off-salmonDate of Mailing: 11-Jul-07Expiration Date: 10-Aug-07

Number of pieces mailedNumber of pieces returned 0

Response Return %

Avg # Customers/ piece returned #DIV/0!

Avg Purchase per coupon #DIV/0!After Discount #DIV/0!

Total Revenues $-

Cost of Prizes/ProductsOther related expenses

Mailing list cost per piece costPostage $- $0.39Paper & Printing $- $0.15

Cost of Promotion $-

Cost of Goods $- 30.00%Discount $ $- #DIV/0!

Cost of Food & Discount $- #DIV/0!- Total Expenses $-

Net Profit/loss $- #DIV/0!

Avg Profit/ piece returned #DIV/0!

Avg Profit/ piece mailed #DIV/0!Avg Cost/ piece mailed #DIV/0!Return on Investment #DIV/0!

Tips generated @ 15% $-If tip after discount $-

Summary

Diner return$10 off-salmon

Cost of Promotion $-

Total Pieces sent 0Total Pieces Returned 0

% Returned

Average # customers #DIV/0!

Total # of customers 0Average Purchase #DIV/0!

Average Profit per redeemed #DIV/0!

Total Revenue $-Total Discounts $-

Net Profit $-

ROI #DIV/0!

Notes:

8/14/2019 Promo Tracking MSG Nov07

28/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION: open

30.0%Date # cstmr Ttl Sales $ Discnt After Disc Prod Cost Net ProfitTotal 0 $- $- $- $- $-

8/14/2019 Promo Tracking MSG Nov07

29/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION:

open November-070

Date of Mailing: 19-Oct-07Expiration Date: 31-Oct-07

Number of pieces mailed 100Number of pieces returned 0Response Return % 0.00%

Avg # Customers/ piece returned #DIV/0!Avg Purchase per coupon #DIV/0!

After Discount #DIV/0!

Total Revenues $-

Cost of Prizes/ProductsOther related expensesMailing list cost per piece cost

Postage $-Paper & Printing $-Cost of Promotion $-

Cost of Goods $- 30.00%Discount $ $- #DIV/0!

Cost of Food & Discount $- #DIV/0!- Total Expenses $-

Net Profit/loss $- #DIV/0!

Avg Profit/ piece returned #DIV/0!Avg Profit/ piece mailed $-

Avg Cost/ piece mailed $-Return on Investment #DIV/0!

Tips generated @ 15% $-If tip after discount $-

Summary

open$-

Cost of Promotion $-

Total Pieces sent 100Total Pieces Returned 0

% Returned 0.00%

Average # customers #DIV/0!Total # of customers 0Average Purchase #DIV/0!

Average Profit per redeemed #DIV/0!Total Revenue $-

Total Discounts $- #DIV/0!Net Profit $- #DIV/0!

ROI #DIV/0!

Notes:

8/14/2019 Promo Tracking MSG Nov07

30/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION: Door Hangers

30.0%Date # cstmr Ttl Sales $ Discnt After Disc Prod Cost Net Profit

Total 0 $- $- $- $- $-

8/14/2019 Promo Tracking MSG Nov07

31/35

8/14/2019 Promo Tracking MSG Nov07

32/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION: mgr card

30.0%Date # cstmr Ttl Sales $ Discnt After Disc Prod Cost Net Profit

Total 0 $- $- $- $- $-

8/14/2019 Promo Tracking MSG Nov07

33/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION:mgr card

0Date of Mailing:Expiration Date:

Number of pieces mailedNumber of pieces returned 0

Response Return %

Avg # Customers/ piece returned #DIV/0!

Avg Purchase per coupon #DIV/0!After Discount #DIV/0!

Total Revenues $-

Cost of Prizes/ProductsOther related expenses

Mailing list cost per piece costPostage $- $-Paper & Printing $- $0.06

Cost of Promotion $-

Cost of Goods $- 30.00%Discount $ $- #DIV/0!

Cost of Food & Discount $- #DIV/0!- Total Expenses $-

Net Profit/loss $- #DIV/0!

Avg Profit/ piece returned #DIV/0!

Avg Profit/ piece mailed #DIV/0!Avg Cost/ piece mailed #DIV/0!Return on Investment #DIV/0!

Tips generated @ 15% $-If tip after discount $-

Summary

mgr card$-

Cost of Promotion $-

Total Pieces sent 0Total Pieces Returned 0

% Returned

Average # customers #DIV/0!

Total # of customers 0Average Purchase #DIV/0!

Average Profit per redeemed #DIV/0!

Total Revenue $-Total Discounts $-

Net Profit $-

ROI #DIV/0!

Notes:

8/14/2019 Promo Tracking MSG Nov07

34/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION: survey

30.0%Date # cstmr Ttl Sales $ Discnt After Disc Prod Cost Net Profit

Total 0 $- $- $- $- $-

8/14/2019 Promo Tracking MSG Nov07

35/35

CUSTOMER BASED MARKETING ANALYSISPROMOTION:survey

0Date of Mailing:Expiration Date:

Number of pieces mailedNumber of pieces returned 0

Response Return %

Avg # Customers/ piece returned #DIV/0!

Avg Purchase per coupon #DIV/0!After Discount #DIV/0!

Total Revenues $-

Cost of Prizes/ProductsOther related expenses

Mailing list cost per piece costPostage $-Paper & Printing $-

Cost of Promotion $-

Cost of Goods $- 30.00%Discount $ $- #DIV/0!

Cost of Food & Discount $- #DIV/0!- Total Expenses $-

Net Profit/loss $- #DIV/0!

Avg Profit/ piece returned #DIV/0!

Avg Profit/ piece mailed #DIV/0!Avg Cost/ piece mailed #DIV/0!Return on Investment #DIV/0!

Tips generated @ 15% $-If tip after discount $-

Summary

survey$-

Cost of Promotion $-

Total Pieces sent 0Total Pieces Returned 0

% Returned

Average # customers #DIV/0!

Total # of customers 0Average Purchase #DIV/0!

Average Profit per redeemed #DIV/0!

Total Revenue $-Total Discounts $-

Net Profit $-

ROI #DIV/0!

Notes: