The Sisense Google Adwords connector enables quick and easy access to Google Adwords tables exposed by Google's API. Every 10 months, Google updates their Adwords API and deprecates older versions.
Recently, Google Adwords discontinued v201605 of their GoogleAdwords API, which was used by Sisense v6.5.1 and earlier.
As a result of Google’s changes to the Adwords API, fields CostPerConvertedClick and ConvertedClicks are no longer supported.
This affects the following tables:
- Ad Group (Report), Daily Report1
- Ad Group (Report), Monthly Report
- Geo Performance Report
- Search Query Performance, Daily Report
- Search Query Performance, Monthly Report
- Keyword, Daily Report
If you attempt to build an ElastiCube with the outdated Google Adwords connector, you will receive the following error:
AdWordsApiException: One or more AdWords API errors have occured. The api version in the request has been discontinued. Please update to the new AdWords API version. (Error: RequestError.UNSUPPORTED_
If you are importing data from Google Adwords Sisense and using Sisense v6.5.1 and earlier, you need to update the Sisense CLR Container and the Sisense Google Adwords connector.
To update Sisense:
- Download and install the Sisense CLR Container.
- Download and install the Latest Google Adwords Connector (v18.104.22.168).
After you have installed both the Sisense CLR Container and the latest Sisense Google Adwords connector, you should refresh your connection to Google Adwords as the fields CostPerConvertedClick and ConvertedClicks are no longer available.