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.
-
Необходимо установить Data Gateway — Data Movement для поддержки промежуточного хранения или репликации данных из приложений SaaS. Для получения дополнительной информации см. раздел Qlik Data Gateway — Data Movement.
Поддерживаемые методы обновления
Для получения дополнительной информации см. раздел Обработка изменений.
Задачи промежуточного хранения:
-
Захват изменений данных (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 |
Выберите шлюз Data Movement 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.
|