Query Agentforce Coworker Usage and Adoption Data in Data 360

Measure Agentforce Coworker adoption by querying the AI Agent Generative AI Usage data model object (DMO) in Data 360. Find active users, adoption rate, and usage trends, or build a Data 360 report.

REQUIRED EDITIONS AND PERMISSIONS
Available in:Enterprise, Unlimited, and Agentforce 1 Editions
To query Agentforce Coworker usage data in Data 360:See permissions table in Create and Run Queries in Query Editor.

The AI Agent Generative AI Usage DMO (AiAgentGenerativeAiUsage_std__dlm) records each Agentforce Coworker request with the user ID and a timestamp. To filter for Agentforce Coworker, use GenAiGatewayFeatureName__c = 'AgentforceCoworker'.

Build a Data 360 Report on Agentforce Coworker Usage 

  1. Create a Data 360 report with the AI Agent Generative AI Usage report type.
  2. Add a filter where Feature Name equals AgentforceCoworker.

The AI Agent Generative AI Usage DMO includes user IDs but not user names, and Data 360 reports don’t support joined reports. To group a report by user name, create a data transform that joins the AI Agent Generative AI Usage DMO with the User DMO. Write the output to a custom DMO, and then build the report on the custom DMO.

Note

To see what your users ask Agentforce Coworker, query the Einstein Audit and Feedback DMOs. See Review Agentforce Coworker Prompts and Responses in Data 360.

Query Agentforce Coworker Usage in Query Editor 

  1. In Data 360, open Query Editor.
  2. Enter one of the example queries in this topic.
  3. Run the query.

Example Queries for Agentforce Coworker Adoption 

Track Agentforce Coworker Usage by User and Date 

Count Agentforce Coworker requests for each user on each day.

1-- Agentforce Coworker Usage by User by Date
2SELECT
3    "UserId__c",
4    CAST("Timestamp__c" AS DATE) AS "UsageDate",
5    COUNT(*) AS "QueryCount"
6FROM "AiAgentGenerativeAiUsage_std__dlm"
7WHERE "GenAiGatewayFeatureName__c" = 'AgentforceCoworker'
8GROUP BY "UserId__c", CAST("Timestamp__c" AS DATE)
9ORDER BY "UsageDate" DESC, "QueryCount" DESC

Track Agentforce Coworker Usage by Date 

Count Agentforce Coworker requests for each day across all users.

1-- Agentforce Coworker Usage by Date
2SELECT
3    CAST("Timestamp__c" AS DATE) AS "UsageDate",
4    COUNT(*) AS "QueryCount"
5FROM "AiAgentGenerativeAiUsage_std__dlm"
6WHERE "GenAiGatewayFeatureName__c" = 'AgentforceCoworker'
7GROUP BY CAST("Timestamp__c" AS DATE)
8ORDER BY "UsageDate" DESC, "QueryCount" DESC

Calculate the Agentforce Coworker Adoption Rate 

Find the percentage of licensed users who made at least one Agentforce Coworker request. Replace 200 with your licensed seat count in both places.

1-- What share of the people I've licensed are actually using Agentforce Coworker?
2SELECT
3    200                                                        AS total_licensed_users, -- replace with your actual seat count
4    COUNT(DISTINCT UserId__c)                                  AS active_users,
5    ROUND(
6        COUNT(DISTINCT UserId__c) * 100.0 / 200             -- replace with your actual seat count
7    , 1)                                                       AS adoption_rate_pct
8FROM AiAgentGenerativeAiUsage_std__dlm
9WHERE GenAiGatewayFeatureName__c = 'AgentforceCoworker'

Check Agentforce Coworker Health for the Last 30 Days 

See total prompts, unique active users, average prompts per day, and first and last usage dates for the last 30 days.

1-- What is the overall health of Agentforce Coworker at my company?
2SELECT
3    COUNT(*)                                                   AS total_prompts,
4    COUNT(DISTINCT UserId__c)                                  AS active_users,
5    ROUND(COUNT(*) * 1.0 / 30, 1)                             AS avg_prompts_per_day,
6    MIN(CAST(Timestamp__c AS DATE))                            AS first_usage_date,
7    MAX(CAST(Timestamp__c AS DATE))                            AS last_usage_date
8FROM AiAgentGenerativeAiUsage_std__dlm
9WHERE GenAiGatewayFeatureName__c = 'AgentforceCoworker'
10  AND Timestamp__c >= CURRENT_DATE - INTERVAL '30' DAY

Count Active Agentforce Coworker Users Over 7, 30, and 90 Days 

Compare distinct active users across three time windows to see whether adoption is growing or leveling off.

1-- How many users are actively using Agentforce Coworker?
2SELECT
3    'Last 7 days'                                              AS period,
4    COUNT(DISTINCT UserId__c)                                  AS active_users
5FROM AiAgentGenerativeAiUsage_std__dlm
6WHERE GenAiGatewayFeatureName__c = 'AgentforceCoworker'
7  AND Timestamp__c >= CURRENT_DATE - INTERVAL '7' DAY
8
9UNION ALL
10
11SELECT
12    'Last 30 days',
13    COUNT(DISTINCT UserId__c)
14FROM AiAgentGenerativeAiUsage_std__dlm
15WHERE GenAiGatewayFeatureName__c = 'AgentforceCoworker'
16  AND Timestamp__c >= CURRENT_DATE - INTERVAL '30' DAY
17
18UNION ALL
19
20SELECT
21    'Last 90 days',
22    COUNT(DISTINCT UserId__c)
23FROM AiAgentGenerativeAiUsage_std__dlm
24WHERE GenAiGatewayFeatureName__c = 'AgentforceCoworker'
25  AND Timestamp__c >= CURRENT_DATE - INTERVAL '90' DAY

Measure Agentforce Coworker Usage per User 

Break down each user’s total prompts, active days, and average prompts per active day. Use the results to find your most active users and the users who need more training.

1-- How intensively is each active user using Agentforce Coworker?
2SELECT
3    UserId__c                                                  AS user_id,
4    COUNT(*)                                                   AS total_prompts,
5    COUNT(DISTINCT CAST(Timestamp__c AS DATE))                 AS active_days,
6    ROUND(COUNT(*) * 1.0
7        / NULLIF(COUNT(DISTINCT CAST(Timestamp__c AS DATE)), 0)
8    , 1)                                                       AS avg_prompts_per_active_day,
9    MIN(CAST(Timestamp__c AS DATE))                            AS first_seen,
10    MAX(CAST(Timestamp__c AS DATE))                            AS last_seen
11FROM AiAgentGenerativeAiUsage_std__dlm
12WHERE GenAiGatewayFeatureName__c = 'AgentforceCoworker'
13GROUP BY UserId__c
14ORDER BY total_prompts DESC