Limiting Google Ad Manager Data Import

Hi, 

I have connnected Google Ad Manager to Looker Studio to create a report. There is a lot of data linked to my GAM account and as a result when expanding my date range the report takes a long time to load. Is there a way to limit the amount of data that Looker studio imports to improve the efficiency of the report? For example limiting the data to only that from 2023 onwards or data only relatng to certain markets? 

Thanks, Harry

1 REPLY 1

it also be good for Google Analytics data, as once connected you don't have a good control over the data.

In house we solved this by having BigQuery tables and connecting data with SQL queries where you can say lets say last 90 days etc...

 

Kind regards,
Krassi