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

Event contacts management

Easily manage event contacts, track professional connections, and build your own personal CRM with this event CRM template. Log contact details, meeting notes, follow-up reminders, and attendee information all in one place. Ideal for networking events, conferences, and long-term relationship management. Boost your efficiency with an intuitive contact tracker and event workflow system.

Diary reminder

Keep your thoughts organized with this Diary Reminder Template. Track daily writing, manage your diary entries, and receive automated nightly reminders. Generate weekly summary reports to review your life logging progress, enhance self-reflection, and maintain consistent journaling habits. Perfect for personal diary management, writing tracking, and improving productivity.

AI Auto-Tweet with Image

Automate your X (Twitter) content with the AI Auto-Tweet with Image template. Use it as a Twitter post scheduler and Twitter automation tool that reads tweet content from your database, generates tweets with AI, uploads images, and auto-posts to X. Batch pre-write tweets, update their status to Publish, and let the workflow handle tweet scheduling, posting, and link tracking—perfect for social media managers, creators, and brands who want consistent Twitter activity without manual posting.

Customer Support Scribe

Customer Support Scribe is an AI tool designed to automate customer support and improve AI customer communication. It works as an FAQ generator and SOP generator, streamlining helpdesk automation with professional, ready-to-use support templates for teams.

AI Programmer

Transform your ideas into ready-to-publish HTML pages with AI Programmer by Bika.ai. Create stylish, professional web pages instantly — no coding required.

Digital Marketing Strategy

Use this Digital Marketing Strategy template to streamline project collaboration, progress tracking, and marketing roadmap planning across your team. Keep campaign planning, marketing tasks, and project notes organized while automating reports to stay aligned and monitor progress status in real time. Ideal for teams seeking clarity, consistency, and execution efficiency.