# Is there a way of speeding up Data Studio reports with large data volumes?

We use Supermetrics for a quarterly report on Data Studio, which has a data filter in it that allows brand managers to see the data for just their pages. The load times are very long, and it feel disproportional to usual speeds on SUpermetrics, and I wondered if there is a solution for that.

##### Post Metadata
- Posted at: over 4 years ago
- Author title: Digital Media Strategist
- Net upvotes: 1


## Comments
### Comment 1

Hi,

If you use Supermetrics for google sheet, you may change your data granularity working with pivot table and use this pivot table as data sources. The goal is to build a data architectur consistent with your graphics and dataviz and not oversized. That's the best way I found to reduce loading. 

Best,

##### Comment Metadata
- Posted at: over 4 years ago
- Author title: CRM Data Feed manager



### Comment 2

Hey Mathias,

There are a number of things that could contribute to Data Studio reports slowing down, especially at high volumes, such as long date ranges and complex calculated fields. We have a comprehensive best practices guide for Data Studio on our support center that helps you optimize loading speeds – you can find it here:

https://support.supermetrics.com/support/solutions/articles/19000126988-best-practices-for-data-studio

In addition, you can also use Google's free Extract Data connector jointly with Supermetrics to speed up reports. Here is a great blog that outlines the approach as well as how to set it up:

https://supermetrics.com/blog/google-data-studio-slow

Last but not least, you may want to consider using a data warehouse, as the source of data.

For example, Google BigQuery integrates very well with Data Studio You can use the same Supermetrics connectors to move data to BigQuery, and then visualize it in Data Studio. There are a number of benefits to this approach, one of them being faster load speeds. To learn more about this approach, check out the link below:

https://supermetrics.com/product/bigquery

I hope all of this helps!

##### Comment Metadata
- Posted at: over 4 years ago
- Author title: Head of Product Marketing




## Related Product
[Supermetrics](https://www.g2.com/products/supermetrics/reviews)

## Related Category
[Marketing Analytics](https://www.g2.com/categories/marketing-analytics)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: about 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: about 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: about 13 years ago
  - Comments: 4