fivetran / dbt_hubspot_source

Data models for Hubspot built using dbt.
https://fivetran.github.io/dbt_hubspot_source/
Apache License 2.0
31 stars 30 forks source link

[Feature] add conversion data to the hubspot__source table properties #71

Open moreaupascal56 opened 2 years ago

moreaupascal56 commented 2 years ago

Is there an existing feature request for this?

Describe the Feature

Hi there!

I find useful to have the Conversion Information of a contact in a the hubspot__contact table (from dbt_hubspot package), these are the informations mentioned here (section Conversion Information):

I did not find any of this data in the tables created by the hubspot transform package, so for now I'm using directly the table contact_form_submission imported by Fivetran. (with an aggregation data is good)

Maybe I did not search enough and this is already somewhere 🤔 Thx and Have a great day!

Describe alternatives you've considered

Continue using directly the table contact_form_submission

Are you interested in contributing this feature?

Anything else?

I just set up this dbt hubspot source package and it's really well explained, liked it ! :)

fivetran-joemarkiewicz commented 2 years ago

Hi @moreaupascal56 thanks so much for opening this feature request! I can see the addition of the conversion metrics as very beneficial to the end models.

I see you are interested in opening a PR. If so, I would be more than happy to help with any questions you may have 😄. Once you open a PR I will be happy to prioritize review. If you don't end up opening a PR, I can plan to scope this out for a future sprint.

moreaupascal56 commented 2 years ago

Hey, just some infos :) I may be able to work on this but I don't know when, I've done some specific workaround for my use case for now, but I still think it would be better here so I'd love to come back on this when some time will free up.

fivetran-joemarkiewicz commented 2 years ago

Hi @moreaupascal56 that sounds great! We will keep this feature open and feel free to come back when you have time available.

We really appreciate your continue contributions to this code base 😄. Let me know if you have any questions or need any support.