Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] Google Adsense data

Is there any component like tGoogleAdWords or tGoogleAnalyticsInput except for Adsense data?  Can I trick these components into accessing Adsense data?
If not, what is the next easiest method?
Thanks,
Al
Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hello all,
I contacted Jan Lolling who created many great Google components.  In short, he advised me that it was possible to use tGoogleAnalyticsInput to view Adsense data since  you can get a lot of AdSense metrics with the core reporting API
Please note you will need to link Adsense to your Analytics account.  Based on my research you cannot use a Service account when accessing Adsense data however this is overridden if you link to the Analytics account and access the data via Analytics.  Therefore I was able to access the data using the service account and a .p12 file.  
tGoogleAnalyticsInput documentation:  http://jan-lolling.de/talend/components/help/tGoogleAnalyticsInput.pdf
Adsense Core Reporting documentation:  https://developers.google.com/analytics/devguides/reporting/core/dimsmets#view=detail&group=adsense
Linking Adsense to Analytics:  https://support.google.com/adsense/answer/6084409?hl=en

Thanks Jan Lolling (jlolling) for your assistance!
Al

View solution in original post

5 Replies
Anonymous
Not applicable
Author

Hi,
So far, there is no specific component for Google Adsense data in Talend. Feel free to create a new feature jira issue on Talend Bug Tracker.
tGoogleAnalyticsInput and tGoogleAdwordReport are custom components written by Talend Community Users and shared on Talend Exchange.
 
You can contact to the author directly for your requirement.
Best regards
Sabrina
Anonymous
Not applicable
Author

Hello all,
I contacted Jan Lolling who created many great Google components.  In short, he advised me that it was possible to use tGoogleAnalyticsInput to view Adsense data since  you can get a lot of AdSense metrics with the core reporting API
Please note you will need to link Adsense to your Analytics account.  Based on my research you cannot use a Service account when accessing Adsense data however this is overridden if you link to the Analytics account and access the data via Analytics.  Therefore I was able to access the data using the service account and a .p12 file.  
tGoogleAnalyticsInput documentation:  http://jan-lolling.de/talend/components/help/tGoogleAnalyticsInput.pdf
Adsense Core Reporting documentation:  https://developers.google.com/analytics/devguides/reporting/core/dimsmets#view=detail&group=adsense
Linking Adsense to Analytics:  https://support.google.com/adsense/answer/6084409?hl=en

Thanks Jan Lolling (jlolling) for your assistance!
Al
Anonymous
Not applicable
Author

Hi Al,
Thanks for your feed back and sharing these informations on forum.
Best regards
Sabrinas
rcbsintegration
Contributor
Contributor

Hi Alvin,
If the tGoogleAnalyticsInput and tGoogleAdwordReport are custom talend component. How to I add those component in my talend studio?
Anonymous
Not applicable
Author

Hi Alvin,
If the tGoogleAnalyticsInput and tGoogleAdwordReport are custom talend component. How to I add those component in my talend studio?

Hi rcbs,
You can download custom components from Talend Exchange:
https://exchange.talend.com
Instructions to install custom components:
https://help.talend.com/search/all?query=Installing+a+custom+component&content-lang=en
Al