Help using Base SAS procedures

Send sas data to google Analytic for optimisation

Reply
Occasional Contributor
Posts: 9

Send sas data to google Analytic for optimisation

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.

Respected Advisor
Posts: 4,654

Re: Send sas data to google Analytic for optimisation

Are you expecting Google to do better than SAS?

PG
Occasional Contributor
Posts: 9

Re: Send sas data to google Analytic for optimisation

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.

Occasional Contributor
Posts: 9

Re: data to google Analytic for optimisation

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.

Community Manager
Posts: 2,766

Re: data to google Analytic for optimisation

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.

Occasional Contributor
Posts: 9

Re: data to google Analytic for optimisation

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/

Community Manager
Posts: 2,766

Re: data to google Analytic for optimisation

[ Edited ]

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

Occasional Contributor
Posts: 9

Re: data to google Analytic for optimisation

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

 

very much appreciated

 

 

Ask a Question
Discussion stats
  • 7 replies
  • 385 views
  • 0 likes
  • 3 in conversation