1

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?

Linda Lawton - DaImTo
  • 106,405
  • 32
  • 180
  • 449
Deep Sojitra
  • 85
  • 1
  • 11

1 Answers1

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.

Linda Lawton - DaImTo
  • 106,405
  • 32
  • 180
  • 449
  • Thank You DaImTo for answering my question. Can I use Data Import in Google Analytics? is it same functionalities? – Deep Sojitra Oct 26 '20 at 05:39
  • 1
    Data imports is tricky i suggest you read up on the documentation. Only you will know if this is something you can use as you know what this file contains for data you cant just upload a random file it needs to make sense in order to preform any analytics upon it. – Linda Lawton - DaImTo Oct 26 '20 at 09:15