Extract Facebook Campaigns data for Data visualization
I’m trying to get a daily extract of several metrics for all active Ads on my Meta Business Manager to push in Power BI.
I’ve been using the Facebook Ads Campaign Management module to list all Ads ID and then use the Facebook Insights module to get all the data based on the mapping of the Ad ID from the first module.
The problem I have is that I can’t find a way to get all Ads ID of my account using the Facebook Ads Campaign Management module. I can only choose one Ad Account → one campaign → one Adset to get the Ads ID of.
Not sure if it’s a limitation from the Facebook API or if I’m doing something wrong here.