Build a dashboard in Google Data Studio

Business Benefits

Create customized and engaging reports.

Go to Style > Column > Bar/Pub, and tick Show number to build a funnel in a table using the bar feature.

You can use this feature to construct a visualization of any process that can be represented by steps. You could, for example, visualize step-by-step progress for form completion.

For example, in the image below, page views and events are categorized based on which stage of the funnel they target, and source data on the right shows the channels and pages that win the most users in each part of the sequence.

Define the dimension and set the conditions - you can create a dimension based on auto-exclusive groups of data.

For example, you could visualize visits from paid and non-paid traffic. For this example, your conditions are the paid channels in Google Analytics: Display, Paid Search, Affiliates, and Paid Social (custom). Non-paid channels are the rest.

Build a calculated metric for multiple objectives in a single funnel using math operators in the calculated metric feature in Google Analytics.

For example, for a site focused on obtaining leads, the main goal is achieved when a potential customer makes contact by email, a form fill, or a phone call.

To calculate a collective goal of leads, add them using the + operator.

Use the function CASE and regular expressions to consolidate source data for Facebook, Twitter, or Google.

  WHEN REGEXP_MATCH(Source, '.*facebook.*') THEN ''
  WHEN REGEXP_MATCH(Source, '.*instagram.*') THEN ''

Mix and match data from different sources in a single visualization.

You can highlight data from:

  • Google Analytics
  • Google Search Console
  • Facebook
  • Instagram
  • YouTube
  • Google Ads
  • Google Sheets
  • CRM
  • ecommerce platform data.

For one-off reports or incompatible sources, import the data into a Google Sheet and make that sheet the source.

Last edited by @hesh_fekry 2023-11-14T11:50:20Z