How to Make Each Funnel in a Small Multiple Funnel Visualization One Color

A brand funnel is a great visualization that shows the performance of brands on a series of "health" metrics, such as awareness, consideration, and trial, and allows researchers to identify at which stage in the funnel users are dropping out i.e. how well is my brand doing in converting users who are aware of my brand to purchasing it?

 

When creating a brand funnel visualization, you might find yourself asking how can assign a different color to each funnel, so that my brand is in one color and my competitor brands are in different colors?

See the example below:

 

 

This article briefly recaps how to create a Small Multiples Funnel visualization in Displayr, but more specifically focuses on how to assign different colors to each funnel.

 

Requirements

You will need a Brand Health Table to use as the base. Create one by following the steps in this article How to Create a Brand Health Table

 

Step 1: Create a Small Multiples Funnel Visualization

After you create the Brand Health Table, you will need to add a Small Multiples Funnel Visualization and hook it up to the Brand Health Table. Here is how you would do this:

 

1. In the toolbar, go to Visualization > Bar > Small Multiples Funnel. Click and drag on the page to add the funnel visualization.

 

 

2. Select the visualization and connect the brand health table you created previously to the visualization. Go to the object inspector on the right and select the table in DATA SOURCE > Data.

 

 

Step 2: Format the colors of each funnel

The idea here is that you will create a separate table with the same dimensions as your Brand Health Table. In the example above, we have a Brand Health Table with four rows and four columns. Therefore the new table should honor the same dimensions. This table will be the input to assign the different colors to each funnel. Here is how you would do this:

 

1. In the toolbar, go to Table > Paste or Enter Table and then select Paste or type data in the object inspector on the right.

 

2. In the Enter or Paste Data window that pops up, add the row and column headers in the same order they appear in your Brand Health Table. The order is important, as this is what Displayr will use as a reference to correctly assign the colors.

3. Now, assign a number to each column in your table. Each column should use a unique number and all the rows in the same column should have the same number. See the example below. Once you are done click OK. 

4. Select the new table and go to General > GENERAL > Name and give it a descriptive name i.e. Color.Input.Table. 

5. Select your  Small Multiples Funnel Visualization and go to Chart > DATA SERIES > Color Palette > Custom Palette. In the Custom Palette field that appears, add the hex codes of the colors you would like to assign to each category. Ensure the hex colors you want to assign to each category are in the same order they appear in your Brand Health Table.

 

 

5. In DATA SERIES > Values menu just below the Custom Palette menu, select the Pasted Table you created earlier. This will now assign each funnel its color based on the hex colors you used.

 

Now you have a Small Multiples Funnel Visualization, with specific colors assigned to each funnel. 

Next

How to Create a Brand Health Table

Tracking Study Best Practices