List all available dimensions in the CJA data view.

Dimensions are attributes that can be used to break down and categorize your data, such as page names, product categories, marketing channels, date/time components, etc.

Args: dataview_id: Optional data view ID (uses configured default if not provided). expansion: Optional additional fields to include (e.g., 'tags,approved').

Returns: Dictionary with dimensions list and total count.

Example queries: - "What dimensions are available in my data view?" - "List all dimensions I can use for analysis" - "Show me the available breakdowns"

List all available metrics in the CJA data view.

Metrics are quantitative measurements of your data, such as visits, page views, revenue, conversion rates, time spent, etc.

Args: dataview_id: Optional data view ID (uses configured default if not provided). expansion: Optional additional fields to include.

Returns: Dictionary with metrics list and total count.

Example queries: - "What metrics can I measure?" - "List all available metrics" - "Show me metrics for measuring website performance"

Run a CJA report with specified dimension and metrics over a date range.

This is the primary tool for analyzing data. It breaks down one or more metrics by a dimension over a specified time period.

IMPORTANT: Before calling this tool, check the 'cja://quick-reference' resource for common dimension and metric IDs. For daily trends, use 'variables/daterangeday'. For sessions, use 'metrics/visits'. The resources provide commonly used IDs.

Args: dimension: Dimension ID to break down (e.g., 'variables/daterangeday', 'variables/page'). metrics: List of metric IDs to measure (e.g., ['metrics/visits', 'metrics/pageviews']). start_date: Start date in YYYY-MM-DD format. end_date: End date in YYYY-MM-DD format. limit: Maximum number of dimension items to return (default: 10, max: 50000). dataview_id: Optional data view ID (uses configured default if not provided).

Returns: Dictionary with report data including dimension items and metric values.

