How to connect to Google Analytics in Toad Data Point

Hello. I'm Sreevani Abbaraju. I'm a product specialist in the Toad Business Intelligence's Product Management Group from Dell Software. In the last couple of videos, I have given an overview of the new features and functionality that we are introducing for our new release, Version 3.5 for Toad Data Point. One of the important features that we are releasing with this version is our ability to connect to Google Analytics directly using Toad Data Point. And this video is to show you how to access Google Analytics account using Data Point, how to get to the data, and how to work with it. Let's get started. Just like normal, this is the icon you would click to be able to make new connections. As you see, in our new interface we have grouped individual connections under different headings. Find Google Analytics underneath it. If you are an organization that has a website, and you normally monitor your web traffic using GA, Google Analytics account, then this is where you would put in those credentials, just like I am doing. You want to click Sign In. And you will be prompted with this, whether you're allowing Toad Data Point to access your Google Analytics data. When you hit Accept, you will be provided with this dialog box saying, This is the first time you are connecting to the service. Toad is analyzing the content in the background and until completed column information might be missing on some objects. What is basically happening is, because this is the first time you are connecting to this account, it's bringing in all the tables and all the objects that are in your GA data, which might take a little bit when you're doing it for the first time. For the sake of this exercise, I have previously made a connection, dragged and dropped, just like you would normally play with any other relational source, any other Excel file. This is how the data is presented to you in Google Analytics, in a familiar format so you can drag and drop, work with it in a query builder, so on and so forth. If you have data in other sources that match this Google Analytics data and you want to join those two sources, you would do it just like you would on a SQL Server database or an Oracle database that you're familiar with. Select the fields that are of interest to you, execute SQL. And that activity is triggered on your connection, and you are presented with your results set, just like I have in this example.