Arrow pointing backBACK TO FUNNEL TIPS

How to make Google Data Studio faster with views

Last updated: 17/01/2022

Learn about:

  • 3 ways to make Google Data Studio faster
  • Why Funnel makes the Google Data Studio experience much better

If you're like me, then you use Data Studio to create reports and dashboards for your clients (or for yourself!). But sometimes, it can be a little slow, especially if you have a lot of data in your account. In this post, I will show you 3 ways to make Data Studio run faster and smoother.

 

1. Reduce the scope of the dashboard

It’s great to have one central Data Studio dashboard for everything, but consider how often you use every widget, or if you’re creating a lot of noise. Those widgets should be in another dashboard if you use them on an ad-hoc basis. 

 

One option is to consider breaking the dashboard into daily, weekly, and monthly KPIs - so one dashboard doesn’t become too much of a beast!

 

2. Use Data Studio’s extract connector

Data studio has a special connector that works slightly differently. Instead of requesting all of your data each time, Google’s extract data source requests only some of your data. 

 

It saves and stores data in an in-between step, making the request quicker as the amount of data is set. However, there are some limitations with this data processing and data freshness.

 

  • You are limited to 100MB of data, which might not be enough for granular, informative reports.
  • Data is not refreshed in real-time - but daily, weekly, or monthly. So, you cannot maintain real-time automated reports in the same way.

 

3. Create views in Funnel

Data Studio Views is Funnel’s clever way of sending data to Data Studio. You can, of course, send all of your metrics and dimensions over to Data Studio. But we recommend using views where you can choose a selection of metrics and dimensions to send over to Data Studio to make your data easier to work with and, of course, faster!

 

Funnel’s Data Studio Views offer you the ability to get the freshest data possible, without any limits on how much data can be in each call. You can get it sent in whenever you’d like, and have it refreshed multiple times a day for the freshest data possible.

 

Why Data Studio + Funnel?

Data Studio is a powerful tool that helps marketers visualize data in an easy-to-read format. However, when working with large datasets, the dashboard can take longer to load and become less responsive.

In this post, we discussed three ways to make Data Studio faster. Have you tried any of these tips? What other methods have worked well for speeding up a slow report? Let us know! We love hearing from our readers about what works best for them. 

 


New Funnel tips every other Wednesday!

Educate yourself on all things marketing data with one short video twice a month. We promise it's not another newsletter!