Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Salesforce Data360 Audience Design

    1

    Architect and validate Salesforce Data Cloud segments, identity resolution, and Calculated Insight SQL.

    Free

    Security scanned
    Salesforce Data360 Audience Design

    Salesforce Data360 Audience Design

    Example session with this skill installed

    Plan a segment for 'High Value Loyalists' at the Unified Individual grain. We need a 90-day spend measure > 500 and must activate to Marketing Cloud with email and loyalty tier.

    • Read your context and instructions
    • Compiled the salesforce data360 audience

    I have mapped the audience design for 'High Value Loyalists'. This plan traces the Unified Individual grain through the required identity resolution rules and spend aggregations.

    Data 360 Audience Design: High Value Loyalists

    ComponentTechnical Specification
    Segment RootUnifiedIndividual__dlm
    Identity GrainUnified Individual (Requires reconciled Individual__dlm records)
    Calculated Insightloyalty_spend_90d__p
    CI SQL LogicSUM(ssot__SalesOrder__dlm.ssot__TotalAmount__c) where ssot__OrderDate__c >= 90 days
    Eligibility Filterloyalty_spend_90d__p.total_spend > 500
    Activation TargetMarketing Cloud
    Contact KeyUnifiedIndividual__dlm.ssot__Id__c
    Contact PointUnifiedContactPointEmail__dlm (Priority: 1)
    Payload AttributesLoyaltyTier__c, TotalSpend90d (Alias for CI measure)

    Calculated Insight Definition

    SELECT
        UnifiedIndividual__dlm.ssot__Id__c as individual_id__p,
        SUM(ssot__SalesOrder__dlm.ssot__TotalAmount__c) as total_spend__p,
        COUNT(ssot__SalesOrder__dlm.ssot__Id__c) as order_count__p
    FROM UnifiedIndividual__dlm
    JOIN IndividualIdentityLink__dlm ON UnifiedIndividual__dlm.ssot__Id__c = IndividualIdentityLink__dlm.UnifiedRecordId__p
    JOIN ssot__SalesOrder__dlm ON IndividualIdentityLink__dlm.SourceRecordId__p = ssot__SalesOrder__dlm.ssot__PartyId__c
    WHERE ssot__SalesOrder__dlm.ssot__OrderDate__c >= CURRENT_DATE - INTERVAL '90 days'
    GROUP BY UnifiedIndividual__dlm.ssot__Id__c
    

    Next steps

    1. Verify the IndividualIdentityLink__dlm contains recent reconciliation data for the SalesOrder source.
    2. Deploy the CI SQL and wait for the initial status to move to 'Active'.
    3. Run $data360-refresh-orchestration to populate the segment before starting the Activation.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    This skill manages the complex architecture of Salesforce Data 360 (Data Cloud) audience design. It prevents the common failure point where segments are built on unmapped data or incorrect identity grains. The tool forces a strict technical tracing from the business decision down to the active Data Model Object (DMO) mappings.

    What it does

    • Identity Resolution Strategy determines whether to target Prospect or Unified Individual grains based on reconciliation rules and stable keys.
    • DMO Path Validation verifies relationship paths are active and traversable before attempting segment construction.
    • Calculated Insight Engineering writes CI SQL with specific focus on fact grain, dimensions, and null behavior within the platform engine constraints.
    • Activation Payload Design maps contact keys and attributes to specific destinations while resolving one-to-many relationship conflicts.
    • Dependency Orchestration sequences identity runs, CI refreshes, and segment publications to prevent stale data usage.

    How it works

    1. Define the audience grain by evaluating if the journey requires reconciled cross-source identity or raw prospect behavior.
    2. Map the segment plan by documenting root DMOs, eligibility filters, and required Calculated Insights.
    3. Generate CI SQL using actual developer names for unified DMOs and identity-link records.
    4. Configure activation contracts including contact point selection and payload aliases.

    Frameworks & tools

    Specifically designed for Salesforce Data Cloud (formerly Data 360). Works with Data Model Objects (DMO), Calculated Insights (CI) SQL, and Identity Resolution rulesets.

    Why this beats prompting it yourself

    Generic prompts often ignore the strict execution order required for Data Cloud. This skill enforces the dependency chain between Identity Resolution, CIs, and Segments, ensuring you never activate an audience against stale identity links or unmapped attributes.

    Use cases

    • Design a high-value customer segment using cross-org purchase history.
    • Troubleshoot why a segment is returning zero members due to broken DMO paths.
    • Create Calculated Insight SQL for rolling 30-day engagement scores.
    • Standardize activation payloads for external marketing clouds or data lakes.

    Known limitations

    Does not support UI-only platform actions. Requires existing DMO mappings to be present in the data lake schema to validate paths.

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for LLM Ops.

    Requires existing DMO mappings. Cannot perform UI-only manual approvals. SQL generation is limited to the Calculated Insights engine syntax.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before buying a skill.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    Free to use

    No account required to browse

    Trust & safety

    Security scan

    Security scan passed 6 days ago

    • Free with an Agensi account

    Accounts
    Salesforce
    Software
    Node.jsSalesforce CLI

    Permissions

    Read Files
    Environment Variables
    Network Access
    Write Files
    Terminal / Shell

    Allowed Hosts

    login.salesforce.com
    Listed6 days ago

    What's inside

    Frequently Asked Questions

    This skill automates the technical architecture of Salesforce Data Cloud segments, specifically ensuring your SQL and filters are built on valid DMO mappings and correct identity resolution grains to prevent common zero-count segment errors.

    This skill is optimized for agents that support SQL generation and architectural mapping; it requires a connection to your Salesforce Data Cloud environment or a schema export to validate relationship paths.

    No, this skill is designed to work with your existing Data Model Object (DMO) mappings; it focuses on designing the logic, SQL, and identity strategies once your initial data ingestion is configured.

    You receive the specialized logic for architecting Identity Resolution rules, pre-validated Calculated Insight SQL, DMO path validation workflows, and activation payload templates.

    The skill is updated periodically to reflect the latest Salesforce Data Cloud releases, including changes to SQL engine constraints, new identity resolution features, and updated activation destination requirements.

    By enforcing a strict dependency chain, the skill ensures that Calculated Insights and Identity Resolution rules are refreshed and sequenced correctly before a segment is published, preventing the use of stale or orphaned data.

    New in LLM Ops

    Free