Overview
Version
| FineBI Server Version | JAR Package Version | Functional Change |
|---|---|---|
6.0 | - | Add support for Google Ads data linking. |
Function Description
Google Ads is an online advertising solution provided by Google. With a Google Ads account, you can customize your budget and target for advertisement placements, and analyze the effectiveness of ads through metrics such as exposure, click rates, and costs. This document introduces how to connect to Google Ads with the CData driver in FineBI.
Preparation
Driver
Driver Download
| Install Driver | Download Address |
|---|---|
Choose the appropriate installation package for different system environments such as Windows/Cross-Platform Unix/Linux/Mac and download it. |
|
Driver Installation
Decompress the package, and install the driver to the local directory. The following figure shows the directory structure after installation.
Note:Driver Login
The CData driver provides a one-month free trial. Continued use afterward requires payment.
The following figure shows the generated lib directory.
Copy the files from the lib directory to D:\FineBI_6.0\webapps\webroot\WEB-INF\lib in the FineReport project, as shown in the following figure.
Connection Information Collection
Basic Parameter
| Parameter Name | Description |
|---|---|
Customer ID (clientCustomerld) | Customer ID is the account associated with your Google Ads customer account. This ID is automatically generated during the registration, following the template below.
|
developerToken | With a developer token, you can access the Google Ads API and perform the following operations: 1. Issue requests to all Google advertising accounts with the same developer token. 2. Log in to your manager account with the developer token and navigate to the API Center page. |
Fitting Method
Customer ID: Click https://ads.google.com/home/tools/manager-accounts/ to register/login to your Google account and obtain the ID.
Developer token: Access the Google Ads API center to obtain it. The following figure shows the obtaining location.
Connection Procedure
Testing Connection with CData's Test Connection Tool
1. In the driver's installation directory, directly execute the java -jar cdata.jdbc.googleads.jar file to open the test connection window provided by CData and enter the relevant information.
2. After the successful connection test, copy the link information of Connection String at the bottom of the page, for example, googleads:AuthScheme=OAuth;DeveloperToken=(developer token);ClientCustomerId=xxx-xxx-xxxx (customer ID);InitiateOAuth=GETANDREFRESH.
Previous：Data Connection to YouTube
