Skip to content
Clarisights Knowledge Center home
InboxAsk a human

Importing Data to Custom Advertising Channels from Different Sources

This article covers the sources you can use to send data to a Custom Advertising Channel: CSV upload, Mail, Google Sheets and Google BigQuery. To learn how to set up a Custom Advertising Channel, see Getting Started With Custom Advertising Channels.

Uploading a CSV

  1. Select CSV in the source type dropdown menu.

  2. Add the source, currency and timezone of this Advertising Channel, then click Connect Source.

  3. Back on the custom advertising channels page, click Upload CSV to upload your file.

Once the CSV has been uploaded, the data starts being imported into Clarisights.

Important: when CSV is the source type, identical data is appended, not overwritten. If you upload the same file twice, the numbers double up on the dashboard.

Sending CSV through mail

  1. Select Mail in the source type dropdown menu.

  2. Add the source, currency and timezone of this Advertising Channel, then click Connect Source.

Once the channel has been created, a unique email address is generated. You can find it under the default account, as shown in the clip below.

Send the CSV from the advertising channel to this email address and your data starts flowing into Clarisights.

Importing data to Custom Advertising from Google Sheets

See Connecting Google Sheets to Clarisights.

Importing data to Custom Advertising from Google BigQuery

Select Google BigQuery in the source type dropdown menu and enter the BQ Project, BQ Dataset and BQ Table to read. Clarisights needs read access to the table first; see Integrating Google BigQuery on Clarisights.

If you still have trouble fetching data from your source, write to us at support@clarisights.com.