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?

  • Hi Oliver,

    for us to understand the level of data that you are trying to get, and to give you a suggestion on how to do that, could you please send us a screenshot of your query details in the sidebar and approximate number of data that you should get (average number of posts per page for those 2 years). Thanks!

    Best regards,

    -Supermetrics Team

Login to post a comment