Looking for leads data at ad_id level and for each breakdown. Currently in Facebook Ad dashboard, we are able to see the metrics at ad_id level and for each breakdown. We want to pull the same level of data from Fivetran as well. We have configured a custom report as below.

• action_type from the Action Breakdowns selection
• actions, ad_id from the Fields selection.

A table got created with name "<report_name>_actions". This will contain a column "action_type", "ad_id" and "date". By filtering it with "action_type=lead" gives our lead value.
Now, we want to get leads value for breakdown. For this we have selected "age" in breakdown field. But we cannot see the age column in the newly created secondary table.

 
Currently, Fivetran is not supporting to show breakdown data in the secondary tables.