I am trying to send a sas dataset to google analytics for optimisation, has someone done it before or any pointer would be much appreciated.
Thank you in advance.
Are you expecting Google to do better than SAS?
Not really, my marketing department wants to use this data optimisation purposes.
It is a handful of leads that are required to be sent back to google Analytics.
Not really, my marketing department wants to use this data optimisation purposes.
It is a handful of leads that are required to be sent back to google Analytics.
Is this a one-time process? Or something ongoing?
Perhaps if you provide a link to the Google Analytics documentation that describes how this data is to be formatted/sent, someone here can advise how you might transmit the records from your SAS data set appropriately.
Chris, It will be an ongoing process and ideally automated one so any format that is easier would be good.
My understanding is that to do this programmatically I should use the google Analytics measurement protocol
https://developers.google.com/analytics/devguides/collection/protocol/v1/
Thanks for that reference. SAS has a procedure called PROC HTTP that allows you to send data to web sites and interact with web-based APIs like this. I don't have any experience with this Google Analytics API so I can only guess at some things, but here is an example that uses some fields from an example in the Google Analytics developer's guide.
%macro echoResp(fn=);
data _null_;
infile &fn;
input;
put _infile_;
run;
%mend;
filename resp temp;
/*
v=1 // Version.
&tid=UA-XXXXX-Y // Tracking ID / Property ID.
&cid=555 // Anonymous Client ID.
&t= // Hit Type.
*/
proc http
url='http://www.google-analytics.com/v=1&tid=UA-XXXXX-Y&cid=555&t=pageview&dp=%2Fhome'
method='POST'
out=resp
;
run;
/* Echo response content to the log */
%echoResp(resp);
You would need to form one call per record, or you can create a "batch" style call per the Google Analytics guide to issue multiple records within a single HTTP call.
Thanks Chris, I am going to play with it monday when i am back in the office.
very much appreciated
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: