BETA: Working with dynamic data sources

A dynamic data source is a data source which uses one or more variables in its query instead of hard-coded values, thereby enabling the ability to dynamically retrieve data. Learn more about variables here.


Important notes

Please note the following when working with dynamic data sources:

  • Modelling dynamic data sources is not currently supported.
  • When creating a dynamic data source, you have to specify any dynamic parameters directly in the Query URL.  You cannot use the Query Parameter fields.

This article includes:

Setting up a dynamic data source

A common use for dynamic data sources is accessing a list from a data source, for example, Google Analytics profile IDs, Facebook pages, or Google Ads Manager Account client IDs, and displaying the data for each item in the list. You can do this effectively with dynamic data sources instead of creating a separate data source for every profile or page ID in your list.



  1. In the Klip Editor, at Advanced Tools, click Create new variable and enter a value, for example, a variable called gaID with the value set to a profile ID, for example, 1234567.



Replace 1234567 with {props.gaID}.

The query will look like the following:{props.gaID}&start-date=date.startOfYear&end-date={}

  1. To create a list of values like profile IDs, build a drop-down User Input Control component to select the profile IDs from and enter the list of values you want to select from in the Values sub-component.
  3. Build a Klip, with a Table component, with the data source that was returned when you created the query. Select the columns of data and reference the data as you would with any data source.


Troubleshooting dynamic data sources 

Following are some troubleshooting ideas for your dynamic data sources. If, after going through this section, you still need debugging assistance, contact

What do I need to know about dynamic data sources with multiple variables?


How do I know if my dynamic data sources are failing?

You can quickly see a list of your dynamic data sources that are failing to refresh.

If you see a red icon in the left navigation bar (beside Data Sources) that means you have at least one data source that is failing to refresh. (Learn how to view clients’ failing data sources here.)

Clicking the red icon opens your list of data sources with the Failed Data Sources filter applied. (You can also access this list by clicking Data Sources in the left navigation bar and then selecting Failed Data Sources from the filter drop-down list.)

All the data sources that have failed to refresh are listed with their Last Refresh date. If you are unsure which of your data sources are dynamic data sources, click the red exclamation mark beside the Data Source Name (see below) to go directly to its About this Data Source page. If it’s a dynamic data source, the page will not include the Download Data option.

If a dynamic data source(s) is failing, you can resolve this issue by going to its debug_info page and removing the failing data source instance using the “x”. (See the following section of this article for more detail.) If the failing instance re-appears, you will need to investigate the cause. For example, it could be due to incorrect variable options or variable values in the Klip Editor or a problem in the formula.

How do I access debug information?

If you are having issues with your dynamic data sources, you can use our debug_info pages to help you resolve them.

To access the debug_info pages:

  1. In the left navigation sidebar, click Data Sources.


  2. In the URL displayed in the browser address bar, replace view with debug_info.
  4. Check for dynamic data source instances with the following issues:
    • invalid or missing variable setting
    • empty last refresh value
    • small data size
    • refresh fail count with a non-zero value
    • click refresh to refresh the dynamic data source instance

Following are some examples of errors and suggestions for resolution:

Related Links

Have more questions? Submit a request