AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
2.8K members online now
2.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