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.
-
For more information about connecting to SaaS applications, see Conectando-se a aplicativos SAP.
-
For more information about Lite connectors, see Classificações para conectores de aplicativos SaaS.
-
Depending on your use case, you might need to install Data Movement gateway to move data from SaaS applications. For more information, see Quando o Data Movement gateway é necessário?.
Supported update methods
For more information, see Uma visão geral dos métodos de atualização de destino.
Landing tasks:
-
Change data capture (CDC)
-
Reload and compare
Replication tasks:
-
Change data capture (CDC) using Change Tables
-
Full load
Landing data in a data lake tasks:
-
Change data capture (CDC)
-
Reload
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.
Nota informativaDo 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
For more information, see Conectando-se a aplicativos SAP.
- 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 |
Selecione um Data Movement gateway se for necessário para seu caso de uso. Nota informativa
Esse campo não está disponível com a assinatura do Iniciante do Qlik Talend Cloud, pois esta não é compatível com o Data Movement gateway. Se você tiver outro nível de assinatura e não quiser usar o Data Movement gateway, selecione Nenhum. Para obter informações sobre os benefícios do Data Movement gateway e casos de uso que exigem isso, consulte Qlik Data Gateway - Data Movement. |
| 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>. Nota informativaThis 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>. Nota informativaThis 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>. Nota informativaThis 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>. Nota informativaThis 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>. Nota informativaThis 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>. Nota informativaThis 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>. Nota informativaThis 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>. Nota informativaThis 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>. Nota informativaThis 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>. Nota informativaThis field is optional, leave it empty to use pre-defined reports.
|