Push data to Google Analytics

Question

My client send me spreadsheet that contains all the transactions. Now I have to push those sheet data in Google Analytics, So How can I push those data in Google Analytics? Should I have to create a PHP Script that will read from spreadsheet and push to Google Analytics?

Answer 1

Depending upon how this data looks. You should look into the Measurement protocol which will allow you to send additional hits to Google analytics make sure that you check the qt parameter which will allow you to set the time that the hit came in. There is no library for this you will have to code these calls yourself.

In the even that this is custom data then you could also upload it directly. You can use the Google api php client library for this to help you with your calls.

In either case yes your going to have to read the speedsheet yourself and then create the code in which ever language you choose to upload it.