Average of dimension

[VidhyaAk1]

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

[Jennifer_Dungan · Accepted solution]

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.

[VidhyaAk1]

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"?

[Jennifer_Dungan]

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....