Overview: Data Types

IN THIS

What are Data Types and when do they need to be set? 

Data Types describe the type of data that's being synced for the metric. They determine the way the Databox system handles the data. Should the individual values be aggregated, or does the value synced represent the total current value? Data Types answer these types of questions. 

Basic Metrics already have Data Types set. Setting Data Types is only necessary when syncing custom data via Google Sheets, the Databox API, or a SQL database. 

Data Type Definitions

Data Types can be set as "Total Values," "Daily Values," and "Event Values."

  • Total Values: This Data Type should be selected when your Metric reflects the current total Value for the Metric. In Databox, the latest entry will be displayed for the Custom Metric.

    For longer Date Ranges, data will not be aggregated and the most recent Value will be displayed for the selected Date Range. This is the main difference between "Total Values" and "Daily Values." 

    When building Custom Metrics with  Total Values selected as the Data Type, a Date selection is not always required. 

    Examples of Custom Metrics that should have Total Values selected are Total Followers and Current Account Balance.  

  • Daily Values: This Data Type should be selected when your Metric reflects the most up-to-date daily Value for the Metric. In Databox, the latest daily entry will be displayed for the Custom Metric.

    For longer Date Ranges, individual Metric Values will be aggregated for the entire Date Range and the aggregated Value will be displayed for the Custom Metric. This is the main difference between "Daily Values" and "Total Values." 

    Examples of Custom Metrics that should have  Daily Values selected are Daily New Followers, Daily Calls by Sales Rep, and New Purchases. 

  • Event Values: This Data Type should be selected when your Metric Value selection reflects individual Value(s) for the Metric at the specified Date/ Timestamp. This Data Type is the default selection because it is appropriate for the majority of use cases. 

    For longer Date Ranges with multiple entries, individual Metric Values will be aggregated for the entire Date Range and the aggregated Value will be displayed for the Custom Metric. When building Custom Metrics with Event Values selected as the Data Type, a Date selection is always required. 

    While updating the Google Sheet, new rows should not be added to the top of the document. This would result in duplicate data syncing with Databox, and potential inconsistencies. 

    If you update a single cell's Value in your Google Sheet, the old entry and the updated entry will both be saved in Databox. To prevent an inconsistency, you should go into Databox and resave the Custom Metric, being sure to select the Purge Data option. 

    If there are entries with identical Date/ Timestamps on your Google Sheet and the Event Values checkbox is not selected, the latest Metric Value entered on the Sheet will be stored in Databox.  If there are entries with identical Date/ Timestamps on your Google Sheet and the Event Values checkbox is selected, individual Metric Value will be aggregated and the aggregated Value will be stored in Databox. 

    Examples of Custom Metric that should have Event Values selected as the Data Type are Closed Won Amount, Impressions, and Sessions.

How to set the Data Type for a Custom Metric

Google Sheets + SQL Data Types can be set directly in the Query Builder. To edit the Data Type, navigate to Metrics > Query Builder and click the Edit button next to your Custom Metric. You can select the Data Type here. 

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