Google Analytics visits data
- Connect to the Google Analytics console
- Go to Audience / Overview
- Select a daily view
- Select the full date range (start of the business to today)
- Export with the CSV format
Once downloaded, you will need to modify the file manually. Open the file with a text editor, and delete all the empty lines and the lines starting with # in the header of the file.
Also, check the last line of the file. if may be buggy as it is the current day. If this is not formatted correclty, remove it before the import.