![](https://martin-grellmann.de/wp-content/uploads/2021/12/Google-Analytics-Ecommerce-Transaktions-Bericht-1280x795.png)
Im Ecommerce-Transaktions-Bericht finden Sie Daten über die Leistung Ihrer E-Commerce-Aktivitäten, segmentiert nach Transaktions-ID.
-- this query will not return quantity data as there is no standard ecommerce product data available in the sample data set
select
hits.transaction.transactionid,
ifnull(sum(hits.transaction.transactionrevenue)/1000000,0) as revenue,
ifnull(sum(hits.transaction.transactiontax)/1000000,0) as tax,
ifnull(sum(hits.transaction.transactionshipping)/1000000,0) as shipping,
ifnull(sum(hits.item.itemquantity),0) as quantity
from
`bigquery-public-data.google_analytics_sample.ga_sessions_20160801`,
unnest(hits) as hits
where
totals.visits = 1
and hits.transaction.transactionid is not null
group by
transactionid
order by
revenue desc
![](https://martin-grellmann.de/wp-content/uploads/2021/12/Big-Query-Tabelle-und-Abfrage-8.png)