BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
dave_alscient
Obsidian | Level 7

I am trying to automate the loading of Google Analytics data in VA 7.3. Does anyone know how?

 

In data prep or explorer I can import using the Google Analytics data source option. This works very well but it does ask me for a date range. I want to schedule SAS VA i) perform an initial load ii) Append Google Analytics data daily into the LASR table loaded in i).

 

Thanks.

 

Dave.

1 ACCEPTED SOLUTION

Accepted Solutions
RichardPaterson
Obsidian | Level 7

As already stated you will need to use a custom solution to achieve this. I have achieved this for some clients of ours - one using a custom python script which can be scheduled on the OS scheduler. The second method was using an ODBC driver from the company CDATA - http://www.cdata.com/drivers/ganalytics/odbc/.

 

The first method was very flexible and free. The second method is slightly less flexible and will require a licence. 

 

Richard

View solution in original post

2 REPLIES 2
varsha_sas
SAS Employee

Hi,

The ability to automate pulling out data from Google Analytics can currently only be done through custom code. We found two tools that could make this easier and are worth checking out:

 

http://www.outfox.com/excellentanalytics/

 

http://www.nextanalytics.com/

 

Once you have the GA process automated, you could drop the results into an autoload folder to get them pulled into the LASR server periodically.

 

Hope that helps!

 

 

RichardPaterson
Obsidian | Level 7

As already stated you will need to use a custom solution to achieve this. I have achieved this for some clients of ours - one using a custom python script which can be scheduled on the OS scheduler. The second method was using an ODBC driver from the company CDATA - http://www.cdata.com/drivers/ganalytics/odbc/.

 

The first method was very flexible and free. The second method is slightly less flexible and will require a licence. 

 

Richard

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1748 views
  • 0 likes
  • 3 in conversation