Weighted Average Visit Number | Community
Skip to main content
C
czmudzin
Level 3
May 30, 2024
Question

Weighted Average Visit Number

  • May 30, 2024
  • 2 replies
  • 1637 views

Has anyone created a calculated metric to get the weighted average of visit number? It's something I use often when examining customer journey, and I often extract the data to Excel. I'm wondering if it can be done in Workspace to save time.

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

2 replies

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
May 30, 2024

I don't use metrics like that often, but I believe that some are possible to make... if you share how you calculate your weighted average then maybe we can figure out how to do that in Workspace.

C
czmudzinAuthor
Level 3
June 3, 2024

Here is my issue. I need to multiply the '1 pct of total' metric by the visit number. But, the visit number is a string. Is there a way around that?

 

 

MandyGeorge
Community Advisor and Adobe Champion
MandyGeorgeCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
June 4, 2024

Unfortunately, this makes it quite difficult. Since your visit number is a dimension/string value, you can't use it as a number in a metric. Are you still using Workspace or are you on CJA? I know in CJA there are options to create new fields based on current dimensions/metrics. I believe there is a way to turn a dimension like that into a metric in CJA, but there's nothing like that in workspace. 

 

Another possible solution would be if you use report builder. You could replicate that table in report builder, and then you would have the option to edit the data in excel and do the multiplication there. I would suggest just doing an export to excel as another option, but if this is a recurring need and not a one off, then you would have to continuously export the data, so less useful. 

 

I can't currently think of any other options for making this work.

    MandyGeorge
    Community Advisor and Adobe Champion
    MandyGeorgeCommunity Advisor and Adobe Champion
    Community Advisor and Adobe Champion
    May 31, 2024

    I've actually been working on making some weighted metrics in workspace recently, it should be possible with the use of the advanced functions. 

     

    There is a function for "column sum" - that will likely be very useful for your weighted metric calculation. For example, a very basic formula, to see how individual items contribute to an entire metric, you can do something like this.

     

    The column sum is great because it adds up all of the rows, and then you can look at an individual rows contribution to the entire sum. The only issue with this is that it doesn't deduplicate data. For example, if I were to use visits instead of page views, it would could all the visits for all the pages in the table, massively inflating the visit count. There might be a way around this by using multiple other functions/calculations, but I haven't solved for it yet. 

     

    Like Jen mentioned, if you share the formula you use in excel for your weighted calculations, we can help replicate it in the metric builder. 

     

      C
      czmudzinAuthor
      Level 3
      June 3, 2024

      This was definitely helpful solving part of of the issue. Thanks for sharing!

      Terms & ConditionsAccessibility statement

      Loading footer...