APIs & Integrations

BGerrmann
Participant

We find deal ID's back in Tableau which don't exist in HubSpot anymore

SOLVE

Hi all, we are working in an external data BI program (Tableau). HubSpot data is exported to Tableau through 1) Stitch and 2) BigQuery. The total number of deals in HubSpot is around 77000, where the total number of deals in Tableau is +85000. We have looked into the data and find deal IDs in Tableau which do not exist in HS anymore - we suspect that these could be either deleted.

The deleted deals: we found a property "isdeleted" with true/false as values. However, the results in Tableau are inconsistent: it when a deal is marked as deleted:true in Tableau, this is not necessarily deleted in HS and vice versa. this makes the data unreliable. Does anybody know what could be the issue and how this could be solved? Any suggestion or idea is more than welcome!

0 Upvotes
1 Accepted solution
BGerrmann
Solution
Participant

We find deal ID's back in Tableau which don't exist in HubSpot anymore

SOLVE

Solution for our situation: With our lead generation, we only keep track of a couple pipelines. We have the internal policy that we do not delete deals within these pipelines. In this way we don't create any duplicated deal data (we cannot filter out deleted deals in the tableau overview, there is no clear tag to do this). Not perfect, but for now the data is pretty reliable.

 

View solution in original post

0 Upvotes
6 Replies 6
BGerrmann
Solution
Participant

We find deal ID's back in Tableau which don't exist in HubSpot anymore

SOLVE

Solution for our situation: With our lead generation, we only keep track of a couple pipelines. We have the internal policy that we do not delete deals within these pipelines. In this way we don't create any duplicated deal data (we cannot filter out deleted deals in the tableau overview, there is no clear tag to do this). Not perfect, but for now the data is pretty reliable.

 
0 Upvotes
BGerrmann
Participant

We find deal ID's back in Tableau which don't exist in HubSpot anymore

SOLVE

In the end, we used the following systems:

HubSpot - BigQuery - Stitch - Tableau

 
0 Upvotes
fbehaviour
Member

We find deal ID's back in Tableau which don't exist in HubSpot anymore

SOLVE

Hey, I think even with these small issues, you are doing a great job. I like that developer like you keep improving their platform and include more compatible applications that would work with Tableau. I have been using the Tableau application for a long time and found it very useful, especially if I combine it with platforms like Jira. Can I ask if this new Tableau activities preview application will also work with the Jira application(or will I need to install them separately?) I have been using this combination for a long time after reading this article on the news update site https://newsupdate.uk/how-to-connect-tableau-to-jira/. Thank you for your answer and suggestions in advance!

0 Upvotes
johnelmer
Top Contributor | Elite Partner
Top Contributor | Elite Partner

We find deal ID's back in Tableau which don't exist in HubSpot anymore

SOLVE

@BGerrmann In case you would like to run a 30-day free trial of the HubSpot Integration for Tableau, here is a link to the app in the HubSpot App Marketplace.  (Disclosure: Datawarehouse.io is the integration platform from Bayard Bradford, a HubSpot Diamond Solutions Partner.  Datawarehouse.io apps have hundreds of installs worldwide.)

Did this post help solve your problem? If so, please mark it as a solution.






John Elmer, CEO
Bayard Bradford

Advanced CRM Implementation | HubSpot Custom Integration Services | Datawarehouse.io Apps for HubSpot
Elite HubSpot Solutions Partner
> Follow me on LinkedIn
RMones
Contributor | Platinum Partner
Contributor | Platinum Partner

We find deal ID's back in Tableau which don't exist in HubSpot anymore

SOLVE

Hi @BGerrmann ,

 

Can you maybe set in one of your exports if you want Archived deals? 
If they are adding Archived Deals through your export, you can have strange numbers of Deals.

 

Regards Ronald

BGerrmann
Participant

We find deal ID's back in Tableau which don't exist in HubSpot anymore

SOLVE

Hi Ronald,

 

Thanks for your tip. We haven't seen this function while making the export. My guess is that stitch just sents raw data through.

 

We've just used the integration via Datawarehouse.io  and all logic seems return. Our guess is that the we should add the logic rules somewhere in the export. For now we just might use the Datawarehouse.io API between the systems. 

0 Upvotes