Sunday, 14 April 2013

Talend: Using tGoogleAnalyticsInput component to fetch dimension and metrics from ga (google analytics)






Problem - Using tGoogleAnalyticsInput component to get data from google analytics in form of dimension and metrics

Solution -  As a per-requisite you have to download tGoogleAnalyticsInput component from talendforge exchange.
http://www.talendforge.org/exchange/?eid=537&product=tos&action=view&nav=1,1,1

Next you have to install this component into your talend installation - by using options mentioned in talendforge exchange.
Once you have done that - all you have to do is drag and drop this component into your job and then enter details required for authentication and data you need.

Service Account Email - "youruniqueid@developer.gserviceaccount.com"
keyFile (*.p12)  - your privatekey.p12 file - give its location
profile-ID - profile id as obtained from google analytics (ga)
start date- date from which you want data from ga
end date - date to which you want data from ga
dimensions - dimensions you need separated by comma like "ga:visitorType, ga:visitCount, ga:daysSinceLastVisit"
Metrics - facts you need to measure against above dimensios like "ga:visitors, ga:newVisits, ga:percentNewVisits"

Make sure your schema definition matches with you dimension and metics name in order as give below




results
schema