If the weekday days are really high then they would push the average up and the Saturday I’m looking at will always seem low. You could also do the same for certain days of the week if you had the need. For example, if I’m looking at a particular Saturday and I want to know how that compares to the average, it may not make sense to compare to the average across all days. This can be especially useful if your company experiences dramatic shifts in traffic on the weekend, and you don’t want the usual weekly trend to throw off your comparisons. You can also use a variation of this to give you averages for just the weekday or weekend. With this metric created you can now use this in your reporting to show a daily average along with your total values: 5 this could cause problems, so keep an eye open for that and let me know if this happens to you. From what I have seen so far this is good enough to make the calculation accurate. To help it out a bit I just use the ROUND function to ensure that it is a round number. Now what’s up with the ROUND function in yellow around that? Well, as the name indicates, the distinctness of the count is approximate and doesn’t necessarily return a whole number like you would expect. This asks for a dimension as the only argument into which you would plug the “Day” dimension. The most important part of this is the red section which is the APPROXIMATE COUNT DISTINCT function. Here’s how it would look in the calculated metric builder for a daily average of visits: The cool thing about this approach is that you can then use the metric across any time range and your denominator will always be right. This approach takes advantage of the Approximate Count Distinct function to count the number of days your metric is seen across. This is still a bit awkward, but should be easy for advanced users to create a metric that others can easily pull into their reports. Thankfully, with today’s modern technology we are better equipped to do basic math ).
You either had to create a metric that could only be used with a certain time frame (with a fixed number of days), or create the metric in Report Builder using Excel functions. Traditionally it has been a tad awkward to create a metric that gave you a daily average in Adobe Analytics. Originally written by Kevin Willeitner on August 7, 2018
0 kommentar(er)
