Data Templates for Better Efficiency and Analytics

Designed to make your life easier, our ready-to-use data templates help you in your data modeling process. There are currently three types of data templates available:

  1. Calendars
  2. Open Data sources (Currency exchange, Weather, Demographics, etc.)
  3. ClicData specific assets

Each data template can be downloaded on the platform, and be refreshed with the classic methods used with your own datasets. They behave exactly as other datasets.

To set up a new data template, simply open the “Add New” dropdown menu in Tables & Views.

image 5
Load a Data Template to your account

To show the power of this capability, let’s explore a few use cases:

1. Calendars

Calendars are provided at hourly, daily, weekly, and monthly granularity. Additional info such as business days, day names, weekday, week number, epoch times, business days per month, etc. are included in the dataset.

Daily calendar preview
Daily Calendar data template

Use the daily calendar as a base to aggregate figures from uneven datasets against it. Let’s imagine we are a Car selling Company with multiple dealerships closed on different days throughout the week. We want to compare conversion data from our website with the sales in the dealerships. None of these datasets present a full calendar, as there are no sales every day in any of them.

This is where the Daily calendar data template comes in: it will be the backbone of the aggregated data from all sources, making sure that for each day in the calendar, sales and traffic data are aggregated from each source. From there you can then easily use the weekday numbers, week numbers, months, quarters, etc. to visualize KPIs in different time periods.

2. Open Data Sources

Weather

The templates provide historical weather and forecast of 7 days for hundreds of cities. Min and Max temperatures, wind strength, sunrise and sunset times, rain and snow duration, and many more metrics are accessible to give a complete overview of each day’s local ambiance.

historical weather data template for Toronto
Weather in Toronto historical data template

Use this data for example to give context to your B2C sales KPIs. Whether you are selling trips, swimming pools, or food, weather can have an important impact on the consumer’s morale and interest in buying your products.

Let’s say you’re a restaurant owner, weather can greatly affect your customers’ decision to eat and drink outdoors, as you can see on this graph:

weather impact on restaurants sales
Example showcasing weather’s impact on restaurant sales.

This template is particularly helpful to give context to your sales KPIs by comparing how weather and sales correlate. It’s also possible to check how it correlates in different cities and countries if you have multiple locations.

And you can use the forecast weather to adapt your inventory and marketing campaigns accordingly! Pretty awesome, right?

Demography

Geographical templates come along with useful info such as latitude, longitude, associated region, demography, and surface from the World Data Bank API.

image 2
Country ISO Codes data template

These datasets can be used to enhance your own datasets and hence data analysis.

Some examples:

  • Group country data by region
  • Compare the age distribution of your sales figures to the country’s age distribution
  • Visualize your data on maps
chart population percentage over 65 years old
In Canada 19% of the population is older than 65 years.
  • …and many more usages

Currency

This usage is pretty straightforward, isn’t it? The data template enables you to get historical currency exchange rates between all currencies, in the direction wished.

USD to CAD, CHF and HKD currency exchange rates
USD to CAD, CHF and HKD currency rate

Currency exchange rates are specifically useful in the context of large international companies. Fetching the day-by-day rates for each currency used enables faster and more accurate financial reporting.

3. ClicData Templates

These templates give you dynamic access to all the metadata of the usage of your ClicData account. Whether it’s User logs, dashboard activity, or listing all objects of your account, you can get this via the templates, and automatically update them via the refresh system.

dashboard data template
Dashboard Data template

Here are a few examples of use cases for these data templates:

  • Build dashboards showing Dashboard usage over time
  • Track your User’s activity on the platform
  • Get an overview of Dashboards used in Binders
  • Track your Tasks’ activity
  • Set up alert dashboards for failed and successful Schedules

Most of these datasets are available as manual downloads in each explorer, but using data templates instead, you will be able to automate the refreshing and build dynamic dashboards.

And more…

We continuously add new data templates, so keep a lookout for updates on this feature.

And if you have suggestions for new templates, don’t hesitate to share them with the Support team, at support@clicdata.com.

We’d love to have your input!

Grasp the latest ClicData features: