Send sas data to google Analytic for optimisation

[Agogo]

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.

[PGStats]

Are you expecting Google to do better than SAS?

[Agogo]

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.

[Agogo]

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.

[ChrisHemedinger]

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.

[Agogo]

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/

[ChrisHemedinger]

@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.

[Agogo]

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

very much appreciated