FEATURE - Get video views data from the ads

[teja-goud-kandula]

Is there an existing feature request for this?

• 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?

• Yes.
• Yes, but I will need assistance and will schedule time during your office hours for guidance.
• No.

Anything else?

No response

[fivetran-joemarkiewicz]

Hi @teja-goud-kandula thanks so much for opening this Feature Request!

From what you outlined above, I would agree that this would be a great addition to the package. At the moment, I am unsure exactly how to obtain these results. However, we are in the process of overhauling the reporting flexibility of this package! We will be sure to keep this in mind during our updates 😄

[fivetran-joemarkiewicz]

Hi @teja-goud-kandula I just wanted to post back that we recently completed our v1.0.0 release of the Ads package. Unfortunately, we were not able to find a seamless way to integrate these types of reports in the final version of the release.

I don't feel this is impossible and will therefore keep this feature request open as we may want to address this in the future.