DATA Step, Macro, Functions and more

How to pull out segmented data from Google analytics?

Reply
New Contributor
Posts: 2

How to pull out segmented data from Google analytics?

[ Edited ]

Is there someone who has experience in pulling out data straight from Google Analytics? At the moment I am exporting data from analytics & save it in an excel format (for example) then upload to SAS VA. But what I am actually looking for is to be able to extract data straight from Google analyitcs. I know that this is possible through Google API but there is no option to pull out segmented data that i have in my Google Analytics account.

 

Any workaround idea is welcome too!

 

Thanks!

 

Evelyn Casio

 


import SAS VA.PNGGA segment.PNG
Regular Contributor
Posts: 212

Re: How to pull out segmented data from Google analytics?

Hi mate.

 

Maybe this can help you, check When Google Analytics meets SAS or Import Data from Google Analytics (Page 30).

 

Import Data from Google Analytics

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: n 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.

 

Hope this helps

Ask a Question
Discussion stats
  • 1 reply
  • 225 views
  • 0 likes
  • 2 in conversation