Google Data Studio has 3 different types of tables, one of which is called tables with heat maps. These tables are like the others except that they add the ability to add color pallets to metrics. This makes it really easy to look at lots of data as the cell colors change based on the cell value. Typically, the higher the value, the darker the cell.
Here’s a sample of what a heat map table looks like:
How to Add a Heatmap Table
Step 1: Add the Table and Size It
To begin, use the top menu to add the heat map table to your Google Data Studio report.
Step 2: Select Your Dimensions and Metrics
Here, you can decide which dimensions and metrics you want to report on. For each metric you choose, GDS will automatically apply a color pallet for you.
Step 3: Adjust Styles and Colors as Needed to Get the Look You Need
Finally, you’ll use the Style menu to adjust the color pallets, font sizes, etc. as you typically would with any Google Data Studio table.
- Table colors: Adjust the color of the table heading background, row styles, etc.
- Fonts: Adjust the table fonts as needed
- Heat Map Colors: Adjust the color scheme of each metric group with its own color pallet to make for easy viewing of data
Tips for Adding Tables with Heat Maps
- Drill Down: Heatmap tables allow for dimension drill downs just as do other charts in Google Data Studio
- Optional Metrics: Just like other charts in GDS, optional metrics can be added which allow the end user to change the metrics simply by using a selector on the front end
We hope this helps you get started in using Google Data Studio tables with heat maps. Questions and comments below!
Rick Maggio brings over 15 years of tactical, hands-on experience managing digital advertising campaigns both small and large. Rick has worked in agency-land and on large in-house marketing teams and loves sharing his extensive experience with the LDA community.