Google Analytics Importing sales data

[sober]

Hello,

I'm trying to connect to GA as I want to analyze our sales transactions.

I have found a folder "ECommerce", which I guess holds the sales data.

I haven't been able to find any dimensions and metrics, that I can import. 

I have taken a look in the reference list of Googles Reorting API v4 and saw metrics with for example ItemRevenue, which should be usefull.

Anyone, who know how to do and which tables to choose.

[v-yuezhe-msft]

Hi @sober,

Could you please post a screenshot about your scenario? Are you able to import the dimensions and metrics in other folders?

In my environment, dimensions and metrics are available in "ECommerce" folder, you can check the following screenshot.

Thanks,
Lydia Zhang

[sober]

Hi Lydia,

My Ecommerce folder looks like Yours.

Sorry, I can't figure out how to insert a screendump.

I have selected the metrics Revenue and the dimension Product Category and get this message:

DataSourceError: Selected dimensions and metrics cannot be queried together.

I am able to import for example metrics from the folder ADwords.

Thanks,

[v-yuezhe-msft · Accepted solution]

Hi @sober,

As indicated in the above error message, they cannot be queried together, you can select Product category and Product revenue instead. And in this link, roll over each dimension under Ecommerce and select its checkbox to see all the other metrics that can be combined in the same query.

Thanks,
Lydia Zhang