Aligning Total Sales in Shopify Analytics to Fivetran API

Shopify Apps
1

Hi everyone,

Hope you’re well, does anyone have any experience using the shopify data connector into a dashboard?

I cannot seem to get the total sales to align with what’s in Shopify analytics can anyone help? I am currently using the daily shop model and using the order_adjusted_total - refund_subtotal but I am around 2-3% out.

Do you know what metrics I should be using?

Thanks!

2

Did you make much progress on this? I’m facing the same issue and want to reconcile data from our Fivetran Connector to a Report in Shopify Analytics, however, I can’t get any metrics to match. Even foundational metrics such as order count, quantity ordered and net units sold