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
2K members online now
2K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

File Upload CSV File - Silent Error Parsing Integer With Quotes At End Of Line Only

Follower ✭ ✭ ☆
# 1
Follower ✭ ✭ ☆

The following uploads and verifies as correct even though ROW 2 is imported with the last column set to zero....

 

Date,Advertiser,Advertiser_ID,Insertion_Order,Insertion_Order_ID,Creative,Creative_ID,Sizmek_ID,Revenue,Viewable_Impressions,Total_Net_Measured_Impressions

3/8/2017,A,966539,B,2901128,C,36453676,19966088,383,"589,534",1001

3/8/2017,A,966539,B,2901128,C,36453676,19966088,365,"589,534","1,010"

3/8/2017,A,966539,B,2901128,C,36453676,19966088,383,"589,534",1100

 

Row #2 will import but the last column is set to 0 instead of "1,010".  No errors no flags.  This only happens to quoted numbers at the end of a row. In the image below the last column should be 3,111 but its 2,102.

 

Screen Shot 2017-03-08 at 8.00.03 AM.png