Google Analytics Skillset Guide

Table of Contents

• Google Analytics Skillset Guide
  • Table of Contents
  • Overview
  • Setup
    • Step 1: Get Google Analytics Credentials
    • Step 2: Configure the Skillset
    • Step 3: Enable Required Skills
  • Usage Examples
    • 1) Get Report
    • 2) Get Active Users Data
  • Q&A

Overview

The Google Analytics Skillset is a collection of tools connected to your Google Analytics account. By enabling this skillset, the AI agent can access your website data through Google Analytics and generate analytical reports, making it easier for you to understand your website behavior.

The current skillset includes the following skills:

• Get Custom Report: Customizable Google Analytics reports where you can specify metrics and dimensions to get custom Google Analytics reports (metrics and dimensions can be specified)
  • Parameter Description:
    • propertyId (required): Google Analytics Property ID (e.g.: 42XXXXX01)
    • startDate (required): Start date (format: YYYY-MM-DD)
    • endDate (required): End date (format: YYYY-MM-DD)
    • dimensions (optional): Query dimensions (e.g.: country, city, pagePath, sessionSource)
    • metrics (required): Query metrics (e.g.: activeUsers, active1DayUsers, active7DayUsers, active28DayUsers)
    • limit (optional): Limit the number of results, default is 50

📌 Tip: For more dimensions and metrics, please refer to the Google Analytics API documentation.

• Get Active Users Data: Get active user data (1 day, 7 days, 28 days)
  • Parameter Description:
    • propertyId (required): Google Analytics Property ID (e.g.: 42XXXXX01)
    • startDate (required): Start date (format: YYYY-MM-DD)
    • endDate (required): End date (format: YYYY-MM-DD)
    • limit (optional): Limit the number of results, default is 50

Setup

The Google Analytics Skillset relies on Google Cloud service account credentials (Google Credentials). Please follow the steps below to configure:

Step 1: Get Google Analytics Credentials

1. Visit the Google Cloud Console and sign in or create an account.

2. Create a new project or select an existing one.

3. Enable the Analytics Data API:

   • In the Google Cloud Console, go to "APIs & Services" > "Library"
   • Search for "Analytics Data API"
   • Click it and press "Enable"

4. Create a service account:

   • Go to "IAM & Admin" > "Service Accounts"
   • Click "Create Service Account"
   • Give it a name, such as "bika-analytics", then click "Create"
   • Assign the "Viewer" role, click "Continue" then "Done"

5. Create and download credentials:

   • Click your new service account
   • Go to the "Keys" tab
   • Click "Add Key" > "Create new key"
   • Choose "JSON" and click "Create"
   • Save the downloaded JSON file securely

6. Grant permissions in Google Analytics:

   • Go to Google Analytics
   • Click "Admin" (gear icon)
   • Select the account containing the property whose data you want to access
   • Under the "Account" section, select "Account Access Management"
   • Click the "+" button and add the service account email (from the client_email field in the JSON file)
   • Assign "Viewer" permissions

7. Get your Google Analytics Property ID:

   • In Google Analytics, click "Admin" (gear icon)
   • Select "Property" > "Property details"
   • Copy the "PROPERTY ID: 42XXXXX01" for use later in conversations with AI or in prompts (see step 2 for example).

Step 2: Configure the Skillset

1. Return to the Google Analytics skillset configuration page in Bika.
2. Paste the entire JSON credential content into the Google Credentials field.
3. Click Connect to complete the credential configuration.
4. Enter the Property ID in the System Prompt, or enter the Property ID directly during conversation.

⚠️ If the setup process feels complex, you can also refer to the Google Analytics Agent template documentation for more detailed operation examples.

Step 3: Enable Required Skills

• On the skillset configuration page, enable the required functions via toggle switches
• Multiple skills can be enabled simultaneously
• Click Save to take effect

Usage Examples

1) Get Report

Have the AI generate a custom analytics report:

Example prompt: "View total users"

metrics: totalUsers is the total number of users. Telling the AI directly can avoid potential errors, which depends on the LLM's understanding of Google Analytics.

Example prompt: "Analyze page views and sessions by country for the past month"

metrics: screenPageViews, sessions

📌 Tips:

• Property ID: Unique identifier, such as 42XXXXX01, can be specified in the prompt.
• dimensions: e.g., country, date, city, adUnitName.
• metrics: e.g., sessions, screenPageViews, activeUsers, totalUsers.
• For more dimensions and metrics, please refer to the Google Analytics API documentation.

2) Get Active Users Data

Have the AI fetch user activity metrics:

Example prompt: "Show active user count"

Q&A

Q: What should I do if the connection fails? A: Check if the JSON was pasted completely, if extra symbols were added, or if the service account email has been configured with permissions.

Q: What should I do if the function is unavailable? A: Confirm that the corresponding skill has been enabled and saved on the configuration page.

Q: What should I do if the call is restricted? A: Google Analytics API has rate limits. Too many requests may trigger restrictions; try again later.

Recommend AI Automation Templates

ADDIE Instructional Design Model

Use the ADDIE Instructional Design Model as a practical instructional design template to manage your entire course development process. Plan and track e‑learning content development, instructor‑led training design, and training materials development for professional skills courses and employee training programs. This template helps instructional designers, training developers, and education project managers organize tasks, align learning objectives, and streamline course creation for any organization.

Bank Statement Attachment to Database

Manually upload a PDF attachment of the bank statement, use image recognition technology to extract the total expenditure and stock data, and generate data records into the Bika database

Coming soon

AI VAT Invoice Information Recognition (China)

This AI VAT Invoice Information Recognition (China) template uses Baidu AI Cloud to deliver AI invoice extraction and end‑to‑end invoice workflow automation for Chinese VAT invoices. Automatically recognize key fields, verify invoices, and write results into your database to streamline financial data management. Support supplier invoice processing and purchase order invoices in the same flow, reducing manual input, lowering error rates, and helping finance teams, SMEs, accountants, and procurement departments keep VAT invoice records accurate, searchable, and audit‑ready.

Requirements Document Writer

Create professional requirements documents instantly with AI. Generate complete requirements templates, project requirements, and user requirements with detailed acceptance criteria and product specifications. Perfect for product managers and project teams.

Base Missions Summary Reminder Daily

Summary one's in a day and send a reminder daily

Automated Birthday Email Celebration

Automate birthday email automation with the Automated Birthday Email Celebration template. Send personalized, automated birthday emails using a flexible birthday email template and automated email template that work with your customer data integration. Use this email scheduling tool to set automated email reminders and schedule birthday marketing emails at the perfect time. Boost customer retention emails and loyalty with B2B email automation and an email personalization tool that delivers timely, relevant birthday email campaigns without manual work.