Joining HubSpot Tables (extracted via API)

Data đź’¬ RevOps Discussions
1

Hi,

We’re extracting data from our portal to visualize it in Tableau.

I’m having trouble joining tables together to segment email by the email campaigns they’re a part of.

I did an inner join of email_campaigns and marketing_emails on Content ID and ID.

In marketing_emails there’s a field “All Email Campaigns” with campaign IDs. I’d like to join that with workflows but I can’t seem to find a way to join on a field with a single value to one with many. Any thoughts?

2

Hi @geoffbcampbell1,

Thank you for the post. I am tagging in other users in the community that has noted experience with integrations in case they have any suggestions.

@thesnappingdog @Jmernst @Amy_Brierley @marymartin28 @cooperelias @Aaron-WC

3

Hi @geoffbcampbell1 ,

Which connector are you using to extract the data from Hubspot?