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