Approx Count Cross Device

[joshd96900295]

Hi,

I'm trying to calculate a count of customer id's that have logged in on different devices. I've used approx count distinct to give me a count of customers id's that have logged in but I'm trying to take it one step further and would like a count of customers id's where they've logged in on both a mobile and desktop device. Any suggestions on if this is possible and solution would be appreciated. 

Thanks, 

Josh

[Jennifer_Dungan · Accepted solution]

Unfortunately, without access to Adobe's Device Graph (which is available through Adobe Analytics Ultimate package / Customer Journey Analytics) where you can use a new metric called "people"... there is no way that I am aware of to stitch the different UV metrics for your different platforms together to look for customers that have logged in to both places....

You could try using Report Builder to pull the data into Excel, then use Excel to perform the logic to only show you your customers that have been in both platforms.....