Perceptual map

Perceptual Map Worksheet

	Welcome to "Create Your Perceptual Map"
	Follow the Steps in Yellow. Only enter data/information in the Grey cells.					A how to use video is at:	YouTube link
	NOTE: This Excel template is password protected - it will work as is - just enter labels and data in the grey cells only - if (for some reason) you want to unprotect this spreadsheet - the password is map
		For more information on Perceptual Maps visit:	www.perceptualmaps.com		Or email: [email protected]			Copyright 2014-18
	Simply type over the grey cells below to quickly and easily create your own Perceptual Map
	Step 1	Enter the Title of Your Map		Fast Food Market
				(This is an example only. Simply type over this map title.)
	Step 2	Enter the two labels for your Horizontal Axis
		For the left side of the map		Junk Food		(These are examples only.
		For the right side of the map		Healthy		Type in your attributes.)
	Step 3	Enter the two labels for your Vertical Axis
		For the bottom of the map		Limited Choice		(These are examples only.
		For the top of the map		Wide Choice		Type in your attributes.)
	Please note that you can click on Attribute Ideas in the menu on the main website to help determine suitable brand/product attributes to use
		Or for more information on Perceptual Maps and/or the Market Segmentation, Targeting and Positioning (STP) process, please visit
				All About Perceptual Maps
	Step 4	Enter the Brands or Products to be Mapped	Step 5	Score each brand/product for the two attributes			Step 6	Change the circle sizes
		Up to a maximum of 25 brands/products		Use a 1-9 scale, using the following table as a rough guide.			Please note that this is an optional step
				Horizontal Attribute		Vertical Attribute		Sizes
		Do NOT Type Over ==>	1 =	Junk Food	1 =	Limited Choice	1 =	Small
			5 =	Equal mix of both	5 =	Equal mix of both	2 =	Medium
		(Some examples provided, simply type over the brands below.)	9 =	Healthy	9 =	Wide Choice	3 =	Large
	1	McDonalds		5.5		7		2
	2	Burger King		4		4.5		2
	3	Wendy's		7		3		2
	4	In & Out		5		1		2
	5							2
	6							2
	7							2
	8							2
	9							2
	10							2
	11							2
	12							2
	13							2
	14							2
	15							2
	16							2
	17							2
	18							2
	19							2
	20							2
	21							2
	22							2
	23							2
	24							2
	25							2
	Step 7	When finished entering your data above, simply copy your Perceptual Map below and paste it into your document.
							To maintain the formatting of the map
							when you copy it:
							1	Click on the edge of the map
								to highlight it
							2	Select 'copy' from the menu
							3	Go to your document
							4	Select 'paste', then 'paste special'
								and choose 'bitmap'.

Perceptual Map Worksheet

Your map will be produced below, after you enter your data Map starts after row 60