Connecting to Google Adwords

The ElastiCube Managerenables easy and quick access to tables contained within Google Adwords. The steps below describe how to connect to this type of data source.

Note: Importing data from Google Adwords is performed using the Sisense developer key and Sisense pays for the data imported from AdWords. For this reason your AdWords 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 AdWords 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.

  1. Click Add Data in the top menu of the ElastiCube Manager.
  2. Under the Web Services category, select Google AdWords.
  3. You will be prompted to enter the following information:
  4. Click Connect.
  5. Select the relevant client email associated with Adwords you want to work with and click OK. All tables and views associated with the website will appear in a new window.
  6. Select the checkbox next to each table you want to use.
  7. Once all relevant tables are selected, click Add.

Note about possible build failures: If you upgrade your version of Sisense to 5.8.1, and the build fails, it may be due to the fact that the newer Sisense version is using a newer version of the Google AdWords API (v201506). If this is the case, then this API version includes changes to some of the AdWords predefined columns. Consequently, it is required for you to click refresh in the ‘Change Connectivity Settings…‘ window next to your AdWords data source and rebuild your ElastiCube. Unless this action is taken, your ElastiCube build will fail due to the change in Google AdWords schema.

See also Customizing Google Analytics and AdWords Tables.

Versions

Version Release Date Description
6.5.1.15 Apirl 19, 2017 Google Adwords API v201607 supported by Sisense v6.5.1 and earlier has been deprecated