Analytics
4.4K members online now
4.4K members online now
Dive into multiple domain (Cross/Sub) tracking, implementing Ecommerce and Enhanced Ecommerce, setting up Event tracking, and Universal Analytics code.
 
Guide Me
star_border
Reply

Data Upload failing on blank strings

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi all, a data upload has started failing on empty strings in the csv file.

 

As per Google's documentation (https://support.google.com/analytics/answer/6016094?hl=en#empty_strings), the empty strings are fields in the import file that has no value between separating commas. E.g.,

 

ga:campaignCode,ga:medium,ga:source,ga:campaign,ga:adGroup,ga:adContent,ga:keyword,ga:dimension5,ga:dimension6
1000002,display,facebook.com,4dwknd,,60% Off Towels,,link page post ,

This example line is failing on columns 5, 7 and 9.

 

If I do a diff between a version of the file which previously imported successfully and the current version, rows which were fine are now failing with no changes to the content of those rows.

 

Has anyone experienced this issue, are there known workarounds?

1 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author Ryan W
August 2016

Re: Data Upload failing on blank strings

Visitor ✭ ✭ ✭
# 16
Visitor ✭ ✭ ✭
Hi all, I contacted GA Support via chat on this site: https://support.google.com/analytics/?hl=en#topic=3544906

They escalated to Google’s Specialist GA team, who had to fix something on their side.

I’ve just uploaded the sheet and it now imports successfully.

I referred GA Support to this thread for details on the issue, if you contact them this may help speed up the process for you. They made the fix within 24 hours.

View solution in original post

Re: Data Upload failing on blank strings

Top Contributor
# 2
Top Contributor
From the example given,
Is there a comma missing at the end to signify an empty string for ga:dimension6 ?
eg should it read as: 1000002,display,facebook.com,4dwknd,,60% Off Towels,,link page post,,
There are 9 columns yet only 8 fields
Bronwyn Vourtis, Google Analytics Top Contributor
Was my response helpful? If yes, please mark it as the ‘Best Answer.’ Learn how here

Re: Data Upload failing on blank strings

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
Yes, the comma at the end is for a blank string in that field, the end of
the row is signified by a line break.
--
Ryan

Re: Data Upload failing on blank strings

Visitor ✭ ✭ ✭
# 4
Visitor ✭ ✭ ✭
Sorry I should clarify, there shouldn't be another comma at the end of the example given. This record had successfully imported in the past.

Re: Data Upload failing on blank strings

Top Contributor
# 5
Top Contributor
Thanks :-)
What error(s) is it giving in the Upload manager when you view the errors for the failed upload
Bronwyn Vourtis, Google Analytics Top Contributor
Was my response helpful? If yes, please mark it as the ‘Best Answer.’ Learn how here

Re: Data Upload failing on blank strings

Visitor ✭ ✭ ✭
# 6
Visitor ✭ ✭ ✭

Hi Bronwyn, sorry for the delayed reply.

 

Invalid cell data "" at row 1 column 5. Expected data type: STRING.
Invalid cell data "" at row 1 column 7. Expected data type: STRING.
Invalid cell data "" at row 1 column 9. Expected data type: STRING.
Invalid cell data "" at row 2 column 5. Expected data type: STRING.
Invalid cell data "" at row 2 column 7. Expected data type: STRING.
Invalid cell data "" at row 3 column 5. Expected data type: STRING.
Invalid cell data "" at row 3 column 7. Expected data type: STRING.

In each instance, the column value is a blank string.

Re: Data Upload failing on blank strings

Top Contributor
# 7
Top Contributor

Gday :-)
Whats different between row 1 and row 2? row 2 does not fail at column 9 like row 1 does.
Row 3 doesnt seem to fail on column 9 either.

 

I've had similar things happen in the past when using csv files for other purposes.

Just as a matter of interest,

Have you opened the csv up in excel.. made sure to clear the cells in those columns to ensure there are no strange

characters in those columns and then Saved as file type CSV (Comma delimited) (*.csv)

Bronwyn Vourtis, Google Analytics Top Contributor
Was my response helpful? If yes, please mark it as the ‘Best Answer.’ Learn how here

Re: Data Upload failing on blank strings

Visitor ✭ ✭ ✭
# 8
Visitor ✭ ✭ ✭

Kia ora :-)

 

The differences are which fields contain blank strings on each line:

 

ga:campaignCode,ga:medium,ga:source,ga:campaign,ga:adGroup,ga:adContent,ga:keyword,ga:dimension5,ga:dimension6
1000002,display,facebook.com,4dwknd,,60% Off Towels,,link page post ,
1000003,display,accuen ,4dwknd,,60% Off Towels,,300x250,desktops/mobiles
1000004,display,msn.com,4dwknd,,60% Off Towels,,300x600,homepage

Row 1 has blank strings on 5, 7, 9

Row 2 has blank strings on 5, 7

Row 3 has blank strings on 5, 7

 

I'm assuming that GA removes the header row and that's why Row 2 from the CSV is referred to as Row 1 etc?

 

The CSV is from a Google Sheet, I've opened in Excel and those fields are blank, and haven't been edited since the file successfully imported in the past.

 

Just to be safe I've hit delete on each of those fields in Excel, re-saved as a CSV, re-imported to GA and it failed on those lines again.

 

I may need to just add "not set" instead of blank strings to get the file processed - since this is what appears in reports in place of blank strings, hoping there's no negative impact of doing that?

Re: Data Upload failing on blank strings

Top Contributor
# 9
Top Contributor
That's really strange as I setup my own data import on a test account.. used your example as the header and first row and added some data of my own to the other rows and saw none of the same issues/errors happen with the blank fields.
Bronwyn Vourtis, Google Analytics Top Contributor
Was my response helpful? If yes, please mark it as the ‘Best Answer.’ Learn how here

Re: Data Upload failing on blank strings

Visitor ✭ ✭ ✭
# 10
Visitor ✭ ✭ ✭
Weird, had a friend try a few days ago in his account and he had the same problem as me. I'll give it another go in case it's been resolved behind the scenes.