I might be reading this completely wrong (as my answer is very different to asheeshp​ however if I wanted to to see "evar4" and "count of evar4 instances" I would do the following using evar4 - not post_evar4:select evar4 as "Search Term",count(evar4) as "Searches"from adobe_hit_datagroup by evar4

Similar to hariskum​.I have experienced this before and normally the first value is taken, however I would advise best practice and keeping the URL shorter and cleaner to avoid tracker issues.ThanksDave

Hi,We use window.screen (JavaScript Window Screen), however this was on a much older implementation around 5 years ago. I am surprised you don't have it now, we have had it out of the box for at least 2 years now.I would reach out to client care and ensure your libraries and implementation are fully...

Interesting.I have seen this on another implementation (all iphones registered as 320 x 480 even if they were an iphone 7). We got round it by adding resolution as an evar.However my current implementation shows everything as expected with 375px being the most popular (as you might expect). I assume...

Hi there,I highly recommend using the Adobe Datafeeds if you are moving to an azure blob.It's not as easy to get going and will require more work but the end result is night and day vs a data ware house extract or an API pull.ThanksDave

Hi Lalit,I think there may be some confusion. :-)If you look at my solution (post at 21-Aug-2019 00:37) you will see I reference a before and after.In the after I have removed the 30 day reference.ThanksDave

Hi ya,The segment is dynamic.The approx distinct count (day) will return a value of 1 if you pick just yesterday, 7 if you pick last week, 28 if you select the last 4 weeks etc).So if for example you have sold 3,444 units in the last 4 weeks and 300 in the last 7 days you would see the following:28 ...

Hi there,Yes you can do that. There are two parts to this.Part 1 - Dynamic datesIf you create a calculated metric (I have called it count of days):This will tell you how many days there are in the time period selected.In my original (and very long metric) you can then switch the basic logic from:to:...

Afraid you are correct - it absolutely will over right the existing dimension and time based classifications have now been removed.It will be interesting to see if anybody has an idea for this because I can only think of two solutions at this point:A)Crunch the data in SQL from a data feed and keep ...

One other - better way however (if I was doing this for myself) - would be to use the Adobe data feed into your data lake. Create a daily calculation here in SQL and then push that back in as a classification each day via automated FTP.More likely one for your data scientists and I.T team however.