[Feature] add conversion data to the hubspot__source table properties

[moreaupascal56]

Is there an existing feature request for this?

• I have searched the existing issues

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):

• First conversion date
• First conversion
• etc

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?

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

Anything else?

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

[fivetran-joemarkiewicz]

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]

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]

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.