Hello Supermetrics Support,

We’re using the Shopify → BigQuery connector. Our current exports include Returns at the order/line level but do not include refund timestamps. As a result, we can only attribute refunds to the order date, which does not match Shopify’s Analytics (which attributes refunds on the refund date). This causes material discrepancies in daily Net Sales and share metrics.

We’d like to request a new Transactions / Refunds dataset (or an extension to the existing Shopify schema) with event-level refund rows and the following minimum fields:

Required fields

• order_id (Shopify order ID)

• transaction_id (if available)

• transaction_kind (e.g., refund, refund_sale, etc.)

• processed_at (refund timestamp; created_at also acceptable)

• amount (refund amount; positive number preferred or documented sign convention)

• currency (shop currency of the transaction)

• (optional but helpful) reason, payment_gateway, user_id (who processed it)

If there’s an existing way to get this via your connector (e.g., a hidden “Transactions” report type or different field set), please point us to it. Otherwise, we’d appreciate this enhancement or guidance on the best available alternative.

Thank you!