How to combine data sources

In Advanced Analytics, you can combine various sources into a single data source. The combined source allows you to display data from sources of multiple types on the same chart and compare different metrics.

This guide describes the process of creating a combined data source using an example from two CSV files. It is also possible to combine sources of different types, e.g., a CSV file and a Google Sheets table.

Creating a Data Source

  1. In the Data sources tab, click + Data source.
  2. Click Combine Existing Data Sources.
  3. Select two or more sources from the list of your sources and click Done.
  4. For each data source, select a dimension to build the relationship between the sources. Specify a name for this dimension.
  5. From each source, select measures that will be used in the new data source.
  6. Click Done.

The combined data source is updated automatically every time any of the original sources change. You can share the combined data source with other Publisher Account users by clicking the icon and selecting Add collaborators in the drop-down list.

Creating Reports

To create a report based on a combined source, follow the Basic information on creating reports guide and specify a combined data source as the data source.

Report restrictions:

  • You can use only one dimension for one chart. Other dimensions are available only as filters.
  • The following features are not available:
    • the ranking filter
    • the weeks level of the calendar dimension
    • index dimensions of the calendar dimension
    • sorting
    • creating combined data sources based on Google Ads
    • coloring by measure
  • In the cross table, you can display only one dimension per column and per row. Also, you can’t select a measure for the entire table. To display a measure, use the List of measures dimension.
Was this article helpful?
Thank you!
Is there anything we can improve? Message
We’re sorry to hear that
Please explain why this article wasn’t helpful to you. Message
Thank you for your feedback!
We’ll review your message and use it to help us improve your experience.
Rate this page
Rate this page
Is there anything we can improve?

Don’t want to answer

Thank you for your feedback!
Last updated: October 20, 2021

Found a typo or other text error? Select the text and press Ctrl+Enter.

Report a problem
We always review our content. Your feedback helps us improve it.
Provide an email so we can follow up
Thank you for your feedback!