Hi there - merchandising attributes would 100 percent solve this issue  We use them on our site where we have around 20 attributes which we then crunch in a data lake later. https://experienceleague.adobe.com/docs/analytics/implementation/vars/page-vars/evar-merchandising.html?lang=en 

Hi @Urs_Boller, We had this issue earlier this year and it isn't good news I am afraid. We have over 300 accounts in our MMC. We spoke to product management about it only 2 or 3 months ago and the feedback was to consider purchasing Advertising cloud. Not an ideal solution when you are fighting to k...

Go to Components > Alerts. It's quite straightforward once your are there. https://experienceleague.adobe.com/docs/analytics/analyze/reports-analytics/alerts.html?lang=en  

Curious - what sort of difference are you seeing as a percentage across 5 days?

@DillanGump - It should not make a difference but have you tried it against workspace as well as reports? That's the only different I could think of. Other than that your query returned perfect numbers for me.

@deion - sorry I have just reread this. I am afraid this not going to be possible in Adobe. The main reason is because while you can build a custom metric that only counts the hours of yesterday that have passed, it will never be a fair comparision because Adobe will look at the whole hour. So as an...

Good idea. This is not an ideal solution but in our business, we get around this by using a mixture of report builder and Tableau. Not the perfect solution but one that can be considered. Thanks Dave

@DillanGump- I think this might be something really simple.and hit_source not in (5,8,9)should beand hit_source not in (5,7,8,9)Once I did that (and renamed the page and database) your query ran fine for me.

@deion - yes if you want to create this for every hour of the day then you will need to repeat 23 times. Are you going to be using workspace or another tool (API / Datawarehouse)? I only ask because in workspace you will need to have 24 columns (you can't pivot this work with rows) which might make ...