topic Re: Send sas data to google Analytic for optimisation in SAS Procedures

Send sas data to google Analytic for optimisation

Agogo — Wed, 29 Jun 2016 16:30:10 GMT

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.

Re: Send sas data to google Analytic for optimisation

PGStats — Wed, 29 Jun 2016 17:44:16 GMT

Are you expecting Google to do better than SAS?

Re: Send sas data to google Analytic for optimisation

Agogo — Wed, 29 Jun 2016 20:15:43 GMT

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.

Re: data to google Analytic for optimisation

Agogo — Wed, 29 Jun 2016 20:19:44 GMT

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.

Re: data to google Analytic for optimisation

ChrisHemedinger — Wed, 29 Jun 2016 20:33:43 GMT

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.

Re: data to google Analytic for optimisation

Agogo — Wed, 29 Jun 2016 21:07:42 GMT

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/

Re: data to google Analytic for optimisation

ChrisHemedinger — Thu, 30 Jun 2016 12:26:22 GMT

@Agogo,

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.

Re: data to google Analytic for optimisation

Agogo — Fri, 01 Jul 2016 11:00:55 GMT

Thanks Chris, I am going to play with it monday when i am back in the office.

very much appreciated