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:
-
-
Click
Obtain access code in the
Import Google Analytics window.
The Google Analytics service opens in a new window.
-
-
-
-
Click OK.
The Import Google Analytics window appears.
-
(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.