fivetran / dbt_facebook_ads

Fivetran data models for Facebook Ads built using dbt.
https://fivetran.github.io/dbt_facebook_ads/
Apache License 2.0
24 stars 27 forks source link

FEATURE - orders and revenue added to tables #8

Closed cbeem1 closed 3 years ago

cbeem1 commented 3 years ago

Are you a Fivetran customer? Connor Beem, Sr. Growth Data Analyst, Cameo

Is your feature request related to a problem? Please describe. No problem, just would like orders and revenue in these tables as well!

Describe the solution you'd like adding in orders and revenue from facebook basic_ad_actions

Describe alternatives you've considered adding these in manually from this table

Additional context

Please indicate the level of urgency and business impact of this request definitely needed for reporting!

Are you interested in contributing to this package?

fivetran-joemarkiewicz commented 3 years ago

Hi @cbeem1 👋

Thanks for opening this issue! It looks like to integrate the orders and revenue from basic_ad_actions would require bringing in the table at the source package and scoping out how to include these fields into our final models. I can add this Feature Request to our next sprint to be scoped out and assigned accordingly. I will be sure to have a member of our team respond back here once it has been assigned to continue communication.

It would be extremely helpful if you by chance have already included these metrics to the final models manually. If you have, would you be able to share the query here as it will help us in updating the package.

Thanks again! 🎉

fivetran-joemarkiewicz commented 3 years ago

@cbeem1 is this still a request you would like to have added to the facebook package?

fivetran-joemarkiewicz commented 3 years ago

After chatting with @cbeem1 this request is no longer needed. Closing the ticket, but open to readdressing if other customers have this request in the future.