Workspace "Compare" columns with more flexibility

Avatar

Avatar

jkunz

Avatar

jkunz

jkunz

27-03-2018

I currently love and use the "Compare Time Periods" option frequently, but it only works in certain situations (for instance, it isn't an option if I have "days" as a dimension in the report), and I can't drag in Time Periods I've already created. I frequently want that sort of "compare" functionality on all sorts of different columns.

What I would love is to always be able to create a column that compares two other columns in the table. Summary change is nice but not if you have a lot of items in the report to compare. Quick calculated metrics and such are nice but don't give you flexibility with time periods.

14 Comments (14 New)
14 Comments

Avatar

Avatar

jkunz

Avatar

jkunz

jkunz

13-04-2018

To show some examples:

Currently, if I right click on a column (in certain circumstances), I get a "Compare Time Periods" report. I have a few clients that use this feature A LOT. When you do, you end with something like this, where a column appears to the left with a date range over it (which I can re-create in other ways), and a column to the right with a percent change between the two (which is what I WANT to be able to create in other ways):

1464715_pastedImage_0.png

There are a few critical limitations with this feature currently. First, if I swap out that purple date range on the left column for a different range, the "Percent Change" column on the right doesn't update. Here I replaced Feb 2017 with "Last Year" (here is where it gets buggy- the data changed on the left but not the "percent changed" column on the right):

1464730_pastedImage_2.png

Also, if I currently have "day" as my main dimension, I completely lose the "Compare Time Periods" option. I can still "Add time period column":

1464731_pastedImage_6.png

But if I do that, I lose that precious "Percent Change" column:

1464732_pastedImage_7.png

Avatar

Avatar

jkunz

Avatar

jkunz

jkunz

19-04-2018

Another limitation with "Compare Time Periods": if I do "Compare Time Periods>This week last year to this time range":
1469405_pastedImage_0.png
It nicely goes back in time to the right week:

1469406_pastedImage_1.png

But if I update the date range on the panel, the comparison does not update:1469407_pastedImage_2.png

...Making it very hard to create a dynamic, update-able report.

Avatar

Avatar

Nikki_Xie

Avatar

Nikki_Xie

Nikki_Xie

19-04-2018

Thanks for sharing the detailed examples, jkunz!

I have the same issue as you mentioned about changing the date period, then the percent change fails to update, which made me have to manually copy the table out to an excel spreadsheet to redo the % change in an excel. Adobe, please help to update this function!

Avatar

Avatar

ryans72649031

Avatar

ryans72649031

ryans72649031

11-06-2018

I would also very much like the ability to compare two columns of any kind of data, not limited to time periods. Today I find myself exporting data to Excel to do this. With this feature, I could do all of my reporting in Analytics. Some examples of columns I could compare are:

  • Two domains, with a set of various metrics running down the rows
  • Two A/B test experiences, with a set of metrics running down the rows
  • Two key segments, such as "mobile" and "desktop" or "loyalty" and "non loyalty"

The "Segment Comparison" tool kind of does this today, but it would be great if we manually had the option to drag a "Percent Change" column to the right of two other columns to hand pick the columns we wanted to compare and the metrics we cared about.

Is this on the roadmap? It seems like the functionality is almost there, just in different forms... Thanks!

Avatar

Avatar

ryans72649031

Avatar

ryans72649031

ryans72649031

19-06-2018

Any update on this? It would be hugely valuable. I recently saw this video (Quick Calculated Metrics in Analysis Workspace - YouTube ) from Adobe that shows how you can kind of do ad hoc "% Change" for two given columns. But I found it to be really limiting and buggy. For instance, it doesn't seem to work if you have a segment in either the column or a row. Also, it doesn't seem to quite work with calculated metrics that create a percentage, like a conversion rate (orders/visits). Is this planned to be built out more, or even better maybe the "Difference Score" from the "Segment Comparison" could be added as a metric that you could drop to the right of any two columns?

Appreciate it!

P.S. I also have a thread going here (Coolest way to trend % change on Adobe Analytics | LinkedIn) and was wondering if there's a way to do this even with the special calculated metric functions. But right now it seems like you'd have to do this ad hoc for every segment and metric you wanted to compare.

Avatar

Avatar

sonjaz43842682

Avatar

sonjaz43842682

sonjaz43842682

19-06-2018

I have the same problem - if I update the date range on the panel, the comparison does not update either.

Does anyone have a solution for this bug yet?

Thank you in advance!

Avatar

Avatar

marcush74174295

Avatar

marcush74174295

marcush74174295

18-10-2018

Not sure if it is a bug, it's been like this ever since I've started using Adobe. I'd also really, Really would like this change. It is so tedious right now to work over comparing a lot of different time periods. Would be a huge time saver!

Avatar

Avatar

marcush74174295

Avatar

marcush74174295

marcush74174295

18-10-2018

Same here. Would LOVE this feature. It is just too tedious to try and work with date comparisons with Adobe today.

Avatar

Avatar

Brandon_George_

Employee

Avatar

Brandon_George_

Employee

Brandon_George_
Employee

07-11-2018

Thank you everyone for your interest and comments on this thread.  There are many ideas being discussed here.  We have discussed many of them internally and have several on the roadmap already.  Unfortunately, they are not easy to solve in a generic way (which is why some of these things have appeared "buggy" - they actually are all working as designed for various reasons - but we understand that they do not always work ideally for your various use cases).  We know this comparison functionality is really important and key to your day-to-day work, so we will continue to consult internally and figure out how to prioritize which features.  Thanks for helping us understand the importance you have placed on this area of functionality.

Avatar

Avatar

merrittaho

Avatar

merrittaho

merrittaho

10-12-2018

yes yes yes yes yes yes

Add comparison capabilities for entire column regardless of column objects (dimension, metric, segment, time). Configure as # diff or % diff or some other calculation. So valuable.