To import data from
Google Analytics:
-
Click
Google
Analytics in the
Import Data window.
-
Click
Obtain
access code in the
Import Google Analytics window.
The Google Analytics service opens in a new window.
-
After signing in with
your Google user name and password, click
Accept to
accept the terms and conditions.
-
-
Navigate back to SAS
Visual Analytics. Paste the code (Ctrl+V) in the
Paste
access code here field.
-
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.
-
(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.
-
(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.
-
(Optional) Review the
Proxy
Server section. Make any necessary changes.
-
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.