Extract Unique Mobile number from datawarehouse | AA workspace | Community
Skip to main content
R
rush_1997
Level 2
June 23, 2023
Solved

Extract Unique Mobile number from datawarehouse | AA workspace

  • June 23, 2023
  • 1 reply
  • 776 views

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 ?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jennifer_Dungan

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...

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
June 23, 2023

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:

 

R
rush_1997Author
Level 2
June 26, 2023

Hi Jenni ,

 

I appreciate your response, but I have a question about how to retrieve distinct mobile numbers from an AA workspace or data warehouse.

 

I don't want type of mobile device a user is using; I only want that they have a unique mobile number when they visit my website or buy a product for the first time.

And want to extract unique mobile number who visited first time

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
June 26, 2023

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...

Terms & ConditionsAccessibility statement

Loading footer...