Common patterns (check cja://quick-reference resource for more): - Daily sessions: dimension='variables/daterangeday', metrics=['metrics/visits'] - Top pages: dimension='variables/page', metrics=['metrics/pageviews'] - Device breakdown: dimension='variables/mobiledevicetype', metrics=['metrics/visits']

Example queries: - "Show me daily visits for January 2024" - "What are the top pages by pageviews last month?" - "Analyze sessions by device type for Q1"

Get top N items for a dimension ranked by a metric.

This tool is optimized for finding the top performing dimension items based on a single metric, such as top pages by visits, top products by revenue, etc.

Args: dimension: Dimension ID (e.g., 'variables/page', 'variables/product'). metric: Metric ID to rank by (e.g., 'metrics/visits', 'metrics/revenue'). start_date: Start date in YYYY-MM-DD format. end_date: End date in YYYY-MM-DD format. limit: Number of top items to return (default: 10, max: 500). dataview_id: Optional data view ID (uses configured default if not provided).

Returns: Dictionary with top dimension items and their metric values.

Example queries: - "What are the top 10 pages by visits this week?" - "Show me the top 20 products by revenue last month" - "Which marketing channels drove the most conversions?"

Get detailed information about a CJA data view.

This tool retrieves configuration and metadata for the data view, including its name, description, owner, and component counts.

Args: dataview_id: Optional data view ID (uses configured default if not provided). expansion: Optional additional fields to include (e.g., 'components').

Returns: Dictionary with data view configuration and metadata.

Example queries: - "What data view am I using?" - "Show me information about the current data view" - "What's configured in my data view?"

Run a multi-dimensional breakdown report.

This tool performs breakdown analysis where you analyze a primary dimension and further break it down by a secondary dimension. For example, analyze pages and break them down by device type to understand device distribution per page.

Args: primary_dimension: Primary dimension ID (e.g., 'variables/page', 'variables/campaign'). breakdown_dimension: Dimension to break down by (e.g., 'variables/mobiledevicetype'). metrics: List of metric IDs to analyze. start_date: Start date in YYYY-MM-DD format. end_date: End date in YYYY-MM-DD format. limit: Maximum number of primary dimension items (default: 10, max: 500). breakdown_limit: Maximum breakdown items per primary item (default: 5, max: 50). segment_ids: Optional list of segment IDs to filter the report. dataview_id: Optional data view ID (uses configured default if not provided).

Returns: Dictionary with nested breakdown report results.

Example queries: - "Break down top pages by device type" - "Show me campaigns broken down by browser for last month" - "Analyze product performance by marketing channel"

Run a time-series trend report.

This tool analyzes how metrics change over time at a specified granularity (hourly, daily, weekly, monthly). Optionally break down trends by a dimension.

Args: metrics: List of metric IDs to trend over time. start_date: Start date in YYYY-MM-DD format. end_date: End date in YYYY-MM-DD format. granularity: Time granularity - 'hour', 'day', 'week', or 'month' (default: 'day'). dimension: Optional dimension to break down the trend (e.g., 'variables/mobiledevicetype'). dimension_limit: Maximum dimension items if dimension specified (default: 5, max: 50). segment_ids: Optional list of segment IDs to filter the report. dataview_id: Optional data view ID (uses configured default if not provided).

Returns: Dictionary with time-series trend data.

Example queries: - "Show me daily visits trend for last 30 days" - "Trend pageviews by hour for yesterday" - "Show weekly revenue trend broken down by device type" - "Monthly orders trend for Q1 2024"

Search for dimension items matching a search term.

This tool searches within a dimension's values to find items containing the search term. Useful for finding specific pages, products, campaigns, etc.

Args: dimension: Dimension ID to search within (e.g., 'variables/page', 'variables/product'). search_term: Search term to find matching dimension items. start_date: Optional start date to scope search results (YYYY-MM-DD format). end_date: Optional end date to scope search results (YYYY-MM-DD format). limit: Maximum number of matching items to return (default: 100, max: 1000). dataview_id: Optional data view ID (uses configured default if not provided).

Returns: Dictionary with matching dimension items.

Example queries: - "Find all pages containing 'checkout'" - "Search for products with 'pro' in the name" - "Which campaigns contain 'summer'?" - "Find pages with 'login' that had activity last week"

List all available segments/filters in CJA.

Segments (also called filters in CJA) are reusable components that filter data in reports and analysis. This tool retrieves all segments you have access to.

Args: dataview_id: Optional data view ID to filter segments (uses configured default if not provided). name: Filter segments by name (partial match). tag_names: Comma-delimited list of tag names to filter by. include_type: Include additional segments: 'shared', 'all', 'templates'. limit: Number of results per page (default: 10, max: 1000). page: Page number, 0-indexed (default: 0). expansion: Additional fields to include: 'definition', 'tags', 'compatibility', 'ownerFullName'.

Returns: Dictionary with segments list and metadata.

Example queries: - "List all available segments" - "Show me segments with 'mobile' in the name" - "What filters are tagged with 'marketing'?" - "List all shared segments"

Get detailed information about a specific segment.

This tool retrieves complete details about a segment including its definition, which shows the exact logic and rules used to filter data.

Args: segment_id: Segment ID to retrieve. expansion: Additional fields to include: 'definition', 'tags', 'compatibility'.

Returns: Dictionary with complete segment information.

Example queries: - "Show me the definition of segment s300000022_5bb7c94e80f0073611afb35c" - "Get details for the Mobile Users segment" - "What's the logic in segment XYZ?"

Create a new segment in CJA.

This tool creates a new segment/filter that can be used in reports. Segment definitions use a JSON structure to define filtering rules.

IMPORTANT: Segment definitions are complex. Best practice:

1. Create a template segment in the CJA UI

2. Use cja_get_segment_details to see its definition structure

3. Modify the definition as needed

4. Use cja_validate_segment before creating

Args: name: Segment name (required). definition: Segment definition object with container and rules (required). description: Optional segment description. dataview_id: Optional data view ID (uses configured default if not provided).

Returns: Dictionary with created segment including assigned ID.

Example queries: - "Create a segment for mobile users" - "Make a new filter for high-value customers"

Example definition (mobile users): { "container": { "func": "segment", "context": "hits", "pred": { "func": "exists", "val": {"func": "attr", "name": "variables/mobiledevicetype"} } }, "func": "segment-def", "version": [1, 0, 0] }

Validate a segment definition before creating or updating.

This tool checks if a segment definition is syntactically correct and compatible with the specified data view. Always use this before creating a new segment.

Args: definition: Segment definition to validate (required). dataview_id: Optional data view ID to validate against (uses configured default if not provided).

Returns: Dictionary with validation result and compatibility information.

Example queries: - "Validate this segment definition before I create it" - "Check if this filter definition is valid" - "Is this segment compatible with my data view?"

List calculated metrics in CJA.

Retrieve calculated metrics (custom formulas) that can be used in reports. You can filter by name, tags, and share type.

Args: name: Optional filter by metric name (partial match). tag_names: Optional comma-delimited tag names to filter by. include_type: Optional 'shared', 'all', or 'templates' to include additional metrics. limit: Maximum results per page (1-1000, default 10). page: Page number for pagination (0-indexed, default 0). expansion: Optional comma-delimited fields: 'definition', 'tags', 'usedIn', 'compatibility'. dataview_id: Optional data view ID to filter metrics (uses configured default if not provided).

Returns: Dictionary with list of calculated metrics and total count.

Example queries: - "Show me all calculated metrics" - "List calculated metrics containing 'conversion' in the name" - "Get calculated metrics with their definitions"

Get detailed information about a specific calculated metric.

Retrieve complete details about a calculated metric including its definition/formula. This is useful for understanding how a metric is calculated or copying definitions.

Args: metric_id: Calculated metric ID to retrieve (required). expansion: Optional comma-delimited fields: 'definition', 'tags', 'usedIn', 'compatibility'.

Returns: Dictionary with calculated metric details and formula definition.

Example queries: - "Show me the formula for calculated metric a5066209" - "Get definition for the conversion rate metric" - "What's the formula for metric ID 12345?"

Create a new calculated metric in CJA.

Create a custom metric with formulas and functions that can be used in reports. IMPORTANT: Validate the definition first using cja_validate_calculated_metric.

Args: name: Metric name (required). definition: Metric definition with formula (required). Should have 'func': 'calc-metric', 'formula': {...}, 'version': [1,0,0]. description: Optional metric description. metric_type: Type: 'decimal', 'percent', 'currency', or 'time' (default 'decimal'). polarity: Optional 'positive' or 'negative' (indicates if higher values are better/worse). precision: Optional decimal places for display (0-10). dataview_id: Optional data view ID (uses configured default if not provided).

Returns: Dictionary with created calculated metric details including assigned ID.

Example queries: - "Create a calculated metric named 'Conversion Rate'" - "Make a new metric that divides revenue by orders" - "Create a metric for visits per visitor"

Validate a calculated metric definition before creating or updating.

Check if a calculated metric definition is syntactically correct and compatible with the data view. Always use this before creating a new metric.

Args: name: Metric name for validation (required). definition: Metric definition to validate (required). metric_type: Type: 'decimal', 'percent', 'currency', or 'time' (default 'decimal'). description: Optional metric description for validation. dataview_id: Optional data view ID to validate against (uses configured default if not provided).

Returns: Dictionary with validation result, metrics used, and functions detected.

Example queries: - "Validate this calculated metric definition before I create it" - "Check if this metric formula is valid" - "Is this calculated metric definition compatible?"