Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Benjamin_Qlik
Contributor
Contributor

Failure - Qlik Google AdWords Connector - Invalid Customer ID - Only zero values

Hi there,

I tried to set up the Qlik Web Connector for Google AdWords today.

This ran smoothly until a report query was set up.
The customer id field is mandatory here.

But there are no values ​​that can be selected in the drop-down menu. Just
"the value must not be NULL. Parameter name: source" can be selected.
However, this entry is invalid and loading is not possible.

Please help.

Thank you in advance!

 

Benjamin_Qlik_0-1640686958613.png

 

Labels (2)
1 Solution

Accepted Solutions
Benjamin_Qlik
Contributor
Contributor
Author

Many thanks for the answer.

I've now more or less solved the problem.

The reason was that the user is a multi-user for several companies.

I have created a new Google Account with permissions for only one customer.

That worked and now this customer can be selected.

So it was due to the permissions of the Google user.

View solution in original post

4 Replies
chrisbrain
Partner - Specialist II
Partner - Specialist II

Hi - Does the Google user that you used to authenticate with the connector definitely have access to the customer you would like to run the query for?

Could you check the QWC log files to see if there are any entries which might point to the underlying cause?

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
Benjamin_Qlik
Contributor
Contributor
Author

Many thanks for the answer.

I've now more or less solved the problem.

The reason was that the user is a multi-user for several companies.

I have created a new Google Account with permissions for only one customer.

That worked and now this customer can be selected.

So it was due to the permissions of the Google user.

chrisbrain
Partner - Specialist II
Partner - Specialist II

OK great - glad you sorted it out!

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
ReportingImpulsion
Contributor II
Contributor II

Hi Benjamin, I just saw this, yes, you are right, we had the same issue some time ago, you need to setup an Googlge Ads account , the Ad Manager account (former MCC) doesn't work with this connector. Then it is sufficient to grant access on the "Read-Only" access level in the account.

BUT: Do you know, the AdWords API will be discontinued by Google by April 27, 2022? We cannot get any information from Qlik, how they will treat it in the future.

Actually, by then the Google AdWords API needs to be migrated to the Google Ads API. The AWQL scripts have to change to GAQL. 

We are a little lost and don't have any information on this.