About connectors

In Data Studio, a connector is:

The mechanism by which a data source accesses a specific type of data set.

Connectors link the underlying data set to a data source. You can use connectors built by Google, as well as connectors built by third party developers. Connectors provide the authentication protocol needed to access the data, and determine what fields are available in data sources that use the connector.

TAKE ME TO THE CONNECTORS

How connectors work

Connectors are the "pipes" that allow a Data Studio data source to access the information stored in your data sets. Data Studio supports a number of connectors provided by Google. You can also use and create 3rd party connectors via the Community Connectors program.

Authorization

Connecting to a data set requires you to authorize your access to that data. Creating a data source using a particular connector never grants direct access to that data to other people. And once you've created a data source, only you (the owner) can edit that connection. You can remove authorization  from Google-provided connectors at any time.

Types of connectors

There are 2 types of connectors: fixed schema, and flexible schema. The details are mostly transparent to you, but keep in mind the items in the notes section below.

Connector Type Fixed schema Flexible schema
Description Used for data sets where the set of fields is well-defined. A data source created with a schema-based connector has a predictable set of fields, with pre-set field types. Connects to data sets where the structure of the data can't be known beforehand.
Data Sets Supported
  • Google Ads
  • Attribution 360
  • Campaign Manager
  • Google Analytics
  • Search Console
  • YouTube
  • BigQuery
  • File upload
  • Firebase
  • Google Cloud Storage
  • Google Sheets
  • *SQL
Notes

Data Studio supports a subset of fields for certain connectors. See the connector reference articles for details.

Metrics in these data sets are often pre-aggregated. Their aggregation type is set to AUTO and can't be changed

Also, ratio metrics, such as Click-Through Rate and Conversion Rate, are already calculated by the time they get to Data Studio; trying to use them in combination with other fields that would require recalculation is not allowed.

You may need to adjust the type and aggregation properties for fields in API-based data sources. In particular, make sure that any date fields are properly typed as dates, and not as text or numbers.

 

About data sources

Was this article helpful?
How can we improve it?