Google Analytics is a web analytics service offered by Google that tracks and reports website traffic. It also lets you measure you advertising ROI as well as track your Flash, Video, and social networking sites and applications.

Let's see how can you integrate Google Analytics to Stackby.

In this article, we will see the following:

  1. How to integrate Google Analytics
  2. Available API Functions

How to integrate Google Analytics

Integration of Google Analytics to Stackby is very easy just follow these simple steps.

Step 1: Connect to your Google Analytics account and name your connection

Step 2: Go to your Google Analytics account → Admin

Step 3: Bring your view ID for which you need information

Step 4: Add your view IDs in the table, along with start and end dates to bring information

Next Steps...

Now that you have set up the integration, here is how you bring Google Analytics data:

  1. Create a stack in the Workspace or go to the stack, and keep the first column or any column as the reference (here it will be the String).
  2. In the second column, connect to the Google Analytics and rename the column, select "API" as the column property, and choose Google Analytics as the API, and Select an API from your Account, and within that Select a Service and then Select the reference column as required. There, you have now integrated your API with a column.
  3. Add in the string in the first/primary column, click on the refresh arrow and the API will work on the stack. The data will start filling in the consecutive columns (decide which data you want to access by selecting it from our data explorer). Make sure you change the column names and property beforehand; repeat with other columns.

This is how it will finally look -

This is how it will look when you have finished setting up data explorer -

Note: We’re also going to be adding ‘dimensions’ for more filtered data in the near future.

Available API Functions

Get users by View ID 
Reference Input column: View ID and start-end dates
Output: Count of Users, New Users, Sessions and Sessions per user

Get sessions by View ID
Reference Input column: View ID and start-end dates
Output: Count of Sessions

Get traffic by View ID
Reference Input column: View ID and start-end dates
Output: Count of Organic search traffic

Get pageviews by View ID
Reference Input column: View ID and start-end dates
Output: Count of pageviews
Did this answer your question?