Overview: Data Types

Pro Tip: Basic Metrics already have Data Types set. Setting Data Types is only necessary when syncing custom data via the Databox API, Google Sheets, or an SQL Data Source. 

HOW TO USE

How to use Google Sheets + SQL Data Types

HOW TO

How to use Google Sheets + SQL Data Types

Google Sheets + SQL Data Types include "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 Google Sheets + SQL Data Types

Google Sheets + SQL Data Types are set in the Query Builder when you first create the Custom Metric in Databox. To edit the Data Type, navigate to  Data Manager > Query Builder and click the Edit button next to your Custom Metric.

How to use Custom Data (via Databox API) Data Types

Data Types define what kind of numbers you are syncing with Databox. You can sync different kinds of data, from unprocessed raw numbers to current balances, averages, unique values, rates, and more. Each Metric has its own Data Type set. 

HOW TO

How to use Custom Data (via Databox API) Data Types

Custom Data (via Databox API) Data Types are used to instruct the Databox system how to handle the data you're syncing. 

  • Difference from Previous (default): By default, we assume you're syncing raw, unprocessed data that represents the difference from the previous value. This is the correct Data Type selection when syncing Event Values. 

    An example of syncing "Difference from Previous" data would be initiating a data sync each time a new deal is won. To see the total Closed Won Amount for a day or for longer Date Ranges, Databox will sum together the individual Closed Won Amounts. 
  • Sum for Day: This is the Data Type  for fully aggregatable, non-unique data. If you sync values many times a day, the latest value counts as the ‘real and final’ value for that particular day. The value is reset to zero at midnight UTC. Most cloud services treat data this way
  • Count for Day: This Data Type is similar to "Sum for Day," but acts as a counter. The final count at the end of the day is the 'real and final' value. The value is reset to zero at midnight UTC.
  • Minimum for Day: This Data Type is similar to "Sum for Day," but sets the minimum entry as the 'real and final' value for the day.  The value is reset to zero at midnight UTC.
  • Maximum for Day: This Data Type is similar to "Minimum for Day," but sets the maximum entry as the 'real and final' value for the day.  The value is reset to zero at midnight UTC.
  • Unique Daily Value: This Data Type represents daily data that cannot be aggregated, averaged, or in any way combined with other daily values. Since these Metrics are unique, manipulating the data could result in inconsistencies. 

    An example of a Metric that has "Unique Daily value" as the Data Type is "Unique Daily Users."
  • Overall Total: This is the Data Type for data that represents the overall, current value. Data doesn't ever reset. Instead, each entry represents the current Metric value. The latest synced data is the 'real and final' value for the Metric. 

    Metrics with this Data Type should be visualized with the "All Time" Date Range selected. An example of an "Overall Total" Metric is "Account Balance."

How to set Custom Data (via Databox API) Data Types

1
 Navigate to the  Data Manager
2
 Find the token where your data is synced, 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 Data Type you want to set
4
 Click on the drop-down list in the Datapoint Type column
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