Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Count of unique IDs. How do I do this

Avatar

Avatar
Validate 1
Level 1
mark-north-of-t
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
mark-north-of-t
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
mark-north-of-t
Level 1

04-01-2018

I capture a unique id when a customer logs in.  They log in multiple times a month.  What I'm looking for is a count of the unique Ids a month.  I have well over a million unique Id's logging in a month.

How do I do this?  Preferably without going to data warehouse; I need a bit a bit of a faster turnaround. 

Thank you!

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Contributor
Level 5
mubarakd5726232
Level 5

Likes

86 likes

Total Posts

89 posts

Correct Reply

3 solutions
Top badges earned
Contributor
Shape 25
Shape 10
Shape 1
Ignite 1
View profile

Avatar
Contributor
Level 5
mubarakd5726232
Level 5

Likes

86 likes

Total Posts

89 posts

Correct Reply

3 solutions
Top badges earned
Contributor
Shape 25
Shape 10
Shape 1
Ignite 1
View profile
mubarakd5726232
Level 5

09-01-2018

Not sure if this will work for you (as you have over a million) but try creating the following calculated metric

Look for 'Approximate Count Distinct' ... as the label suggests this is approx (but may be good enough)

Add the dimension sprop/evar

.. and apply to table 

Answers (1)

Answers (1)

Avatar

Avatar
Seeker
Moderator
PratheepArunRaj
Moderator

Likes

309 likes

Total Posts

863 posts

Correct Reply

263 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Affirm 250
Contributor
View profile

Avatar
Seeker
Moderator
PratheepArunRaj
Moderator

Likes

309 likes

Total Posts

863 posts

Correct Reply

263 solutions
Top badges earned
Seeker
Bedrock
Engage 1
Affirm 250
Contributor
View profile
PratheepArunRaj
Moderator

04-01-2018

Dear Mark,

Mostly for the count, I will use Adhoc Analysis or Workspace to get the count : One Row = One Unique Count. Easy and simple way!

1387374_pastedImage_0.png

But the above wont help if you have (Low-traffic) grouped into one line.

So, if you have (Low-traffic) grouped into one line, you should go only to Data Warehouse. No other go!

And you can do this advanced implementation using getValOnce with an event assigned to it and set the expiration to 30 days. Now, the event count will get you the unique count for the period of 30 days.

Thank You!

Arun