Data Studio
1.8K members online now
1.8K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Data Upload issue: wrong format for product scope metric

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi community, 

 

I am struggeling around with GA data upload feature and hope you can help me further with this. 

 

I am using data upload to upload buying price for all my products: Custom Metric "BuyingPrice" with product scope

For that I used the "product data" data set type with product SKY as key and my custom metric #4 as imported data. I downloaded the schema, fullfilled it with the data and uploaded it to GA - without any errors (juhu).

But when I created my custom report to have a look on the uploaded data I saw huuuugh amounts of data - way too big. After long time of troubleshooting I regognized that GA interpredet data wrong: I uploaded e.g. 33.40 and GA transformed it to 3340. For all my data. :'( 

 

Example from my file (as I can't upload it...): 

gaSmiley TongueroductSku,ga:metric4
109622,33.40
109637,15.80
109632,12.45

 

Example after upload in GA: 

gaSmiley TongueroductSku,ga:metric4
109622,3340
109637,1580
109632,1245

 

Does anybody have any idea how I can upload the data right? 

 

Thanks in advance and br, 

 

Michaela