google-analytics

Google analytics exporting numbers


I am exporting a report from Google analytics. The numbers for example for users is shown as 10,907,302 in the report and when I do an export to a csv file it is shown as "10,907,302". I did not expect the commas to be exported as well. Yes, I know I can do a query replace in the csv file but there are other columns there that contains strings with comma in them. Is there a way to export the data without the comma delimter per 1000 for the numbers fields?


Solution

  • Thank you for the answers. I found out that in Bigquery I could define this field as an INTEGER with the json format for the table and then the comma in the number was removed.