Google Adwords to Snowflake-Data Ingestion

 Created on – 10/29/2018
Modified on


Overview


The Google Adwords is an online advertising platform. Google displays brief advertisements of its clients to get customers for their products and services. It uses partly cookies and partly the keywords to segregate and place these advertisements on pages that it determines are relevant. Google is paid if users divert their browsing to click on these advertisements.
The Diyotta Adwords software reads data from Google and uploads it to Snowflake. It uses dimensions and metrics to analyze and upload data.



Explained below are the steps to use the Google Adwords features of Diyotta:


  1. Creating Data Point
  2. Importing Data Object
  3. Creating a Data Flow


Creating Data Point


To create a Data Point for Google Adwords:

1. Log in to the Diyotta URL using your User Id and Password.

2. Click New Data Point.


3. Click Google Adwords.


4. Click Properties in the above screen.


5. In the Customer Client ID, Scope, OAuth Client ID, OAuth Client Secret, Developer Token, and CallbackURL fields enter required information.


6. Click Save.

7. Click Test DataPoint. The following login page appears.



Note: Enable popups because the login page may not appear if the popup blockers are on.

8. Enter your User Id and Password.


9. Click Allow. The following message appears.


10. Click Close.

11. From the Action menu, click Refresh.


12. The Access Token and Refresh Token fields are automatically generated, as highlighted in the following screen.







Importing Data Object


The next step is to import a Data Object. To import it, follow the below given steps:

1. In the home screen, click Data Object.


2. From the right menu, click Import Data Object.


3. Click the Data Point name that you want to import.


4. Click Next.


5. Select the Data Object names that you want to import.


6. Click Import.



Creating a Data Flow


To create a Data Flow, follow the below given steps:

1. From the left menu, click Data Flow.

2. From the Action menu, click New Data Flow.


3. Click the Data Point name.


4. From the right menu bar, under Source, click and drag a data source name to the canvas area.


5. Select the Data Object name.


6. Click Ok.

7. Select the source name in the canvas area and then click Create as Target, as highlighted in the following screen.



  • The following screen appears.


8. Expand the Data Point name and then select the Data Object.


9. Under the Action menu, click Save.


10. Click Run. The following screen appears.



Note: To check the status of execution, navigate to the Monitor module as highlighted in the below screen.

A successful execution is displayed in a similar manner as the below given screen.


Adding Diyotta as redirect URL in Google Account after authentication


After connection is established, the next step is to add our URL as the redirect URL in Google Account. Follow the below given steps to accomplish this task:

1. Open an explorer and enter "https://console.developers.google.com" in the address bar.


2. Click Credentials.


3. Under Create Credentials, select OAuth Client ID.



  • The following screen appears.


4. Select Web application, enter application name in the Name field, and then click Create.



  • The following screen appears.


5. Click Ok.

6. On the home screen, click OAuth Consent Screen.


7. Under Authorized domains, enter diyotta.com and then click Save.

8. Under Credentials, click the Diyotta link as highlighted in the following screen.


9. In Authorised redirect URLs, add "https://ditechstyle.diyotta.com" and then click Save.