1. Home
  2. Knowledge Base
  3. Universal Analytics Backup
  4. Troubleshooting Common Errors in the Looker Studio UA Backup Report

Common Errors with the UA Backup and Looker Studio Reports

This article is about common issues that can be encountered when generating a UA backup or connecting that backup to the Looker Studio reports. If you can't find the solution to your problem in this article or our knowledge base, please contact our support team

This article relates to the Universal Analytics Backup Utility offered by Analytics Canvas. 

Failed to parse input string in Looker Studio Report

In Looker Studio there is a bug where the data type of a given column in a data source will change from the correct type to a Date data type.  When that happens, the user will see the error "Failed to parse input string".  The solution is quite simple and outlined below.
Image

If you see the error above, click EDIT on the report, thego to the Data Source and identify the column that is causing the issue. 

Image

Edit the data source, then change the data type from Date to Number.

Image

Edit the metric setting on the scorecard. 

Image

Finally change the aggregation type from Count to Sum.

Image

The component should now load correctly. 

Was this article helpful?

Related Tutorials/Video