Connecting to Google Ads

Applicable to Sisense on Linux and Microsoft Windows

Sisense enables easy and quick access to tables contained within Google Ads. The steps below describe how to connect to this type of data source.

Note: Google Ads (formerly Google Adwords) for Linux is supported from Sisense v7.4.3.

Note: Importing data from Google Ads is performed using the Sisense developer key and Sisense pays for the data imported from Ads. For this reason your Ads account must have access to the ‘Campaign Service’ and the user needs to have Standard Access. To check the type of access, log into your Ads account, then go to My Account > Account Access. A list of all associated campaigns and permission levels will be displayed. Increasing the permission level can only be performed by a campaign administrator using the “invite user functionality”. See Campaign Management and Users for more details. In addition, you will need an MCC account. For more information, click here.

Note: If you are connecting to a Google service remotely, and the address of Sisense is something other than localhost, Google requires that you connect using the OAuth 2.0 protocol. See Google Authentication for more information. If you are on a Linux deployment, see Google Authentication in Linux.

Note: For the list of supported connectors, see Introduction to Data Sources.

To import Google Ads data:

  1. In the Data page, open an ElastiCube model or click to create a new ElastiCube model.
  2. In the Model Editor, click . The Add Data dialog box is displayed.
  3. In the Add Data dialog box, select Google Ads.
  4. In Customer ID, enter your Google Ads Customer ID.
    To find your customer ID, click here.
  5. Click Sign in with Google and enter your email, and then select Next to enter your password. If you have multiple accounts, select the account that has the Google Ads data you want to access and enter the password, if you're not already signed in. You must be signed out of all other Google accounts.
  6. Click Accept to allow your Sisense Server to access your Google Ads data.
  7. Close the browser window when notified to do so.
  8. Click Next. All tables and views associated with Google Ads are displayed.
  9. From the Tables list, select the relevant table or view you want to work with. You can click next to the relevant table or view to see a preview of the data inside it. When you select the table or view, a new option Add Import Query is displayed at the bottom of the list.
  10. (Optional) Click + to customize the data you want to import with SQL. See Importing Data with Custom Queries for more information.
  11. After you have selected all the relevant tables, click Done. The tables are added to your schema.

Note: When connecting to Google Ads, it's best practice to use Quick Access because it uses your existing Google connection token (Google imposes of limit of 50 connection tokens).