10 Best Practices for a Custom B2BMA Dashboard
Posted: Sun Dec 22, 2024 6:09 am
If you’ve been using the pre-built dashboards in the Tableau CRM Analytics Studio B2BMA app, and feel you aren’t getting insights into your data that you desire, it may be time to build your own custom B2BMA dashboards.
When it comes to creating a dashboard we have two options, we can either use one of the pre-built templates provided in the B2BMA app or create a dashboard on a blank canvas. I always recommend creating a dashboard on a blank canvas, as the templates can limit what your data is based on.
Analytics dashboard list phone number in cambodia screenshot
However, before diving in and creating your dashboard, I recommend being familiar with our best practice tips first.
Pardot Training Banner
Top 10 Best Practices
1. Map and plan first!
I always recommend taking the time to plan out what data you want to see, how you’d like the dashboard to look and the design, prior to creating. By knowing what data you want to be visible in the report, you can see if this data exists in Pardot and Salesforce. For example, if you want to know which campaign has led to the highest conversions, it’s best to check your assets have been associated with the correct campaigns in Pardot first!
Once you have the data organised, think about how this data is to be displayed. Are you going to be using bar graphs? Or tables? Is this data going to be overwhelming for your users or will they be able to easily navigate through the dashboard?
2. Choose the correct chart types
Following on from tip one, when designing your dashboard it’s important to base it on the characteristics of the data, not solely the look. When you create a new query, use the Suggested Charts’ for hints. Whilst a doughnut chart might be more visually appealing, have you got 500 different values? This will make it harder for the viewer to drill into the chart for more valuable data.
3. Use the Dashboard Inspector
This feature is available on custom dashboards and checks the performance of the dashboard. It allows us to look into each step and get a better understanding of what is happening, which is key if you are noticing errors across lenses or queries.
Additionally, it will give you suggestions on how to improve the dashboards if it’s been noticed that your dashboard is running slow by using the Run Performance Check’.
dashboard inspector screenshot
4. Use Global Filters for interactivity
If there is a global filter on the dashboard such as Created at Date’ the dataset is filtered first prior to it running. This prevents the time it takes for the data to display as the query is run against a smaller dataset. This is key if your dashboard displays all data such as Prospect Full name’.
Global filters dashboard screenshot
5. Group filters together
It’s easier for users if filters are grouped together and are at the top of the dashboard so that they are noticeable! I recommend using the container widget to help to section the filters away from the rest of the dashboard.
6. Use Containers
Following on from step four, it is useful to use the container widgets to frame and organise related elements in the dashboard.
7. Set the Dashboard properties
The Dashboard properties include setting the default widget properties, background colour and border width. If you know you want a specific background colour, text size or number size across your queries this will make creation much quicker!
8. Apply titles and labels to sections and charts
Use titles and subtitles to provide a short explanation of what a specific query represents and how it should be used. Think about your users. Whilst you may know the dashboard inside out and what the dataset shows, they may not.
When it comes to creating a dashboard we have two options, we can either use one of the pre-built templates provided in the B2BMA app or create a dashboard on a blank canvas. I always recommend creating a dashboard on a blank canvas, as the templates can limit what your data is based on.
Analytics dashboard list phone number in cambodia screenshot
However, before diving in and creating your dashboard, I recommend being familiar with our best practice tips first.
Pardot Training Banner
Top 10 Best Practices
1. Map and plan first!
I always recommend taking the time to plan out what data you want to see, how you’d like the dashboard to look and the design, prior to creating. By knowing what data you want to be visible in the report, you can see if this data exists in Pardot and Salesforce. For example, if you want to know which campaign has led to the highest conversions, it’s best to check your assets have been associated with the correct campaigns in Pardot first!
Once you have the data organised, think about how this data is to be displayed. Are you going to be using bar graphs? Or tables? Is this data going to be overwhelming for your users or will they be able to easily navigate through the dashboard?
2. Choose the correct chart types
Following on from tip one, when designing your dashboard it’s important to base it on the characteristics of the data, not solely the look. When you create a new query, use the Suggested Charts’ for hints. Whilst a doughnut chart might be more visually appealing, have you got 500 different values? This will make it harder for the viewer to drill into the chart for more valuable data.
3. Use the Dashboard Inspector
This feature is available on custom dashboards and checks the performance of the dashboard. It allows us to look into each step and get a better understanding of what is happening, which is key if you are noticing errors across lenses or queries.
Additionally, it will give you suggestions on how to improve the dashboards if it’s been noticed that your dashboard is running slow by using the Run Performance Check’.
dashboard inspector screenshot
4. Use Global Filters for interactivity
If there is a global filter on the dashboard such as Created at Date’ the dataset is filtered first prior to it running. This prevents the time it takes for the data to display as the query is run against a smaller dataset. This is key if your dashboard displays all data such as Prospect Full name’.
Global filters dashboard screenshot
5. Group filters together
It’s easier for users if filters are grouped together and are at the top of the dashboard so that they are noticeable! I recommend using the container widget to help to section the filters away from the rest of the dashboard.
6. Use Containers
Following on from step four, it is useful to use the container widgets to frame and organise related elements in the dashboard.
7. Set the Dashboard properties
The Dashboard properties include setting the default widget properties, background colour and border width. If you know you want a specific background colour, text size or number size across your queries this will make creation much quicker!
8. Apply titles and labels to sections and charts
Use titles and subtitles to provide a short explanation of what a specific query represents and how it should be used. Think about your users. Whilst you may know the dashboard inside out and what the dataset shows, they may not.