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

Automatic subtitling for YouTube URLs

Automatically extract and create subtitles from YouTube videos using our powerful automatic subtitling and auto caption tool. Improve video accessibility, streamline subtitle recognition, and manage YouTube content effortlessly. Perfect for creators, marketers, and managers who need fast subtitle creation, accurate YouTube subtitle extraction, and automatic video captions—all in one seamless workflow powered by Bika.ai.

Coming soon

14-Day Automated Cold-Email Outreach Campaign

Launch a 14-day automated cold outreach campaign with this done-for-you email outreach template. Run a fully automated email sequence and drip email sequence for outbound email campaigns and outbound sales emails, complete with automated follow ups and lead nurturing emails. Use a clear email campaign workflow to manage automated email outreach, track engagement, and scale cold outreach to influencers, partners, and prospects—without manual follow-ups.

AI Automated Task Management

Helps teams efficiently manage weekly tasks. Through a series of automation tools, including task summaries, progress reminders, and personal summary reports, team members can promptly obtain task information and progress, thereby improving collaboration efficiency and work transparency. By using these automation features, teams can maintain efficient operations and ensure that each member has a clear understanding and sense of responsibility for their tasks.

X/Twitter Manager

An AI-powered Twitter Assistant that helps content creators draft viral tweets with auto-polish, generate tweet ideas, and schedule posts using one-click automation. Grow your engagement and effortlessly boost your Twitter follower growth.

Content Review

Efficient content review template with review automation, approval workflow, and real-time review status updates. Improve accuracy, speed up content approval, and reduce manual tasks.

Business Contract Management

Streamline your entire contract lifecycle with the Business Contract Management template. This centralized contract management system serves as an all-in-one contract database and centralized contract repository for tracking contract details, approvals, and activities. Automate key processes through a contract approval workflow and contract workflow management, ensuring accuracy, transparency, and collaboration across teams. Ideal for project contract management, this template simplifies service request tracking, reduces manual work, and improves efficiency from contract submission to expiration reminders.