Calculate the figure Klaviyo shows as Business Revenue in business review dashbaord through Claude?

Question

I’ve made some strides in automating my weekly lifecycle performance reporting using Claude and the Klaviyo MCP connector, but there is still one major block for me: Claude can’t seem to access the figure shown in the Klaviyo Business Review Dashboard that is total business revenue (attributed and unattributed). This is basically the foundational figure for the entire report that all other attribution metrics are based on. So I can’t automate this task fully -- I still need to pull up Klaviyo every monday morning, go to the Business Review Dashboard, record the figure in Claude to kick the whole process off.

The figure is not accessible through API because it’s a dashboard view, and Claude can’t seem to figure out exactly how Klaviyo is calculating this total. When Claude does an independent totaling of the conversion metric that we use, it is always off from what Klaviyo is showing. The business review dashboard is using the same date range that Claude is pulling from.

Does anyone know exactly how Klaviyo calculates this figure and why this figure can’t be recreated elsewhere?

ArpitBanjara · Answer

Hey ​@JbrizYou can get this number without copying it by hand. The total revenue on the business review dashboard is simply all the money from your orders in that date range, both what Klaviyo's emails and texts drove and what came from everywhere else (help article). Klaviyo counts it using one event you choose, usually Placed Order.The Klaviyo MCP connector has a tool that can total up Placed Order revenue for a date range, called query_metric_aggregates.(MCP tools list). Ask Claude to use that tool instead of adding up orders one by one, since it can miss some that way. If the number is still off, tell Claude to use the same timezone your Klaviyo account uses, not UTC. Also have it end the range at midnight after your last day, so the last day isn't cut short. And check that the dashboard is counting the same event Claude is using.If it still doesn't match, can you share roughly how big the gap is and whether it's about the same every week?I hope this helps and thank you for sharing your question here in the community.CheersArpit.

Sign up

Use your Klaviyo credentials

Log in to the Community

Use your Klaviyo credentials