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.