How to access additional Granularity and Aggregation options for Custom Metrics

You may see limited Granularity and Aggregation options for certain Metrics because of the way the data is stored in the Data Source's API. In Databox, this may result in Line Charts and Bar Charts that are difficult to analyze. 

For example, Google stores  daily data for website metrics like Sessions, Users, etc. in their API. This means we can access how many Users and Sessions were tracked on Sept 30, Sept 29, Sept 28, etc., but we're not able to access this data for weekly or monthly ranges like "Sept 22 - Sept 28" or "September." 

"Sessions" is not a unique metric, so we can easily take the daily entries, add them together, and the result will be the weekly or monthly total. This is why you have "Daily," "Weekly," and "Monthly" Granularity options for "Sessions." 
"Users" is a unique metric. If a user visits your site on Sept 22 and again on Sept 26, in Google Analytics they're only counted once for the week. However, from Google's API we have no way of knowing that the same "User" was tracked on multiple days. 
So, if we add together the daily values, the weekly and monthly "Users" value you see in Databox may be higher than what you see in Google Analytics. Because of this, there is not a "monthly" granularity option for "Users." 
Keep in mind that changing Data Types may impact the default Aggregation of the Metric everywhere in your Account. This means the Metric value may be affected on other Datablocks, in Scorecards, Alerts, Goals, etc. 
If you're okay with this possible discrepancy, there is a way to uncover more Granularity and Aggregation options for Custom Metrics. 

1
 Navigate to  Data Sources
2
 Find the Data Source that stores the Metric you want to update, using the Search bar if necessary. Click on the drop-down arrow next to the Details button and select  Edit metric keys
3
 Use the Search bar to find the Metric whose Granularity options you want to update
4
 You'll see the Data Type set as "Daily unique values" for Metrics like "Users." Change the Data Type to " Difference from previous." This will change the way data for this Metric is stored and will reveal additional granularity options
5
 Navigate back to the Databoard where the Metric is used. Open Advanced Settings and update the Granularity and Aggregation selections as you see fit
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us