Trivas.ai
    • Pricing
    Book Demo
    Login
    Trivas BI Reporting

    Build, customize & schedule deep-dive dashboards across ecommerce & ad data.

    Trivas Insights

    AI-powered anomaly detection, trend forecasting, and actionable recommendations.

    Trivas AI Agents

    Automated teammates that alert you on key business metrics and assist with decision-making.

    Founders & CEOs

    Strategic insights for business growth

    Marketing Leaders

    Campaign performance and ROI optimization

    Performance Marketers

    Real-time ad spend and conversion tracking

    Ecommerce Managers

    Operational efficiency and workflow insights

    Data Analysts

    Advanced analytics and reporting tools

    Agencies

    Agencies & technology partners: client reporting, integrations, and co‑marketing

    Pricing
    Leadership TeamTrust CenterCareersLife at TrivasFAQs
    Book Demo
    Login

    Data Dictionary

    Explore standardized definitions, formulas and usage guidance for key ecommerce performance metrics.

    Trivas Metrics

    Conversions ValueGross MarginChargeback RateImpression ShareiROASCOGSNet MarginGlance ViewsAverage Win RateCVREngagement Rateengaged sessionOpen RateClick RateOrder RateOpt-Out RateDelivery RateClick-Through RateAverage Churn RiskPredicted CLVTotal SalesImpressionsItems per CustomerTotal Views (LIVE)Items SoldLIVE GMVNet SalesGross SalesMERAd SpendROASGMV per CustomerLIVE SessionsNew Followers (LIVE)Units SoldAOVDiscount RateTaxCancellation RateTotal OrdersSKU OrdersTotal CancellationsConversion RateACOSCost Per ClickConversionsClicksTotal CustomersCreator LIVE-attributed GMVASPCPACACMRRChurn RateGross ProfitAffiliate Creators (LIVE)Return RateReturning Customer RateOrder Accuracy RateCSATDispute RateTACOSConversion ValuestringGMVVideo GMVBuy Box Percentage
    Clicks

    Overview

    Measures audience engagement and ad reach effectiveness.

    Formula

    SUM(clicks)

    Insights and Actions

    • Engagement Indicator — Higher clicks show stronger interest in ads or content.
    • CTR Analysis — Combine with impressions to calculate Click-Through Rate (CTR).
    • Ad Relevance — Identify which creatives or targeting strategies attract attention.
    • Performance Benchmarking — Compare across channels or time periods.
    • Traffic Forecasting — Helps estimate incoming site visitors from ads.

    Detailed Breakdown

    • Clicks= SUM(clicks)

    Suggested Dimensions

    CampaignChannelDeviceKeywordRegion

    Related Metrics

    ImpressionsConversion RateCPCCTR

    Example Use

    Prompt
    How many clicks did we get from Google Ads yesterday?
    Response
    Clicks from Google Ads Yesterday — 12,600

    Query

    SELECT SUM(clicks) AS clicks FROM traffic WHERE event_date BETWEEN :start AND :end;
    PreviousNext
    Trilio LogoTrivas.ai

    Ecommerce Intelligence, Powered by AI. Transform your data into profitable insights.

    Email: info@trivas.ai

    LinkedInX (Twitter)YouTubeFeatured on Product HuntShopifyAvailable on Shopify

    Product

    • BI Reporting
    • Insights
    • AI Agents
    • Pricing

    Solutions

    • Data Integrations
    • Custom Dashboards
    • Onboarding & Training
    • API & Developer Support

    Resources

    • Blog & Insights
    • Case Studies
    • Guides & Reports
    • Help Center
    • Data Dictionary
    • Developer Docs
    • Tools

    Company

    • Careers
    • Partnerships
    • Events
    • Contact
    • Privacy Policy
    • Terms of Use

    Compare

    • Triple Whale vs Polar vs Trivas
    • Northbeam vs Polar vs Trivas
    • Polar vs Peel vs Trivas

    © 2026 Trivas.ai. All rights reserved.

    Back to Top