I did find a way to do it after days of test and learn.
First, I had to divide the scenario in two, to avoid the limit of 45 minutes max run.
Scenario #1 is :
Facebook Insights module aimed at retrieving only the IDs of all the Campaigns, Ad Sets and Ads within my Business Manager (you could potentially add an additional clone module before that, to retrieve the IDs of the Ad Accounts if you have several).
For this one, make sur to check the ‘level’ of data you want hidden in the Advanced Settings. There you can choose if you want data for the Account, the Campaign, the Ad Set or the Ad in the end.
Tools / Sleep for 15 second to avoid too many request to Facebook API at the same time in scenario #2
HTTP / Make a request to send the data to the second scenario.
Scenario #2 is :
Webhook / Custom Webhook to retrieve info from scenario #1
Facebook Get ad info / Get insights In this one I use the Ad ID I got from Facebook Insights in scenario #1.
Final scenario is up to you depending on where you want the data to go. I chose Google Sheet so I can use it as a source in a Looker Studio dashboard.
I have an Enterprise account and my account manager at Make was a great help on this. If you do have a dedicated account on their side, I’d suggest to reach out to them as well. 