Google Ads
Google Ads is the advertising platform of Google. You can use Google Ads as a data source when landing or replicating data.
You can leave all custom report fields empty to use pre-built reports.
-
有关连接 SaaS 应用程序的更多信息，请参阅连接到 SaaS 应用程序。
-
必须安装 数据移动网关 才能移动 SaaS 应用程序中的数据。有关更多信息，请参阅Qlik 数据网关 - 数据移动。
支持的更新方法
有关更多信息，请参阅更改处理。
登陆任务：
-
更改数据捕获 (CDC)
-
重新加载并比较
复制任务：
-
使用变更表更改数据捕获 (CDC)
-
满负载
在数据湖任务中登陆数据：
-
更改数据捕获 (CDC)
-
重新加载
Preparing for authentication
To access your Google Ads data, you need to authenticate the connection with your account credentials.
Create a client ID and a client secret
Create credentials for a web app OAuth client ID in Google Cloud Console.
-
Add https://connector.qlik.com/auth/oauth/v3.htm as an Authorized redirect URI.
-
Click Create.
Creating custom querys
You can create GAQL querys to use as custom queries in the connection with Google Ads Query Builder.
-
Select the resource to use.
-
Select your attributes.
信息注释Do not make changes in the other sections (WHERE, ORDER BY, LIMIT, PARAMETERS).
A GAQL query is created in the form SELECT <attributes> FROM <resource>.
Click the copy icon and paste this query in the Custom Query fields.
Creating the connection
- Fill in the required connection properties.
-
Provide a name for the connection in Connection name.
-
Select Open connection metadata to define metadata for the connection when it has been created.
-
Click Create.
| Setting | Description |
|---|---|
| Data gateway |
选择要在复制数据时使用的 数据移动网关。 |
| Client ID |
OAuth Client ID that you created. |
| Client Secret | OAuth Client secret that you created. |
| Ad Account Id |
The account id for the Google Ads account that you want to load data from, without hyphens. Example: If the account ID is 123-456-7890, set Ad Account Id to 1234567890. |
| Ad Manager Account Id |
The account id for your Google Ads manager account, without hyphens. If you are not using Google Ads manager, provide your ad account id again in this field. Example: If the account ID is 123-456-7890, set Ad Manager Account Id to 1234567890. |
| Start Date | Start date for the reporting period you require in the format YYYY-MM-DD. |
| Custom Query One |
Custom query in the form of a GAQL query in the form of SELECT <attributes> FROM <resource>. 信息注释This field is optional, leave it empty to use pre-defined reports.
|
| Custom Query Two |
Custom query in the form of a GAQL query in the form of SELECT <attributes> FROM <resource>. 信息注释This field is optional, leave it empty to use pre-defined reports.
|
| Custom Query Three |
Custom query in the form of a GAQL query in the form of SELECT <attributes> FROM <resource>. 信息注释This field is optional, leave it empty to use pre-defined reports.
|
| Custom Query Four |
Custom query in the form of a GAQL query in the form of SELECT <attributes> FROM <resource>. 信息注释This field is optional, leave it empty to use pre-defined reports.
|
| Custom Query Five |
Custom query in the form of a GAQL query in the form of SELECT <attributes> FROM <resource>. 信息注释This field is optional, leave it empty to use pre-defined reports.
|
| Custom Query Six |
Custom query in the form of a GAQL query in the form of SELECT <attributes> FROM <resource>. 信息注释This field is optional, leave it empty to use pre-defined reports.
|
| Custom Query Seven |
Custom query in the form of a GAQL query in the form of SELECT <attributes> FROM <resource>. 信息注释This field is optional, leave it empty to use pre-defined reports.
|
| Custom Query Eight |
Custom query in the form of a GAQL query in the form of SELECT <attributes> FROM <resource>. 信息注释This field is optional, leave it empty to use pre-defined reports.
|
| Custom Query Nine |
Custom query in the form of a GAQL query in the form of SELECT <attributes> FROM <resource>. 信息注释This field is optional, leave it empty to use pre-defined reports.
|
| Custom Query Ten |
Custom query in the form of a GAQL query in the form of SELECT <attributes> FROM <resource>. 信息注释This field is optional, leave it empty to use pre-defined reports.
|