Add per month pre-aggregate report tables to the dbt package for Facebook Ads
In order to be able to support the default Dashboards for Facebook Ads data at a granularity level suited for most users, we want to add per month pre-aggregate report tables that we can use in Meltano Analyze to generate reports over Facebook Ads data.
We should add the following transform models:
- Clicks per month
- Impressions per month
- Results per month
- Costs per month
- Funnel Performance per month
- Funnel Costs per month
- App Engagement per month