Forum Discussion

Regular Visitor

9 years ago

Solved

Google Analytics Importing sales data

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.

Anonymous
9 years ago
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

3 Replies

Anonymous
Not applicable
9 years ago

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
  Regular Visitor
  9 years ago
  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,
  - Anonymous
    Not applicable
    9 years ago
    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