Hi Emmet,This is metric is a custom metric, called a success event, that
is specific to your site. My best recommendation is for you to work with
your administrator and implementation team to figure out how and when
this metric is called.Based on how it was named, I'm guessing it's
captured in event9. If you want to try and find out how it is populated
on your own, you can use the Experience Cloud Debugger to find event9.
Here is a helpful video on using the Debugger: How to Use the Adobe
Data Warehouse outputs this information in this exact format. That would
be my recommendation as well.Workspace, while it does allow breakdowns,
does not do so in a table-like format. There has been a request to
introduce this table-like format, outlined in this idea here: Multiple
Dimensions columns in Adobe Workspace Be sure to upvote it and comment
there why it would be valuable to you in reporting!
Urs's bullet 3 would be my recommendation.Create a classification for
the user ID custom variable.In the classification template, find the
1000 user ID's you want to focus on, and give them the same
classification valueUpload that file back into the classification
importer, then wait for it to processCreate a segment where "eVar
classification" equals "classified value".Revel in this ultra-simple and
well-performing segment as you have all your reporting needs met. If you
need to change the user...
Hi emmetc2018if you want the perfect numbers go to the IT and ask for a
login log file. Analytics might loose some of your users due to provacy
settings on their end. therefore you will most like miss some userIDs in
your reporting anyway...However, here are some ways to get close to the
question you are looking for:List of userID's with certain amount of
visitscreate a table with dimension "userID". vor the first col use a
calc. metric like this:"if (greater than: visits | static number 30)
This is the power of Adobe analytics...In Analytics create a segment for
that userID variable...Then use regex to isolate your list of 3000 IDs.
If you then have that segment you could then run reports in analytics
isolating just those users by adding lets say a visit component to it...
In data warehouse you then pick segment and run it.ORRun report for all
IDs and in excel match the 3000 and filter them...