fivetran / fivetran/dbt_ad_reporting

FEATURE - Get video views data from the ads

Open
#50 2 comments 0 reactions 0 assignees View on GitHub
enhancement
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.