analytics

Live server: available on mcp.solvimon.com as well as on the test server.

Read-only queries over dashboard data: revenue (by product, plan, currency, month), MRR/ARR, churn and customer movement, usage, deferred and recognised revenue, and growth. Use the three actions in sequence:

1. list_datasets returns available datasets and their datasetId
2. list_fields returns each model’s dimensions and measures in model.field form
3. query runs the query: {datasetId, measures[], dimensions[], filters[], timeDimensions[], order[][], limit}

The optional customer_id parameter scopes results to one or more customers (comma-separated).

{
  "action": "query",
  "query": {
    "datasetId": "dast_Vc7wPx3TnR8mKq5YbJd92",
    "measures": ["invoice_v2.invoice_line_base_rep_amount_sum"],
    "dimensions": ["invoice_v2.product_names"]
  }
}