Sales amount

{
  "digitalData": {
    "transaction": {
      "total": {
        "value": 0,
        "currency": "USD"
      }
    }
  }
}

{
  "event": "purchase",
  "ecommerce": {
    "value": 0,
    "currency": "USD",
    "transaction_id": ""
  }
}

{
  "event": "purchase",
  "ecommerce": {
    "transaction": {
      "total": {
        "value": 0,
        "currency": "USD"
      }
    }
  }
}

{
  "_experience": {
    "analytics": {
      "event1": {
        "value": 0,
        "currencyCode": "USD"
      }
    }
  }
}

-- ==========================================
-- 1. GOOGLE BIGQUERY SQL
-- ==========================================
SELECT
  event_date,
  SUM(ecommerce.value) AS total_sales_amount
FROM
  `your-project.analytics_123456789.events_*`
WHERE
  event_name = 'purchase'
  AND ecommerce.value IS NOT NULL
GROUP BY
  event_date
ORDER BY
  event_date;

-- ==========================================
-- 2. ADOBE AEP QUERY SERVICE SQL
-- ==========================================
SELECT
  CAST(eventTimestamp AS DATE) AS event_date,
  SUM(ecommerce.transaction.total.value) AS total_sales_amount
FROM
  aep_backend_dataset
WHERE
  event = 'purchase'
  AND ecommerce.transaction.total.value IS NOT NULL
GROUP BY
  CAST(eventTimestamp AS DATE)
ORDER BY
  event_date;