Error: Exceeded max query execution time while fetching FB insights data
I would like to export Facebook Insights Data for around 100 fb-pages for the last 2 years on post-level.
Knowing that this is a huge amount of data I tried to run one query for each page, but still got many problems, for example the error posted as title.
Also i tried using one query for each month, but still got the error or nothing happend at all. Even with using a trigger, nothing happend and I didn't get any results.
Is there any solution to get alle the data with an appropiate amount of effort?