Uploading data

To upload data in Google Analytics from Google Sheets, please complete the following steps:

  • Create a new data set in Google Analytics (or use an existing one).
  • Create a new Google Sheets table (or use an existing one).
  • Set all the key values in the Google Sheets table.

The table structure is determined by a data set you used. To get data pattern in a .csv format, navigate to the dataset settings in your Google Analytics account and click Get schema.

A .csv file lists the variables separated with commas within a single cell. Split the given list into columns. You will need to complete each of these columns with the relevant values later on. 

For instance,

table_example.png

ga:date β€” date related to an ad cost in format YYYYMMDD (e.g., January 14, 2015 β€” 20150114);

ga:source β€” the origin of the traffic;

ga:medium β€” the category of the source;

ga:adCost β€” cost listed in a currency of your Google Analytics (use point as a decimal separator).

  • After filling out the Google Sheets table with data, navigate Add-ons > OWOX BI Data Upload > Upload data.

  • Specify GA Account, Web Property, and Dataset on the add-on sidebar.
  • To confirm, click Verify & Upload
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.