I have a need to bring two existing Business units into one. I have all of the standard tracking data stored in them both (Linked by a parent). I would like to be able to maintain all of the data but I can't see a way of being able to get this all into one. Users would want to be able to filter based on last sends etc. Is there a way to achieve this?
-
1Tracking data is business unit specific. If you want to merge two business units into one, the tracking data will not be consolidated. As a workaround you can create query activities on data views to extract the tracking information and put into a seperate data extension. If a user wants to see the historic tracking data they may need to search this data extension based on subscriber key.– ChandanCommented Dec 5, 2018 at 19:51
-
Did the above solved your query? If yes please accept it as answer for the other's reference– ChandanCommented Feb 7, 2019 at 19:59
1 Answer
You will have to store the data in Shared Data Extensions since the data is on two separate business units.
Understand that if you have subscribers in one business unit that are not in the other, you will not be able to join the tracking data but you can still have a consolidated view of tracking data.
Use Data Views to pull in the _Sent, _Open, _Click, etc. Note that the data in Data Views only goes back 6 months so you'll have to keep adding to this data extension if you want a longer time frame.