Data Connection to Google Ads

Version

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.

Driver

Driver Download

Driver Installation

Decompress the package, and install the driver to the local directory. The following figure shows the directory structure after installation.

Note:

The readme.htm file contains instructions for using the driver, which can be used for reference.

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

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.

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.