Import Data from Google Analytics

To begin importing data from Google Analytics, your administrator must give you access. Contact your administrator and provide your Google Analytics account information. Administrators must give access using the Google Analytics website. The drop-down menu options for the Analytics account, Property, and View (Profile) fields in the Import Google Analytics window will be based on the type of access that your administrator assigns to you. To import data from Google Analytics:
  1. Click Google Analytics in the Import Data window.
  2. Click Obtain access code in the Import Google Analytics window. The Google Analytics service opens in a new window.
  3. After signing in with your Google user name and password, click Accept to accept the terms and conditions.
  4. Highlight and copy (Ctrl+C) the access code.
  5. Navigate back to SAS Visual Analytics. Paste the code (Ctrl+V) in the Paste access code here field.
  6. Click OK. The Import Google Analytics window appears.
    If you would like to change users or remove authorization after completing this step, click Clear Sign In Information on the lower left-hand side of the Import Google Analytics window.
  7. (Optional) Modify the fields and date range based on the data that you would like to import.
    Note: The default value for the maximum number of rows that you can import is 100,000. For more information, contact your administrator.
  8. (Optional) In the LASR Table section, modify the table name and description. Review the library and location settings by clicking Advanced. Make any necessary changes.
    You do not have access to the Advanced section if you are using the explorer or designer and do not have the Build Data capability. Instead, you can import the data to a general-purpose area or select Store the table in a private location to prevent other users from accessing the data.
  9. (Optional) Review the Proxy Server section. Make any necessary changes.
  10. Click OK.
Note: As an attempt to decrease the processing time of your import, Google Analytics sometimes returns sampled data. If this occurs, you will receive a warning message. A column that indicates that the data is sampled will appear in the table. To increase your chance of getting a complete data set, try rerunning the import with a smaller date range.
Note: If you want to reload data for an existing table using the same table name, you must do one of the following:
  • Use the same library and output folder that were used when the table was originally imported.
  • Indicate both a different library and a different output folder than when the table was originally imported.
Note: It is recommended that your SAS server be configured to use UTF-8 encoding while importing data from Google Analytics. Otherwise, it could impact your ability to import data that includes nonstandard ASCII characters.
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: January 8, 2019