# Data Studio (Looker) connector e-commerce data

**URL:** <https://community.piwik.pro/t/data-studio-looker-connector-e-commerce-data/563>\
**Category:** API & integrations\
**Created:** [April 6, 2022, 7:52am UTC](https://community.piwik.pro/t/data-studio-looker-connector-e-commerce-data/563 "2022-04-06T07:52:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![michiel](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/michiel/32/236_2.png) [@michiel](https://community.piwik.pro/u/michiel)\
**Post date:** [April 6, 2022, 7:52am UTC](https://community.piwik.pro/t/data-studio-looker-connector-e-commerce-data/563/1 "2022-04-06T07:52:12Z")

</div>

Hey there!  
I’m using the Google Data Studio connector to pull Piwik data into a dashboard. However, when I try to add product name combined with unique purchases and revenue I get the following error message:

![Screenshot 2022-04-06 094849](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/1X/83f0f3e08aea6a337ab53d7eec479080052f6451.png)

These are the dimensions and metrics I added to the table:

![Screenshot 2022-04-06 095005](https://europe1.discourse-cdn.com/flex005/uploads/piwikpro/original/1X/70def84f7d9e76785e7891a8582baa272de35119.png)

Is this a know limitation of the Data Studio connector? And is it correct that there is no product name dimension available? Or am I missing something here?

---

<div class="post-metadata">

**Author:** ![Piotrek](https://dub1.discourse-cdn.com/flex005/user_avatar/community.piwik.pro/piotrek/32/160_2.png) [@Piotrek](https://community.piwik.pro/u/Piotrek)\
**Post date:** [April 13, 2022, 2:13pm UTC](https://community.piwik.pro/t/data-studio-looker-connector-e-commerce-data/563/2 "2022-04-13T14:13:37Z")

</div>

Hello @michiel,

Apologies for leaving you without an answer for so long.

We’ve checked and right now this is a known limitation of our Google Data Studio connector. We’ll add better support for ecommerce metrics and dimensions in the future but in the meantime, we are also planning to improve error handling so that it’s more clear which dimensions can be used without limitations.

To add more detail, our ecommerce metrics can’t be used in more complex queries in the Google Data Studio connector, similarly to how they work right now in Analytics reports.

---

<div class="post-metadata">

**Author:** ![Ralf](https://avatars.discourse-cdn.com/v4/letter/r/c89c15/32.png) [@Ralf](https://community.piwik.pro/u/Ralf)\
**Post date:** [April 14, 2023, 3:55pm UTC](https://community.piwik.pro/t/data-studio-looker-connector-e-commerce-data/563/3 "2023-04-14T15:55:50Z")

</div>

Hi @Piotrek  
are there any news on this topic?  
thx