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

AI Project Issues and Tickets

Use the AI Project Issues and Tickets template as a complete issue tracking template and AI-powered project ticket system for product and project teams. Collect bug tickets, customer support tickets, and feature request form submissions in one place, and manage ticket prioritization and status updates with automated notifications. Every week, an AI summary report aggregates all requests and bugs, giving project managers, product owners, QA engineers, customer support, and business analysts clear insights into user feedback, development progress, and your overall AI project workflow.

AI Batch Image Recognition(OpenAI gpt-4o)

Extract text from multiple images at once with Bika.ai's AI Batch Image Recognition. Supports OpenAI gpt-4o, batch processing, and automated image recognition for fast, accurate results.

Automated Currency Data Retrieval (Python)

The Automated Currency Data Retrieval (Python) template runs a scheduled job to fetch specific currency rates every day and store them in a structured table, building clean historical exchange rate data over time. Use it for financial data automation that powers dashboards, alerts, and automated financial reporting, so finance teams, forex traders, accountants, and risk managers always have up-to-date FX data at hand. By automating data collection, you save time, reduce manual errors, and make better investment and risk decisions based on reliable exchange rate history.

AI Writer

Tell me about the AI product or brand — I’ll draft engaging marketing copy, articles, and social media posts tailored to your brand voice and product details, complete with relevant links and illustrations.

Batch generation of HeyGen AI videos

Quickly generate high-quality HeyGen AI videos with batch generation and automated video workflow. Customize characters and voices, streamline video creation, and save time.

Office Docs Helper

Create professional business, internal, and HR documents with AI. Instantly generate announcements, reports, and forms to boost office productivity.