Hi All.
We've had mostly positive experiences with the new Google Ads Transfer service to pull in client data to BigQuery to use for reporting. However starting yesterday (May 4, 2023), we've been getting errors of two types (examples below) for some scheduled transfers. What's rather peculiar is that we may have 3 days of data process just fine, get an error for the next day, and then have a subsequent day be successful. Completely unpredictable.
The error messages seem to come in two varieties:
Error while reading data, error message: CSV table references column position 26, but line starting at position:544 contains only 24 columns. File: gs://513030992809-us/2479980046/20230503/64632d5a-0000-2020-bb91-001a1143f424/20230504111506_1683198906241973581/LocationsUserLocationsStats_tmp_0; JobID: 1040889383827:google_ads_64634cbe-0000-2b29-bac7-94eb2c09abf2
and
Error while reading data, error message: Too many values in row starting at position: 586. Found 27 column(s) while expected 24. File: gs://513030992809-us/2479980046/20230502/64632d5c-0000-2020-bb91-001a1143f424/20230504114502_1683200702036460405/LocationsUserLocationsStats_tmp_0; JobID: 1040889383827:google_ads_64638f98-0000-2b29-bac7-94eb2c09abf2
I haven't updated any settings in the transfers, so I'm really not sure why we'd suddenly see what seems like structural issues when importing data from Google to Google. It does seem like the common element is that it's the user locations stats data.
Has anyone else experienced this and possibly know of a remedy? Not much I've been able to figure out beyond retrying the transfer and crossing my fingers.
LinkedIn
Twitter
