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.
|