get_attribution_chart
ChatGPTGet an over time (time series) chart for orders, sales and customers for each marketing channel for a given attribution model across a date range.
Business
Overview
Sweet helps ecommerce teams understand sales, marketing, customer, product, discount, refund, and profit performance using their connected Sweet data. Ask questions in plain language, such as what drove sales growth, which marketing channels are most efficient, how customer retention is changing, which products or discounts are affecting margin, or where refunds are impacting profitability. Sweet returns clear summaries, KPI comparisons, segment breakdowns, and practical insights so teams can make faster trading, marketing, and retention decisions from the data they already use.
Tools
get_attribution_chart
ChatGPTGet an over time (time series) chart for orders, sales and customers for each marketing channel for a given attribution model across a date range.
get_attribution_compare_table
ChatGPTGet a side-by-side marketing channel attribution table comparing channel performance between either two attribution models or same model between two date ranges.
get_attribution_compare_table
ChatGPTGet a side-by-side marketing channel attribution table comparing channel performance between either two attribution models or same model between two date ranges.
get_attribution_customers_behaviour
ChatGPTGet attributed marketing channels for each Growth Model segment cohort broken down by primary vs secondary orders
get_attribution_customers_behaviour
ChatGPTGet attributed marketing channels for each Growth Model segment cohort broken down by primary vs secondary orders
get_attribution_secondary_touchpoints
ChatGPTThis analysis shows the number of customers who placed both primary (i.e a first time order) and at least one secondary order (any subsequent orders) in the period of time selected. The primary order is attributed based on the selected attribution model. In terms of secondary orders, the table shows the touchpoints customers are using to repurchase (secondary orders). Use this tool to understand whether customers are returning via the same marketing channels; and particularly whether they are moving to more cost effective channels - eg organic search, direct or email - or they continue in more expensive paid channels, such as paid search.
get_attribution_secondary_touchpoints
ChatGPTThis analysis shows the number of customers who placed both primary (i.e a first time order) and at least one secondary order (any subsequent orders) in the period of time selected. The primary order is attributed based on the selected attribution model. In terms of secondary orders, the table shows the touchpoints customers are using to repurchase (secondary orders). Use this tool to understand whether customers are returning via the same marketing channels; and particularly whether they are moving to more cost effective channels - eg organic search, direct or email - or they continue in more expensive paid channels, such as paid search.
get_attribution_top_channels
ChatGPTGet the top 5 channels by attributed orders and sales, and customer acquisition.
get_attribution_top_channels
ChatGPTGet the top 5 channels by attributed orders and sales, and customer acquisition.
get_audiences_count
ChatGPTGet the total number of audiences configured for the workspace.
get_audiences_count
ChatGPTGet the total number of audiences configured for the workspace.
get_available_clients
ChatGPTList accessible clients/brands/accounts for the current user. Use this before analytics calls when the user mentions a brand, client, account, or customer by name and you need to resolve it to a clientScope client id or exact client name. For example, if the user asks "What were sales for Aspiga last week?", treat Aspiga as a possible brand/client name, call this tool to resolve it, then run the analytics tool with clientScope set to the resolved client. Only partner users can use this tool.
get_available_clients
ChatGPTList accessible clients/brands/accounts for the current user. Use this before analytics calls when the user mentions a brand, client, account, or customer by name and you need to resolve it to a clientScope client id or exact client name. For example, if the user asks "What were sales for Aspiga last week?", treat Aspiga as a possible brand/client name, call this tool to resolve it, then run the analytics tool with clientScope set to the resolved client. Only partner users can use this tool.
get_available_shops
ChatGPTList the shops/stores available to the current user. Use this before analytics calls when the user asks about a specific store, shop, country, region, market, or location (for example US, USA, United States, UK) and you need to resolve that wording to a storeScope shop id or exact shop name.
get_available_shops
ChatGPTList the shops/stores available to the current user. Use this before analytics calls when the user asks about a specific store, shop, country, region, market, or location (for example US, USA, United States, UK) and you need to resolve that wording to a storeScope shop id or exact shop name.
get_cost_reporting_matrix
ChatGPTGet channel-level reporting matrix data for a date range and grouping.
get_cost_reporting_matrix
ChatGPTGet channel-level reporting matrix data for a date range and grouping.
get_cost_reporting_sales_metrics_chart
ChatGPTGet sales metrics chart data (ROAS, CAC, CPO and cost %) for cost reporting.
get_cost_reporting_sales_metrics_chart
ChatGPTGet sales metrics chart data (ROAS, CAC, CPO and cost %) for cost reporting.
get_cost_reporting_summary
ChatGPTGet summary metrics for cost reporting in the selected date range.
get_cost_reporting_summary
ChatGPTGet summary metrics for cost reporting in the selected date range.
get_discounts_analysis
ChatGPTGet total discount usage metrics with comparison to a prior period. Use this tool to understand the total discount usage and its impact on your revenue.
get_discounts_analysis
ChatGPTGet total discount usage metrics with comparison to a prior period. Use this tool to understand the total discount usage and its impact on your revenue.
get_discounts_chart_analysis
ChatGPTGet a time-series of total discount activity with comparison values for the prior period. Use this tool to understand the impact of discounts on your revenue over time.
get_discounts_chart_analysis
ChatGPTGet a time-series of total discount activity with comparison values for the prior period. Use this tool to understand the impact of discounts on your revenue over time.
get_discounts_shipping_analysis
ChatGPTGet a time-series of shipping discount metrics with comparison to a prior period. Use this tool to understand the impact of shipping discounts on your revenue over time.
get_discounts_shipping_analysis
ChatGPTGet a time-series of shipping discount metrics with comparison to a prior period. Use this tool to understand the impact of shipping discounts on your revenue over time.
get_discounts_shipping_summary
ChatGPTGet shipping discount KPIs (average and lost shipping revenue) with comparison to a prior period. Use this tool to understand the impact of shipping discounts on your revenue.
get_discounts_shipping_summary
ChatGPTGet shipping discount KPIs (average and lost shipping revenue) with comparison to a prior period. Use this tool to understand the impact of shipping discounts on your revenue.
get_discounts_top_codes
ChatGPTGet a paginated leaderboard of the top discount codes ranked by usage and value, with prior-period comparison. Use this tool to understand the most used discount codes and their impact on your revenue.
get_discounts_top_codes
ChatGPTGet a paginated leaderboard of the top discount codes ranked by usage and value, with prior-period comparison. Use this tool to understand the most used discount codes and their impact on your revenue.
get_drop_by_drop_channels_with_costs
ChatGPTFilter the supplied channels list down to those with non-zero cost-manager rows in the rolling window.
get_drop_by_drop_channels_with_costs
ChatGPTFilter the supplied channels list down to those with non-zero cost-manager rows in the rolling window.
get_drop_by_drop_stats
ChatGPTGet day by day sales, marketing costs, ROAS and CAC metrics. Use this tool to ensure that marketing investment is delivering the required ROAS.
get_drop_by_drop_stats
ChatGPTGet day by day sales, marketing costs, ROAS and CAC metrics. Use this tool to ensure that marketing investment is delivering the required ROAS.
get_filters
ChatGPTGet available dashboard filters such as audiences, coupon codes, channels, channel groups, and RFM segments. Use this tool if you need to apply filters to other dashboards, specifically sales, insights, discounts, and refunds tools.
get_filters
ChatGPTGet available dashboard filters such as audiences, coupon codes, channels, channel groups, and RFM segments. Use this tool if you need to apply filters to other dashboards, specifically sales, insights, discounts, and refunds tools.
get_growth_acquisition_impact
ChatGPTAnalyzes the impact of key sales metric (new customers in FY, AOC, AOV) for new customers in the financial year and how each metrics impacts total sales.
get_growth_acquisition_impact
ChatGPTAnalyzes the impact of key sales metric (new customers in FY, AOC, AOV) for new customers in the financial year and how each metrics impacts total sales.
get_growth_chart
ChatGPTProvides a breakdown of metrics for each Growth Model cohort/segment. GM segment definitions: NEW - new customers in the current financial year PYNEW - new customers from the previous financial year PYNON - customers who purchased in previous financial year and in any prior year(s). Customers not newly acquired in the previous year PY1INACT - customers who did not purchase in previous financial year but rather 1 year prior PY2INACT - customers who did not purchase in previous financial year but rather 2 years prior PY3INACT - customers who did not purchase in previous financial year but rather 3 years prior or more Use this tool when you need to understand the performance of each Growth Model cohort/segment to understand customer retention and acquisition patterns.
get_growth_chart
ChatGPTProvides a breakdown of metrics for each Growth Model cohort/segment. GM segment definitions: NEW - new customers in the current financial year PYNEW - new customers from the previous financial year PYNON - customers who purchased in previous financial year and in any prior year(s). Customers not newly acquired in the previous year PY1INACT - customers who did not purchase in previous financial year but rather 1 year prior PY2INACT - customers who did not purchase in previous financial year but rather 2 years prior PY3INACT - customers who did not purchase in previous financial year but rather 3 years prior or more Use this tool when you need to understand the performance of each Growth Model cohort/segment to understand customer retention and acquisition patterns.
get_growth_retention_impact
ChatGPTAnalyzes the impact of growth model metric (opening customers in FY, retained percentage in FY, productivity). Opening customers are number of customers are the beginnign of the period/FY. Retained percentage is the percentage of opening customers that purchased during the period. Productivity is the average revenue per retained customer.
get_growth_retention_impact
ChatGPTAnalyzes the impact of growth model metric (opening customers in FY, retained percentage in FY, productivity). Opening customers are number of customers are the beginnign of the period/FY. Retained percentage is the percentage of opening customers that purchased during the period. Productivity is the average revenue per retained customer.
get_growth_tool_metrics
ChatGPTProvides Growth Model metrics per segment for the selected fiscal year. Use this tool when you need the raw data to build your own custom growth model
get_growth_tool_metrics
ChatGPTProvides Growth Model metrics per segment for the selected fiscal year. Use this tool when you need the raw data to build your own custom growth model
get_home_bing_tiles
ChatGPTGet Microsoft (Bing) Ads KPIs for each metric with their corresponding targets. Use this tool to understand whether Microsoft (Bing) Ads performance is meeting or exceeding targets.
get_home_bing_tiles
ChatGPTGet Microsoft (Bing) Ads KPIs for each metric with their corresponding targets. Use this tool to understand whether Microsoft (Bing) Ads performance is meeting or exceeding targets.
get_home_email_tiles
ChatGPTGet email marketing KPIs for each metric with their corresponding targets. Use this tool to understand whether email marketing performance is meeting or exceeding targets.
get_home_email_tiles
ChatGPTGet email marketing KPIs for each metric with their corresponding targets. Use this tool to understand whether email marketing performance is meeting or exceeding targets.
get_home_ga_tiles
ChatGPTGet Google Analytics-attributed KPIs for each metric with their corresponding targets. Use this tool to understand whether Google Analytics performance is meeting or exceeding targets.
get_home_ga_tiles
ChatGPTGet Google Analytics-attributed KPIs for each metric with their corresponding targets. Use this tool to understand whether Google Analytics performance is meeting or exceeding targets.
get_home_google_ads_tiles
ChatGPTGet Google Ads KPIs for each metric with their corresponding targets. Use this tool to understand whether Google Ads performance is meeting or exceeding targets.
get_home_google_ads_tiles
ChatGPTGet Google Ads KPIs for each metric with their corresponding targets. Use this tool to understand whether Google Ads performance is meeting or exceeding targets.
get_home_marketing_tiles
ChatGPTGet marketing KPIs for each metric with their corresponding targets. Use this tool to understand whether marketing performance is meeting or exceeding targets.
get_home_marketing_tiles
ChatGPTGet marketing KPIs for each metric with their corresponding targets. Use this tool to understand whether marketing performance is meeting or exceeding targets.
get_home_meta_tiles
ChatGPTGet Meta Ads KPIs for each metric with their corresponding targets. Use this tool to understand whether Meta Ads performance is meeting or exceeding targets.
get_home_meta_tiles
ChatGPTGet Meta Ads KPIs for each metric with their corresponding targets. Use this tool to understand whether Meta Ads performance is meeting or exceeding targets.
get_home_tiles
ChatGPTGet sales performance KPIs for each metric with their corresponding targets. Use this tool to understand whether sales performance is meeting or exceeding targets.
get_home_tiles
ChatGPTGet sales performance KPIs for each metric with their corresponding targets. Use this tool to understand whether sales performance is meeting or exceeding targets.
get_insights_analysis_by_dimension
ChatGPTGet sales metrics broken down by a given dimension such as channel, country, province, city, shipping city, frequency of units, frequency of products, channel, channel group, payment method, and shipping method.
get_insights_analysis_by_dimension
ChatGPTGet sales metrics broken down by a given dimension such as channel, country, province, city, shipping city, frequency of units, frequency of products, channel, channel group, payment method, and shipping method.
get_insights_average_purchase_gap
ChatGPTAnalyzes the average time between repeat purchases across the requested window breaking the data by primary and secondary orders (including a breakdown by the order number). Use this tool when you need to understand the average time between repeat purchases for first order to second order, second order to third order, etc. within the selected and compare periods.
get_insights_average_purchase_gap
ChatGPTAnalyzes the average time between repeat purchases across the requested window breaking the data by primary and secondary orders (including a breakdown by the order number). Use this tool when you need to understand the average time between repeat purchases for first order to second order, second order to third order, etc. within the selected and compare periods.
get_insights_breakdown
ChatGPTGet a detailed metric breakdown comparing the current period to the comparison period broken down by new and existing customers. Use this tool when you need a complete view of key sales metrics vs the compare period.
get_insights_breakdown
ChatGPTGet a detailed metric breakdown comparing the current period to the comparison period broken down by new and existing customers. Use this tool when you need a complete view of key sales metrics vs the compare period.
get_insights_chart
ChatGPTGet a time-series of sales metrics split by new and existing customers and total.
get_insights_chart
ChatGPTGet a time-series of sales metrics split by new and existing customers and total.
get_insights_heatmap
ChatGPTGet a heatmap dataset comparing the day of the week and time of day that customer cohorts purchase. Can be looked at by number of orders or value of orders.
get_insights_heatmap
ChatGPTGet a heatmap dataset comparing the day of the week and time of day that customer cohorts purchase. Can be looked at by number of orders or value of orders.
get_insights_products_variance
ChatGPTAnalyzes the impact of product-level metrics (orders, average selling price, units per order) on sales performance by measuring the impact of each individual metric on total sales compared to the comparison period broken down by new and existing customers. Use this tool when needing to understand the value impact of order-level metrics to understand what drove higher or lower sales vs the compare period.
get_insights_products_variance
ChatGPTAnalyzes the impact of product-level metrics (orders, average selling price, units per order) on sales performance by measuring the impact of each individual metric on total sales compared to the comparison period broken down by new and existing customers. Use this tool when needing to understand the value impact of order-level metrics to understand what drove higher or lower sales vs the compare period.
get_insights_purchase_gap
ChatGPTGet purchase-gap distribution metrics describing the average time between repeat purchases.
get_insights_purchase_gap
ChatGPTGet purchase-gap distribution metrics describing the average time between repeat purchases.
get_insights_sales_variance
ChatGPTAnalyzes the impact of sales metrics (customers, AOV, AOC) on sales performance by measuring the impact of each individual metric on total sales compared to the comparison period broken down by new and existing customers. Use this tool when needing to understand the value impact of customer-level metrics to understand what drove higher or lower sales vs the compare period.
get_insights_sales_variance
ChatGPTAnalyzes the impact of sales metrics (customers, AOV, AOC) on sales performance by measuring the impact of each individual metric on total sales compared to the comparison period broken down by new and existing customers. Use this tool when needing to understand the value impact of customer-level metrics to understand what drove higher or lower sales vs the compare period.
get_ltv_cohort
ChatGPTGet customer lifetime value for cohorts grouped by the month that each customer made their first order (can also we looked as weekly or yearly cohorts). Use this tool to understand the customer lifetime value for each cohort and how it changes over time. Analysis can be run for a given audience or comparing two audiences
get_ltv_cohort
ChatGPTGet customer lifetime value for cohorts grouped by the month that each customer made their first order (can also we looked as weekly or yearly cohorts). Use this tool to understand the customer lifetime value for each cohort and how it changes over time. Analysis can be run for a given audience or comparing two audiences
get_ltv_cohort_order_sequence
ChatGPTAnalyze customer lifetime value by order sequence. Rather than time based, we look at second, third, fourth, etc orders, regardless of when they were placed. Use this tool to understand the customer lifetime value by orders removing the time aspect. Analysis can be run for a given audience or comparing two audiences
get_ltv_cohort_order_sequence
ChatGPTAnalyze customer lifetime value by order sequence. Rather than time based, we look at second, third, fourth, etc orders, regardless of when they were placed. Use this tool to understand the customer lifetime value by orders removing the time aspect. Analysis can be run for a given audience or comparing two audiences
get_margin_calculator
ChatGPTThe Margin Calculator is your key tool to calculate the Return on Advertising Spend (ROAS) that is required to deliver the profitability for your business. Use the get_margin_calculator_syncable_values` tool in case the inputs have not been provided by the user to set defaults based on their data.
get_margin_calculator
ChatGPTThe Margin Calculator is your key tool to calculate the Return on Advertising Spend (ROAS) that is required to deliver the profitability for your business. Use the get_margin_calculator_syncable_values` tool in case the inputs have not been provided by the user to set defaults based on their data.
get_margin_calculator_syncable_values
ChatGPTGet default margin calculator inputs derived from orders and costs data. Use this tool for defaults to the inputs required for the
get_margin_calculator tool.get_margin_calculator_syncable_values
ChatGPTGet default margin calculator inputs derived from orders and costs data. Use this tool for defaults to the inputs required for the
get_margin_calculator tool.get_marketing_summary
ChatGPTGet the marketing summary comparing ecommerce conversions vs synced marketing conversions. Use this tool to get a top-level view of how marketing platforms are reporting conversions/value compared to your actual sales.
get_marketing_summary
ChatGPTGet the marketing summary comparing ecommerce conversions vs synced marketing conversions. Use this tool to get a top-level view of how marketing platforms are reporting conversions/value compared to your actual sales.
get_marketing_summary_charts
ChatGPTSummarises and blends the impact of marketing data with your actual sales data to show the impact of marketing spend. Use this tool to understand the impact of marketing spend on your sales beyond what the marketing platforms tell you.
get_marketing_summary_charts
ChatGPTSummarises and blends the impact of marketing data with your actual sales data to show the impact of marketing spend. Use this tool to understand the impact of marketing spend on your sales beyond what the marketing platforms tell you.
get_marketing_summary_table
ChatGPTAnalyzes each marketing platform and provides a detailed breakdown of Conversions, Conversion Value, Cost, CPA, and ROAS. Use this tool to get a detailed view of how each marketing platform is performing.
get_marketing_summary_table
ChatGPTAnalyzes each marketing platform and provides a detailed breakdown of Conversions, Conversion Value, Cost, CPA, and ROAS. Use this tool to get a detailed view of how each marketing platform is performing.
get_orders_list
ChatGPTGet a paginated list of orders with optional filtering by channel, attribution, audience, and free-text search. Use this tool to get a list of orders and their details or search for a particular order by customer or ID.
get_orders_list
ChatGPTGet a paginated list of orders with optional filtering by channel, attribution, audience, and free-text search. Use this tool to get a list of orders and their details or search for a particular order by customer or ID.
get_ppc_summary_chart
ChatGPTGet a time-series PPC chart broken down by a specific dimension.
get_ppc_summary_chart
ChatGPTGet a time-series PPC chart broken down by a specific dimension.
get_ppc_summary_media_table
ChatGPTGet a paginated table of PPC media performance broken down by dimension.
get_ppc_summary_media_table
ChatGPTGet a paginated table of PPC media performance broken down by dimension.
get_profit_and_loss_product_margin
ChatGPTGet the SKU/product margin breakdown compared to a prior period.
get_profit_and_loss_product_margin
ChatGPTGet the SKU/product margin breakdown compared to a prior period.
get_profit_and_loss_rates
ChatGPTGet return rate metrics derived from refunds and order indexes.
get_profit_and_loss_rates
ChatGPTGet return rate metrics derived from refunds and order indexes.
get_profit_and_loss_sales
ChatGPTGet the profit & loss sales tree compared to a prior period with currency conversion hooks.
get_profit_and_loss_sales
ChatGPTGet the profit & loss sales tree compared to a prior period with currency conversion hooks.
get_profit_and_loss_summary
ChatGPTGet the condensed profit & loss summary tiles for dashboards.
get_profit_and_loss_summary
ChatGPTGet the condensed profit & loss summary tiles for dashboards.
get_profit_and_loss_timeline_and_daily
ChatGPTGet the profit & loss timeline and daily breakdown dataset.
get_profit_and_loss_timeline_and_daily
ChatGPTGet the profit & loss timeline and daily breakdown dataset.
get_refunds_analysis
ChatGPTGet a tabular refund analysis with comparison metrics for the prior period.
get_refunds_analysis
ChatGPTGet a tabular refund analysis with comparison metrics for the prior period.
get_refunds_curve
ChatGPTGet the refund timing curve dataset comparing periods.
get_refunds_curve
ChatGPTGet the refund timing curve dataset comparing periods.
get_refunds_filters
ChatGPTGet the available refund filter facets for populating dashboard dropdowns.
get_refunds_filters
ChatGPTGet the available refund filter facets for populating dashboard dropdowns.
get_refunds_insights_order_type
ChatGPTGet refunds broken down by order type.
get_refunds_insights_order_type
ChatGPTGet refunds broken down by order type.
get_refunds_insights_pie_chart
ChatGPTGet pie-chart aggregates for refund insights.
get_refunds_insights_pie_chart
ChatGPTGet pie-chart aggregates for refund insights.
get_refunds_insights_table
ChatGPTGet the insights-oriented refund table slice.
get_refunds_insights_table
ChatGPTGet the insights-oriented refund table slice.
get_refunds_over_time
ChatGPTGet refund counts and amounts bucketed over time.
get_refunds_over_time
ChatGPTGet refund counts and amounts bucketed over time.
get_refunds_summary
ChatGPTGet refund summary KPI metrics with comparison values for a date range.
get_refunds_summary
ChatGPTGet refund summary KPI metrics with comparison values for a date range.
get_rfm_customer_data_evolution
ChatGPTGet the time-series of how customer cohorts evolve through RFM segments.
get_rfm_customer_data_evolution
ChatGPTGet the time-series of how customer cohorts evolve through RFM segments.
get_rfm_customers
ChatGPTGet a paginated list of customers with their lifetime spend metrics for a given date range.
get_rfm_customers
ChatGPTGet a paginated list of customers with their lifetime spend metrics for a given date range.
get_rfm_customers_by_recency_and_frequency
ChatGPTGet the recency-by-frequency matrix used to visualise customer clustering.
get_rfm_customers_by_recency_and_frequency
ChatGPTGet the recency-by-frequency matrix used to visualise customer clustering.
get_rfm_customers_summary
ChatGPTGet year-on-year summary boxes comparing total customer KPIs.
get_rfm_customers_summary
ChatGPTGet year-on-year summary boxes comparing total customer KPIs.
get_rfm_db_stats
ChatGPTGet database-level aggregate RFM statistics with comparisons across periods.
get_rfm_db_stats
ChatGPTGet database-level aggregate RFM statistics with comparisons across periods.
get_rfm_lifetime_value_metrics
ChatGPTGet composite customer lifetime value (CLV/LTV) charts and rolling averages.
get_rfm_lifetime_value_metrics
ChatGPTGet composite customer lifetime value (CLV/LTV) charts and rolling averages.
get_rfm_segment_breakdown
ChatGPTGet aggregated KPI breakdowns across all RFM segments for a date range.
get_rfm_segment_breakdown
ChatGPTGet aggregated KPI breakdowns across all RFM segments for a date range.
get_rfm_segment_customers
ChatGPTGet a paginated list of customers scoped to a specific customer type or segment.
get_rfm_segment_customers
ChatGPTGet a paginated list of customers scoped to a specific customer type or segment.
get_rfm_segment_demography
ChatGPTGet demographic statistics for the customers in a single RFM segment.
get_rfm_segment_demography
ChatGPTGet demographic statistics for the customers in a single RFM segment.
get_rfm_segment_summary
ChatGPTGet summary KPI cards for a single RFM segment in a date range.
get_rfm_segment_summary
ChatGPTGet summary KPI cards for a single RFM segment in a date range.
get_rfm_segments
ChatGPTGet stats for each RFM segment within a given date range, including sales, customer and order counts, AOV, and CLV.
get_rfm_segments
ChatGPTGet stats for each RFM segment within a given date range, including sales, customer and order counts, AOV, and CLV.
get_rfm_stats
ChatGPTGet a list of RFM segment definitions and their current customer statistics.
get_rfm_stats
ChatGPTGet a list of RFM segment definitions and their current customer statistics.
get_rfm_summary_boxes
ChatGPTGet total customer summary metrics including customer counts, AOV, and CLV.
get_rfm_summary_boxes
ChatGPTGet total customer summary metrics including customer counts, AOV, and CLV.
get_sales_performance_metrics_breakdown
ChatGPTGet a full metric breakdown for sales metric in a given date range with compare period.
get_sales_performance_metrics_breakdown
ChatGPTGet a full metric breakdown for sales metric in a given date range with compare period.
get_sales_performance_stats
ChatGPTGet time-series data for basic sales metrics for a date range.
get_sales_performance_stats
ChatGPTGet time-series data for basic sales metrics for a date range.
get_sales_performance_summary
ChatGPTGet key sales performance metrics for a date range, including comparisons with the compare period provided.
get_sales_performance_summary
ChatGPTGet key sales performance metrics for a date range, including comparisons with the compare period provided.
get_sales_performance_top_locations_and_channels
ChatGPTGet a leaderboard of top locations or channels by sales performance.
get_sales_performance_top_locations_and_channels
ChatGPTGet a leaderboard of top locations or channels by sales performance.
get_sales_products
ChatGPTFind products and inspect their performance over a date range, with optional search and sorting.
get_sales_products
ChatGPTFind products and inspect their performance over a date range, with optional search and sorting.
get_sales_products_top
ChatGPTGet top-performing products in a date range with comparison period and optional filters.
get_sales_products_top
ChatGPTGet top-performing products in a date range with comparison period and optional filters.
get_sync_stats
ChatGPTGet the readiness counts of orders, customers, and gross sales currently indexed for the workspace.
get_sync_stats
ChatGPTGet the readiness counts of orders, customers, and gross sales currently indexed for the workspace.
get_top_10_product_category_breakdown
ChatGPTGet top 10 product category breakdown (table and chart) for sales across current and comparison periods.
get_top_10_product_category_breakdown
ChatGPTGet top 10 product category breakdown (table and chart) for sales across current and comparison periods.
get_tracker_breakdown
ChatGPTGet a breakdown table of channels and sources with attribution weights.
get_tracker_breakdown
ChatGPTGet a breakdown table of channels and sources with attribution weights.
get_tracker_channels
ChatGPTGet a new vs existing split per marketing channel for orders or customers.
get_tracker_channels
ChatGPTGet a new vs existing split per marketing channel for orders or customers.
get_tracker_source_medium
ChatGPTGet attribution-ranked rows for the chosen source/medium dimension.
get_tracker_source_medium
ChatGPTGet attribution-ranked rows for the chosen source/medium dimension.
get_tracker_stats
ChatGPTGet top-level tracker KPIs including channels count, conversions, customers, and top converters.
get_tracker_stats
ChatGPTGet top-level tracker KPIs including channels count, conversions, customers, and top converters.
get_trends_mat_current_financial_year
ChatGPTGet the current financial-year Moving Annual Total (MAT) forecast dataset.
get_trends_mat_current_financial_year
ChatGPTGet the current financial-year Moving Annual Total (MAT) forecast dataset.
get_trends_mat_last_year
ChatGPTGet the last-two-years weekly Moving Annual Total (MAT) trend dataset.
get_trends_mat_last_year
ChatGPTGet the last-two-years weekly Moving Annual Total (MAT) trend dataset.
