fivetran / fivetran/dbt_ad_reporting
FEATURE - Get video views data from the ads
- Dominant language
- No language data
- Stars
- 223
- Forks
- 79
- PR merge metrics
- No merged PRs in 30d
Description
### Is there an existing feature request for this?
- [X] I have searched the existing issues
### Describe the Feature
There are 3 ad sources for now, they are:
1. Google ads
2. Facebook ads
3. LinkedIn ads
I am trying a build a query for reporting purposes that shows:
1. Video impressions
2. Video views
break down by:
1. date
2. UTM Source
3. UTM Medium
4. UTM Campaign
5. Ad Group Name
6. Campaign Name
As an analogy, it is similar to what the ad reporting model achieves for image campaigns but the data is needed for video kind of campaigns.
Please help me with a query that can achieve the same on a priority basis.
If this seems to be a good addition to the reporting from a generalized perspective, then you can then think of adding to the future releases of this package.
### Describe alternatives you've considered
I am struggling to come with a query first.
1. I couldn't think of any alternative at the moment
2. Even after looking at the Fivetran ERD diagram for these 3 ads, I am unable to come up with a query to serve the purpose that I am trying to achieve
### Are you interested in contributing this feature?
- [X] Yes.
- [ ] Yes, but I will need assistance and will schedule time during your [office hours](https://calendly.com/fivetran-solutions-team/fivetran-solutions-team-office-hours) for guidance.
- [ ] No.
### Anything else?
_No response_
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.