tGoogleAnalyticsInput help required.

[Anonymous]

Hi,
I want to fetch Google Analytics (GA) data. For this, my friend added my google email as a user to his website GA. Now i can view his GA reports through my id. So this part is done.
I want to discuss three fields of tGoogleAnalyticsInput,
1.Application Name: Although it is not required but what should i enter here?
2.Service Account Email: i have given my google email address here as it has already been added as mentioned above.
3.Key File (*.p12): This is what confuses me. I've generated a p12 key file by turning my Analytics API to ON and following the required process.
My question is related to the 3rd field. Should i use p12 file that i generated or should i ask my friend to provide me his p12 key file?
any idea? Thanks in advance.
regards,
abdul.

[Anonymous]

I will check that this evening. By for now.

[Anonymous]

hi, I am getting same error here:
Starting job gavstack at 13:11 09/09/2016.
connecting to socket on port 3426
connected
DEBUG:add dimension: {name=ga:date}
DEBUG:add metric: {expression=ga:sessions}
Exception in component tGoogleAnalyticsInput_1
java.lang.NullPointerException
at de.jlo.talendcomp.google.analytics.v4.GoogleAnalyticsInput.containsSampledData(GoogleAnalyticsInput.java:655)
 
disconnected

[Anonymous]

I have found a possible reason. I am working on the update and will publish it today on Talend Exchange.

[Anonymous]

I have finished the update and my tests are suceeded.
For early access please use this download link:
http://jan-lolling.de/talend/components/tGoogleAnalyticsInput.zip
I will also update the component in Talend Exchange.

[Anonymous]

it worked thanks a lot .........  

[krengan21]

Hi @lli

How to extract all the dimensions and metrics using this component any idea on how to do that ? 

Thanks and Regards,

Kasthuri Rengan

[Anonymous]

Could you please a bit more concrete?

There are 2 modi:

Plain mode: here you define your dimensions and metrics and configure the schema according to them (first the dimensions, than the metrics).

Normalized mode: Here you will get dimensions and metrics as separate flows with a row-number to join both. This allows you to define a query and you do not have to configure the schemas with the knowledge of the requested dimensions or metrics.

Both ways are described in the documentation (linked in the component in Talend Exchange.

I have just added the documentation here as attachment.

tGoogleAnalyticsInput.pdf

[Anonymous]

If you want to get all available dimensions and metrics please checkout the component tGoogleAnalyticsManagement (also available in Talend Exchange).

This component provides all necessary information about your account, views and properties and also about all dimensions and metrics. 

[krengan21]

Hi @lli

I went through the documentation as per the document the metrics field seems to compulsory but according to the google Analytics API for some of the attributes they didn't give any kind of metrics how to process that kind of attributes using tgoogleanalytics input component .Please find the below link of Google Analytics API 

https://developers.google.com/analytics/devguides/reporting/core/dimsmets#segments=true&cats=platfor...

Thanks and Regards,

kasthuri 

[Anonymous]

I did not recognize your problem. You have dimensions and metrics - thats it. You can combine them.

I guess you missunderstand what the API explorer want to tell you. You can always add the dimensions like platform to you query as dimension, there are simply no platform dedicated (or specialized) metrics. But this does not mean you can only combine dimensions and metrics of the same category.

Play a bit with the API explorer and test your query there.