Google Analytics Dashboard Extension

The “Google Analytics” dashboard extension retrieves the Google Analytics data of the site associated with your stack using the Reporting API and displays the common metrics data (such as Pageviews, New Users) and user behaviors (such as average time on a page) on your Dashboard.

This step-by-step guide explains how to create the Google Analytics Dashboard Extension for your Dashboard.

The steps to be performed are as follows:

1. Create Google Service Account Key
2. Enable Google Analytics Reporting API
3. Add User and Get View ID from Google Analytics
4. Set up a Lambda Function and an API Gateway Trigger
5. Add "Google Analytics" Extension to your Stack Dashboard
6. Use the Extension

1. Create Google Service Account Key

   In order to use this extension, you will need your Google Service account key. Google Service accounts let you fetch (or automate fetching of) your site’s Google Analytics data.

   Follow the steps below to create google service account key.

   1. In case you don’t have a Service Account, you can create a Google service account. Make sure you create a Service account that is not assigned any role.
   2. Now that you have a Service Account, create a new Service account key. You need to select JSON when setting the key type.
   3. Open the JSON file in a JSON editor, and note down the client_email value.
      
   4. You will need this email address in Step 3 while configuring your Google Analytics account. You will also need the complete JSON code in Step 4 while configuring the Lambda function of your extension in Contentstack.

2. Enable Google Analytics Reporting API

   To enable the Google Analytics API, perform the steps given below:

   1. Go to your project’s API Dashboard page in Google Cloud Platform.

   2. Click on the ENABLE APIS AND SERVICES button on the top.

      
   3. In the search bar of the API Library page, type and select Google Analytics Reporting API 

   4. Click on the ENABLE button.

      

   Next, we need to add a user and get the View ID.

3. Add User and get View ID from Google Analytics

   A - Add new user and assign permission

   After logging in to your Google Analytics account, perform the steps given below:

   1. Click on Admin at the bottom on the left navigation panel 

   2. Click on Account Access Management.
      

      

   3. In the Account access management page that opens, click on + (Plus icon) at top-right corner and select Add users.
   4. In the Add roles and data restrictions page, enter the client email address that you retrieved in Step 1 within the JSON file and set the Standard roles and Data restrictions. 
      
      
   5. Finally, click on the Add button.

   B - Retrieve the View ID

   Navigate to the Admin page. Under the View section, click View Settings.

   

   On the View Settings page, copy the value given under View ID. We will use the View ID while setting up the extension in Contentstack.

   

4. Set up a Lambda Function and an API Gateway Trigger

   Download the Lambda function from GitHub. It contains all the required files. Then, navigate to your lambda function folder through a Terminal and install npm:

   npm install
   

   This downloads the required node modules within your lambda function. Now, open the service_account.json file within your lambda function folder and replace the existing content with the JSON content of the Service Key file that you extracted in Step 1. After that, zip your project file.

   Note: If you are using Linux, use the zip -r index.zip * command in your root folder to zip the file.

   Now, follow the steps below to set up the lambda function and an API gateway trigger. 

   1. Login to your AWS Management Console, select Lambda from the Service list.
   2. Click on the Create function button, and then the Author from Scratch option.
   3. Provide a name to your lambda function inside the Function name field, select Node.js 14.x or any other version of Node as your Runtime language, and click on the Create function button.
   4. Upload the lambda file (as a zip file) by scrolling down to the Actions dropdown (in the Function code section) and selecting Upload a .zip file
   5. Keep Handler as index.handler and click on Save.
   6. Save your settings. Your lambda function is now ready.
   7. Scroll up to the Designer section and click on + Add trigger.
   8. On the Add trigger screen, from the Select a trigger dropdown, select API Gateway.
   9. Select Create an API, from the API dropdown. Then, select REST API inside the API type block, select Open from the Security dropdown, and click on Add.
      
   10. An API is created for your lambda function. Under the Designer block, click on API Gateway. Click on Details and you will find your API endpoint. Make a note of it as we will need it while setting up the Google Analytics extension in Contentstack.
   11. For additional security, you can configure an API Key for the API Gateway trigger and use this API Key when configuring your lambda function.
   12. Lastly, Enable CORS in Amazon API Gateway console. It is mandatory for successful implementation of this extension.

5. Add Google Analytics Extension to your Stack Dashboard

   To add the Google Analytics extension, log in to your Contentstack account and perform the following steps:
   1. Go to your stack and click on the “Settings” icon on the left navigation panel.
   2. Click on Extensions
   3. Click on the + New Extension button on the top-right corner and select Create new
      
      
   4. On the Select Extension Type page, select Dashboard Extension. You will be directed to the Create New Dashboard page where you need to enter details in the fields as given below:
      1. Title: Provide a suitable title. For example, Website Analytics.
      2. Default width: Select Half Width.
      3. Hosting method: Select Hosted by Contentstack. As soon as you do this, you will see the Extension source code field below.
      4. External source code: In this field, you need to enter the extension code. Download the source code for the extension from Github.
      5. Config parameters: Enter the configuration details for the extension. Here, you need to mention the view ID that you retrieved and the AWS API gateway URL for the lambda function. If you have enabled API key for secured access, you need to mention that too.
         

         {
             "url": "https://abcde1234.execute-api.
                 us-east-1.amazonaws.com/default/
                 contentstack-google-analytics-extension",
             "view_id": "111111111",
             "x-api-key": "SSS111Sss1ssSSsssS11s11SS11SS"
         }

         • "url": Add the AWS API gateway URL for the lambda function that you noted in the last step.
         • “view_id”: Mention the view ID that you retrieved from Google Analytics in step 2. 
         • “x-api-key”: Add the API key for secured access if you have enabled it in step 3.
           
      6. Enable dashboard extension: Select this option to ensure all stack users are able to view the Google Analytics extension on their respective screens.
   5. Click Save to create your custom dashboard extension.

6. Use the Extension

   Once you have added your Dashboard Extension, navigate to the Dashboard by clicking on "Dashboard" button at the top, on the left navigation panel.

   You should be able to see the Google Analytics extension added to your Dashboard

   Note: Make sure that the URL that you provide is live.

   You can view the analytics data of the last 1, 7, 15, 30, 180, or 365 day(s). Default value is 30 days.