Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tGoogleAnalyticsInput help required.

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.
Labels (2)
45 Replies
Anonymous
Not applicable
Author

Hi,
Attached is my component settings.
regards,
0683p000009MEYD.png
Anonymous
Not applicable
Author

At first, there is a documentation and there is always the possibility to contact me. There is absolute no reason to rate a component badly because of the lack of own knowlegde!
You should NOT use your own email address! You have to use the email address of your service account.
And to avoid your next stupid bad rating: Please add your service account email as user to all profiles you need to gather data.
Please keep in mind, the rating system should give users a hint about the quality of the component and not about the quality of developers which have less interest in communication and reading manuals.
Anonymous
Not applicable
Author

Hi jlolling,
To be honest, i was looking for you on this post.
Sorry about that rating but my purpose, to post this link there, was just to gather attention of concerned persons. I will update my rating. Its is certainly worth appreciating if someone is working on custom components to make our tasks easier.
About the email address, I have added the service account email (see attached images) now but it still returns nothing.
btw, i tried fetching data from https://developers.google.com/apis-explorer/#s/analytics/v3/analytics.data.ga.get and it returns data correctly.
can u please explain a bit?
Thanks for replying.
regards,
abdul.
0683p000009MEYI.png
Anonymous
Not applicable
Author

no need to be rude jlolling. As i said, i will update it 0683p000009MACn.png
Anonymous
Not applicable
Author

Sorry for my writing but it makes me angry if developers actually say: "your work is crap" because of a lack of knowledge. It is not the first time I am facing that problem.
Ok back to your problem: There is not result? That sound unusually. In your dimension is actually a metric, I am a bit surprised about this works for you.
I have tried your dimensions and metrics and get an exception because of the invalid usage of a metric as dimension.
You are sure there is no exception in your run console window?
Please take a look to the reference:
https://developers.google.com/analytics/devguides/reporting/core/v3/reference
Here you get an complete descriptions about dimensions and metrics, and please do not mix them up.
Anonymous
Not applicable
Author

its perfectly ok.
well according to this https://developers.google.com/analytics/devguides/reporting/core/dimsmets/visitor#ga:visitCount
visitCount is a dimension. since it is optional, that is not my concern. There was no error with this dimension/metric combination as can be seen in attached image.
Since i'm taking my friend's help to add my email as a user to his webiste's GA, i've confusions about the whole process. Let me state steps i did to make it work.
1. My friend has a website with GA integrated, he added my google email as user. Now i was able to view hi stats through my google analytics home page.
2. Then i turned ON my Analytics API services and also added one service account. I also downloaded p12 key file associated to this service account.
3. My friend also added this service account email as user to his GA. He also provided me Profile Id.
That is all i need to make a data fetch request through tGoogleAnalyticsInput. But it returns nothing.
Please let me know that what is the point that i may be missing.
regards,
abdul
0683p000009MEGz.png 0683p000009MEYN.png 0683p000009MEEJ.png
Anonymous
Not applicable
Author

Could you please check this:
Please select the google component and switch to the code view.
Between the section start and stop
must be a lot of code where you find your given attributes.
There is an annoying bug in Talend that prevents the job from getting the necessary code from the component.
Anonymous
Not applicable
Author

In which way you have installed the user components?
Anonymous
Not applicable
Author

Thanks for looking into it in detail.
This is the code you asked for
"
/**
* start
*/
ok_Hash.put("tGoogleAnalyticsInput_1", false);
start_Hash.put("tGoogleAnalyticsInput_1",
System.currentTimeMillis());
currentComponent = "tGoogleAnalyticsInput_1";
int tos_count_tGoogleAnalyticsInput_1 = 0;
/**
* stop
*/
/**
* start
*/
"
and there is nothing in it.
I used this https://help.talend.com/search/all?query=Installing+a+custom+component&content-lang=en to install the custom component.
regards,
abdul.