Google Analytics

Avatar

By Deepak Agarwal

updated 2 days ago

Google Analytics is a web analytics service offered by Google that tracks and reports website traffic. It also lets you measure your 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:

How to integrate Google Analytics

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
Get active User from your analytics account
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
Get sessions based on View ID
Reference Input column: View ID and start-end dates
Output: Count of Sessions 

Get traffic by View ID
Get active user from your analytics account
Reference Input column: View ID and start-end dates
Output: Count of Organic search traffic 

Get pageviews by View ID
Get pageview from your analytics account
Reference Input column: View ID and start-end dates
Output: Count of pageviews

Get Google Adwords data by View ID
Get Google Adwords data by View ID
Reference Input Column: View ID and start-end dates
Output: Adwords information (Impressions, Clicks, CTC, CPM etc.)

Did this answer your question?