search

fivetran / dbt_ad_reporting

Fivetran's ad reporting dbt package. Combine your Facebook, Google, Pinterest, LinkedIn, Twitter, Snapchat, Microsoft, TikTok, Reddit, Amazon, and Apple Search advertising metrics using this package.
https://fivetran.github.io/dbt_ad_reporting/#!/overview
Apache License 2.0
146 stars 55 forks source link

FEATURE - Get video views data from the ads #50

Open teja-goud-kandula opened 2 years ago

teja-goud-kandula commented 2 years ago

Is there an existing feature request for this?

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?

Anything else?

No response

fivetran-joemarkiewicz commented 2 years ago

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 commented 2 years ago

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.