# "Adds to Cart" Not Available via Looker Data Connector
**URL:** https://community.piwik.pro/t/adds-to-cart-not-available-via-looker-data-connector/2454
**Category:** Reports and working with data
**Created:** [June 26, 2023, 7:11pm UTC](https://community.piwik.pro/t/adds-to-cart-not-available-via-looker-data-connector/2454 "2023-06-26T19:11:34Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@David\_Culbertson](https://community.piwik.pro/u/David_Culbertson)
#### Post date: [June 26, 2023, 7:11pm UTC](https://community.piwik.pro/t/adds-to-cart-not-available-via-looker-data-connector/2454/1 "2023-06-26T19:11:34Z")
Hello,
I am trying to add the metric “Adds to cart” to a report in Looker but it does not appear as an available metric. The metric IS available in PP natively (crimsoncup.piwik.pro).
---
### Author:  [@asinior](https://community.piwik.pro/u/asinior)
#### Post date: [June 27, 2023, 8:55am UTC](https://community.piwik.pro/t/adds-to-cart-not-available-via-looker-data-connector/2454/2 "2023-06-27T08:55:04Z")
Hi,
While it is true that the metric is available natively, there is still no ecommerce metrics implemented in the PP - Looker studio integration. Our integrations team is highly prioritizing this one and soon there should be more updates on this matter.
---
### Author:  [@David\_Culbertson](https://community.piwik.pro/u/David_Culbertson)
#### Post date: [June 27, 2023, 8:02pm UTC](https://community.piwik.pro/t/adds-to-cart-not-available-via-looker-data-connector/2454/3 "2023-06-27T20:02:01Z")
@asinior,
Thanks for the response. That’s something that I look forward but I seem to have discovered a calculated field in Looker that provides a similar number:
sum(Ecommerce conversions)+sum(Ecommerce abandoned carts)
In PP natively, this formula seems to be accurate so I recreated it in Looker.
---
### Author:  [@Jarek](https://community.piwik.pro/u/Jarek)
#### Post date: [June 29, 2023, 7:20am UTC](https://community.piwik.pro/t/adds-to-cart-not-available-via-looker-data-connector/2454/4 "2023-06-29T07:20:59Z")
> That’s something that I look forward but I seem to have discovered a calculated field in Looker that provides a similar number:
> sum(Ecommerce conversions)+sum(Ecommerce abandoned carts)
It can be similar to the number of cart additions but that really depends on the shopping behaviour. If you have implemented the new `Add to cart` event then I would expect that its number would be higher than your formula. As a workaround, it can be good enough though.
---
### Author:  [@David\_Culbertson](https://community.piwik.pro/u/David_Culbertson)
#### Post date: [June 29, 2023, 10:47am UTC](https://community.piwik.pro/t/adds-to-cart-not-available-via-looker-data-connector/2454/5 "2023-06-29T10:47:16Z")
I forgot to add that, in this use, I added a filter for subtotal to match on one specific product that has a unique price.