Average of dimension | Community
Skip to main content
VidhyaAk1
Employee
May 31, 2024 12:13 PM UTC
Solved

Average of dimension



Below table shows the audience size for a particular article. audience size is an dimension (Evar47)
Client wants to know the average audience size .
How can we create average of evar47

 

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Jennifer_Dungan
    Jennifer_DunganAccepted solution
    Level 2
    May 31, 2024 1:20 PM UTC

    Unfortunately, dimensions are stored as text, so you can't average that information directly in Adobe Workspace. 

     

    That said, you can use Report Builder to pull that information into Excel, and use Excel to convert the data to a number and build out your average there. Report Builder reports can be scheduled, so once you have a working report you can send it at a regular frequency to your client.

     

    When I do things like this, I like to pull the data into a "Raw Data" sheet that I hide, then I pull the data into a cleaner, styled sheet that is visible to the audience.

    View reply

    3 replies

    Jennifer_Dungan
    Jennifer_DunganAccepted solution
    Level 2
    May 31, 2024 1:20 PM UTC

    Unfortunately, dimensions are stored as text, so you can't average that information directly in Adobe Workspace. 

     

    That said, you can use Report Builder to pull that information into Excel, and use Excel to convert the data to a number and build out your average there. Report Builder reports can be scheduled, so once you have a working report you can send it at a regular frequency to your client.

     

    When I do things like this, I like to pull the data into a "Raw Data" sheet that I hide, then I pull the data into a cleaner, styled sheet that is visible to the audience.

    Translate
      VidhyaAk1Author
      Employee
      Jun 4, 2024 12:41 PM UTC

      Hi @jennifer_dungan 

      thanks for explanation.

      I want to have audience size  values as metrics, can i store these values in custom event and keep event type as "numeric"?

      Translate
        Jennifer_Dungan
        Jennifer_Dungan
        Level 2
        Jun 4, 2024 2:31 PM UTC

        It might be possible.. I am not sure how you are actually setting this value...

         

        I would be a little concerned that while you have a text value that says "8424", whatever metric you are combining it with is 102... if you try to track this as an event so that it's numeric, I wouldn't want you to end up with 859,248 (or higher since the metric in use may not be Occurrence, but more of a roll up metric like Visit or Unique Visitor). Basically, I am trying to say that when you push an event, it will count every time its set... so controlling it in a way that makes sense for your implementation could be very difficult....

        Translate
          Terms & ConditionsAccessibility statement

          Loading footer...