Showing posts with label talend get data from google analytics. Show all posts
Showing posts with label talend get data from google analytics. Show all posts

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