Clear up calculated metrics - Recommendations? | Community
Skip to main content
S
sabined51282667
Level 2
September 20, 2022
Solved

Clear up calculated metrics - Recommendations?

  • September 20, 2022
  • 1 reply
  • 1743 views

Dear all, 

 

after some years of using Adobe Analytics we see more and more calculated metrics that are double or way more than double.

We totally understand why this is happening. Either some colleagues calculate their own metric without knowing about the existing one or when we push projects to multiple report suites and save them, they duplicate sometimes too. 

 

My question is, if there's an easy way or any recommendations how to handle this and how to clean this up. Our concern is, if we just delete some of the calculated metrics, they will disappear in the projects they are used in. We want to avoid this.

As far as we know it's not possible to see in which projects one special calculated metric is used, so we could replace it in those projects. 

 

Thank you for sharing your experiences with this and best regards

Sabine

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jennifer_Dungan

I believe that IF there is a calculated metric in a report, and you "delete" the one that is your manage components that the one in the workspace will continue to exist....

 

I don't believe that "delete" actually deletes it... rather it deletes the record association to your components.... but before you go crazy deleting stuff.. test it out..

 

Create a "TEMP" calculated metric... add it to some test workspaces, and report builder if you are using it, etc... then delete the calculated metric and see what happens to those reports.

 

Sadly there is no feature that allows us to see the reports using specific components....

 

Now, this idea is more specifically about Segments, but I would suggest you add a comment about having this feature extended to Calculated Metrics and give it an upvote; and hopefully this idea will be considered for future enhancements of the product.

https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-ideas/segment-overview-to-identify-where-segments-are-being-used-in/idi-p/459937

 

 

As for cleanup... if deletion of items in active use doesn't impact those reports, you can be a little more heavy handed in your approach... but I know the feeling... if I am going to delete a calculated metric, I would want to replace those instances with the "canonical" version so that any future updates roll to all reports....

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
September 20, 2022

I believe that IF there is a calculated metric in a report, and you "delete" the one that is your manage components that the one in the workspace will continue to exist....

 

I don't believe that "delete" actually deletes it... rather it deletes the record association to your components.... but before you go crazy deleting stuff.. test it out..

 

Create a "TEMP" calculated metric... add it to some test workspaces, and report builder if you are using it, etc... then delete the calculated metric and see what happens to those reports.

 

Sadly there is no feature that allows us to see the reports using specific components....

 

Now, this idea is more specifically about Segments, but I would suggest you add a comment about having this feature extended to Calculated Metrics and give it an upvote; and hopefully this idea will be considered for future enhancements of the product.

https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-ideas/segment-overview-to-identify-where-segments-are-being-used-in/idi-p/459937

 

 

As for cleanup... if deletion of items in active use doesn't impact those reports, you can be a little more heavy handed in your approach... but I know the feeling... if I am going to delete a calculated metric, I would want to replace those instances with the "canonical" version so that any future updates roll to all reports....

    S
    sabined51282667Author
    Level 2
    September 21, 2022

    Hi Jennifer, 

    thank you for your answer. I tried to do as you said with a test metric in a test project and the metric is still working after I deleted it.

    So, it looks like we can delete metrics without affecting existing projects. 

    Thanks again and best regards

    Sabine

    Jennifer_Dungan
    Community Advisor and Adobe Champion
    Jennifer_DunganCommunity Advisor and Adobe Champion
    Community Advisor and Adobe Champion
    September 21, 2022

    You're welcome 🙂  Good luck cleaning up your Calculated Metrics... that's something I should probably tackle in my instance..... 

      Terms & ConditionsAccessibility statement

      Loading footer...