Adobe Employee

Using Conditional Formatting as a Heat Map to Identify & Monitor Values

Forum|Forum|2 years ago
May 15, 2023
5 replies
1586 views

Using the Day of Week dimension (OOTB) and Hour of Day dimension (OOTB), you can create a custom heat map to understand what times and days of the week generate the most significant amount of engagement or drive the highest number of conversions. While using the Day of Week (OOTB) and Hour of Day (OOTB) dimensions produces an insightful and granular seasonality analysis, this heat map is not limited to these dimensions. For instance, swapping out the Hour of Day dimension for the AM/PM (OOTB) dimension will produce a high-level, meaningful analysis.

When applying the conditional formatting setting, you can use auto-generated to automatically calculate the upper limit, midpoint, and lower limit based on the data, or you can define your own custom limits.

After selecting and applying the type of conditional formatting for your analysis, your reports will appear similar to the examples shown below:

Heat map to trend engagement

Heat map to trend conversions

Taking it one step further, you can use the AM/PM dimension broken down by campaign name variable to understand what campaigns are driving conversions based on the day of week and time of day:

Analytics

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Jennifer_Dungan

Community Advisor and Adobe Champion

In addition to this, to create a truly "visual" heat map, you can hide Numbers, Percent and Totals from these views and just have the colours showing your "hot" and "cold" days/times.

It means that the heat map stands on its own without showing all the text.

You can do either way, but it's nice to remember that there are some additional ways to simplify the display

kayawalton

Community Advisor and Adobe Champion

I love this feature. We use it a lot to do time-parting heatmaps to show when our audience visits our platforms and consume different media types.

cparthasarathy

@jennifer_dungan @jenmarti

It is a very useful feature. Is there an option where can use custom colors - for timeparting heatmaps

red- high page views to gradient green to low page views .

Is that something we can do by adjusting the values

Jennifer_Dungan

Community Advisor and Adobe Champion

cparthasarathy if you want to reverse the red and green, I think the best option would be to create a custom calculated metric and select "Show upward trend as Bad (red)" - this will trick the conditional formatting to reverse itself.

So let's say you are using "Page Views" metric, make the following calculated metric: