Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
SOLVED

Trend Year over Year

Avatar

Level 2

I cannot seem to figure out how to trend year over year by month in the workspace. I'm just trying to get our key metrics (unique visitors, visits) for this year to date by month and then how that compares to last year the same time. Should I just do two freeform tables next to each other? seems odd that this is not an easy option unless I am completely missing it.

 

UPDATE: based on a post I discovered by accident from November it sounds like this is still on the docket for improvements. I'm kind of shocked it was pushed without this. I really thought I was just missing something.

1 Accepted Solution

Avatar

Correct answer by
Level 10

Hi Andrea, 

Have you been able to create the comparison in workspace? 

For a comparing trended reports like the key metrics report you would have to create 2 different freeform tables and use different date ranges. For comparing a ranked report like a pages report you would simply have to add the metrics/dimension twice in the freeform table and apply the date range on individual columns. 

Let me know if this helps you.

Tanmay

View solution in original post

6 Replies

Avatar

Correct answer by
Level 10

Hi Andrea, 

Have you been able to create the comparison in workspace? 

For a comparing trended reports like the key metrics report you would have to create 2 different freeform tables and use different date ranges. For comparing a ranked report like a pages report you would simply have to add the metrics/dimension twice in the freeform table and apply the date range on individual columns. 

Let me know if this helps you.

Tanmay

Avatar

Level 2

You have got to be kidding me, this has been going on since 2016 and it is November of 2021 and it is not fixed yet?!?  We, as customers, have to do the same thing you were doing in 2016 for a work a around??? Really?? 

Avatar

Adobe Champion

One way to do this is to create custom metrics for YoY variance, then create a table with that metric against Month of Year. This video is helpful for creating the date segments and metrics: Growth Rates. Adobe Analytics Workspace Training (2018) - Part 4 - YouTube

JJamnik_0-1668527756804.png

Avatar

Level 2

This isn't actually a great solution as there's real physical distance between the two. There's a compare option within Reports that should be available on on reports, not just custom traffic and conversion reports or when added to dashboards.

Avatar

Level 2

I can't get the Compare Time Periods feature to work at all.  I have a freeform table with a PageName value as the row, and Visits as the metric.  When I right click on the PageName value I don't see Compare Time Periods as an option.