Join our newsletter

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Run your data operations on a single, unified platform.

  • Easy setup, no data storage required
  • Free forever for core features
  • Simple expansion with additional credits
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Download the file

Oops! Something went wrong while submitting the form.

Accelerate Your End-to-End Data Pipelines With Keboola Data Templates

Automate the entire data pipeline with just a few clicks. Templates accelerate your data production and offer immediate data insights.

How To
August 8, 2022
Accelerate Your End-to-End Data Pipelines With Keboola Data Templates
Automate the entire data pipeline with just a few clicks. Templates accelerate your data production and offer immediate data insights.

Automation brings incredible value to data teams and hyper-growing companies. It removes hours of sweating over repetitive and mundane tasks, which frees up time for data engineers, analysts, and scientists to get on with more engaging and revenue-generating work.

Now, imagine that you can extend the benefits of automation beyond the selected repetitive tasks… to the entire data pipeline.

Enter Keboola’s data templates: a new way of getting data workflows to production in a one-click deployment.

What is a template?

Templates are like recipes for data products. You can think of Keboola as a smart, futuristic kitchen that makes some of the best meals from these recipes.

Imagine walking up to a shiny machine displaying pictures of tasty dishes. Click on the picture of the food you want to eat and voila! There’s a meal ready for you.

In the background, Keboola reads the template recipe. It selects the ingredients it needs from the cupboards then washes them, chops them, and mixes them up. It sautés and slowly simmers them until the meal is ready for your enjoyment. All according to the recipe that you selected.

Need an analysis of digital marketing? A template can quickly set up Keboola to connect to your advertising APIs and consolidate all expected metrics in an easy-to-understand dashboard. 

Curious about your subscription business? Use a template to calculate all of the metrics that you require.

Feeling the creative juices flowing? You can also take the template recipe into your own hands and adjust it to your taste.

Advantages of templates

There are several advantages to implementing data templates within your organization:

  1. Accelerate data production. With one-click templates, you can quickly deploy a fully-fledged data workflow to production. No time is wasted in discovery, acquiring, organizing, cleaning, transforming, and modeling data step by step manually. It also means that no time is squandered on project management, communication between departments and code handover. Templates streamline the usually fragmented data pipeline into a single process.
  2. Speed up POCs. Proof of concepts become more widely available. With the rapid deployment, you can quickly check if a data workflow makes sense for your organization’s needs - and of course, you can use the template-generated project only as a basis, a starting point for further expansion and customization.
  3. Limit discovery costs. One-click templates allow you to quickly discover new insights without having to decide whether the potential benefits of a model/visualization would outweigh the cost of building the entire data pipeline for that model.
  4. Unburden your data team. With pre-built data pipelines, the data team can cover a vast array of company use cases without sweating over the details. In turn, this frees up their minds and hands for other work that might be more interesting or challenging.
  5. Trust your models. With pre-made pipelines, you do not need to reinvent the wheel with every new dashboard and model. Templates are the industry ‘golden-standard’ way of doing things. You can confidently deploy a template instead of second-guessing, testing, and checking whether the data has been modeled correctly.
  6. Set a baseline. With machine learning models, in particular, the name-of-the-game is to continually improve the model. Templates allow you to swiftly deploy a model that can act as your baseline, upon which you can develop further.

What are Keboola’s templates capable of?

Templates, like recipes, come in many different varieties, and you can mix and match. Just to name a few:

  • Analyze the performance of your marketing efforts by aggregating data from Google Ads, Google Analytics, Facebook Ads, LinkedIn Ads and Bing Ads and saving it to a location of your choice.
  • Aggregate all your Shopify data and change it into actionable insights for inventory optimization, product category performance, measurement of sales campaign effectiveness, etc.
  • Extract data from Google Analytics report to get the big picture of how your website performs, so you can make necessary adjustments.

As you can see, templates can accelerate deployment of any project - from simple data extractions and transformations to advanced modeling, analysis, and machine-learning applications. 

What’s even better, any project or workflow can be turned into a template. A single click deploys the template and a wizard makes sure all the required information (such as data source credentials) is accounted for. 

A few seconds later a completely new workflow appears in the project - not as a black box, but as open-code transformations and component configurations that can be modified and built upon. The templates can even tag and describe tables and buckets for quick sharing into the Data Catalog, or for other templates to recognize the patterns and assemble themselves into more complex workflows and use cases.

The sky’s the limit when it comes to templates, and Keboola adds new ones regularly to keep your options fresh:

Keboola’s templates library.
Keboola templates library.

Step by step guide of Keboola’s templates

Let’s take a look at how you can use templates within Keboola. Once logged in, navigate to Templates.

Start your template journey from the home screen.

You will see a list of the templates that Keboola already offers. As new templates are being added to the list, you can use the search bar to find the one that you want to use. (Pro tip: start typing the name of the app from which you want to analyze/extract data).

Keboola templates library.

Let’s say that you want to track and analyze the performance of your website, so you would choose a Google Analytics template with destination of your choice.

A drill-down look at the components of the Google Analytics to Keboola DWH template.

Once we succumb to the appeal of the green button, we can see that the template is already doing everything for us. Next, we need to connect our Google Analytics account.

The steps you should take are in full color, the other procedures are greyed out. Complete the step and the next available step will appear in full color also.

Click the blue button Configure, to start with the first configuration.

Sign in with Google to connect your Google Analytics source.

Click ”Save configuration” and follow the next steps, all the way to the end (analysis or warehousing).

Breakdown of the configured source.

Once you follow all the steps, you will be able to Run flow and Set schedule for how often you want it to run.

Visualized data flows created from templates. 

Voila! Your meal is served. Bon appétit.

Curious about what templates can do for you?

Keboola offers an always free tier (no credit card required), so you can try templates and create your first data flow today. Ney, in minutes. 

Start for free.

Recomended Articles