Extract Unique Mobile number from datawarehouse | AA workspace

Question

Hi , How to extract unique mobile number from last year or current month in AA workspace or extract it from datawarehouse. Is it possible ? if possible then How ?

Jennifer_Dungan · Accepted Answer

You mean that you want their actual phone number?

You cannot get this unless they share that with you.. but even IF they share it with you, that is PII and would caution against tracking this information.

Even if you were to use such a value, such as using as part of event serialization, that information is all stored in the raw data which could be a massive privacy issue...

Jennifer_Dungan · Answer

Data Warehouse is much harder (and potentially impossible to pull) based on what other dimensions you need to look at... this is because the UVs are returned at a "per row" (i.e. particular combination of data)... which is perfectly fine for that row.... but you can't add the rows together as you will over count your UV data (the same user included in multiple rows will be added over and over again)

Now, in Workspaces, the totals will be properly de-duplicated.

If you are just looking for generic "mobile devices", you can use Adobe's standard "Mobile Device Type = Mobile Phone"

However, if you consider other things, like tablets or eReaders as "Mobile", then you will have to create a segment that includes all the types you want included.

Once you have this segment applied, you can set you panel to the range you are looking for, use the segment and use standard "Unique Visitors" metric

Such as:

Or

Resulting in:

This should get you what you need... if you want to see mobile against other device types, then you can simply use:

Sign up

Login with SSO

Login to the community

Login with SSO