getting error while extracting data from GoogleAdWordsReport using tGoogleAdWordsReport component

Highlighted
Eight Stars RAJ
Eight Stars

getting error while extracting data from GoogleAdWordsReport using tGoogleAdWordsReport component

Hi Folks,

          Customer provided all the permission to my mail id(Admin access). I have seen all the customer GoogleAdWords report using my mail id. So I am going to extract data from GoogleAdWordsReport using my mail id. Customer provided Developer token from his mail.

I have created the client secret file in my Gmail account.

I have enabled below API's in my account.

  • Google Analytics Reporting API
  • Analytics API
  • Google Ads API

I am using Talend Open Studio 7.0.1.

I am getting below error while extracting data from GoogleAdWordsReport using tGoogleAdWordsReport component. 

Kindly share your information at earliest. 

 

SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.

Exception in component tGoogleAdWordsReport_4 (Neg)
java.lang.IllegalArgumentException: No enum constant com.google.api.ads.adwords.lib.jaxb.v201802.ReportDefinitionReportType.Campaign_Trend
at java.lang.Enum.valueOf(Unknown Source)
at com.google.api.ads.adwords.lib.jaxb.v201802.ReportDefinitionReportType.valueOf(ReportDefinitionReportType.java:90)
at com.google.api.ads.adwords.lib.jaxb.v201802.ReportDefinitionReportType.fromValue(ReportDefinitionReportType.java:149)
at de.jlo.talendcomp.google.adwords.AdWordsReport.getReportDefinitionType(AdWordsReport.java:459)
at de.jlo.talendcomp.google.adwords.AdWordsReport.setupReportDefinition(AdWordsReport.java:431)
at de.jlo.talendcomp.google.adwords.AdWordsReport.executeQuery(AdWordsReport.java:341)
at local_project.neg_0_1.Neg.tGoogleAdWordsReport_4Process(Neg.java:860)
at local_project.neg_0_1.Neg.runJobInTOS(Neg.java:1476)
at local_project.neg_0_1.Neg.main(Neg.java:1327)
[statistics] disconnected

Job Neg ended at 11:47 05/02/2019. [exit code=1]

 

Thanks
RAJ
Seventeen Stars

Re: getting error while extracting data from GoogleAdWordsReport using tGoogleAdWordsReport component

Could you send me more details about your job.

There are a new version 8.3 of the component out there. This version provides a better and less confusing error message in this case.

 

The current API 2018-09 allows following report types:

    KEYWORDS_PERFORMANCE_REPORT,

    AD_PERFORMANCE_REPORT,

    URL_PERFORMANCE_REPORT,

    ADGROUP_PERFORMANCE_REPORT,

    CAMPAIGN_PERFORMANCE_REPORT,

    ACCOUNT_PERFORMANCE_REPORT,

    GEO_PERFORMANCE_REPORT,

    SEARCH_QUERY_PERFORMANCE_REPORT,

    AUTOMATIC_PLACEMENTS_PERFORMANCE_REPORT,

    CAMPAIGN_NEGATIVE_KEYWORDS_PERFORMANCE_REPORT,

    CAMPAIGN_NEGATIVE_PLACEMENTS_PERFORMANCE_REPORT,

    SHARED_SET_REPORT,

    CAMPAIGN_SHARED_SET_REPORT,

    SHARED_SET_CRITERIA_REPORT,

    CREATIVE_CONVERSION_REPORT,

    CALL_METRICS_CALL_DETAILS_REPORT,

    KEYWORDLESS_QUERY_REPORT,

    KEYWORDLESS_CATEGORY_REPORT,

    CRITERIA_PERFORMANCE_REPORT,

    CLICK_PERFORMANCE_REPORT,

    BUDGET_PERFORMANCE_REPORT,

    BID_GOAL_PERFORMANCE_REPORT,

    DISPLAY_KEYWORD_PERFORMANCE_REPORT,

    PLACEHOLDER_FEED_ITEM_REPORT,

    PLACEMENT_PERFORMANCE_REPORT,

    CAMPAIGN_NEGATIVE_LOCATIONS_REPORT,

    GENDER_PERFORMANCE_REPORT,

    AGE_RANGE_PERFORMANCE_REPORT,

    CAMPAIGN_LOCATION_TARGET_REPORT,

    CAMPAIGN_AD_SCHEDULE_TARGET_REPORT,

    PAID_ORGANIC_QUERY_REPORT,

    AUDIENCE_PERFORMANCE_REPORT,

    DISPLAY_TOPICS_PERFORMANCE_REPORT,

    USER_AD_DISTANCE_REPORT,

    SHOPPING_PERFORMANCE_REPORT,

    PRODUCT_PARTITION_REPORT,

    PARENTAL_STATUS_PERFORMANCE_REPORT,

    PLACEHOLDER_REPORT,

    AD_CUSTOMIZERS_FEED_ITEM_REPORT,

    LABEL_REPORT,

    FINAL_URL_REPORT,

    VIDEO_PERFORMANCE_REPORT,

    TOP_CONTENT_PERFORMANCE_REPORT,

    CAMPAIGN_CRITERIA_REPORT,

    CAMPAIGN_GROUP_PERFORMANCE_REPORT,

    LANDING_PAGE_REPORT,

    MARKETPLACE_PERFORMANCE_REPORT

Eight Stars RAJ
Eight Stars

Re: getting error while extracting data from GoogleAdWordsReport using tGoogleAdWordsReport component

Hi jlolling,
Thanks for the quick response and I have tried below report also. I can't extract data from Google AdWords.
KEYWORDS_PERFORMANCE_REPORT

What exact information do you need?


Thanks
RAJ
Eight Stars RAJ
Eight Stars

Re: getting error while extracting data from GoogleAdWordsReport using tGoogleAdWordsReport component

Hi jlolling,

Now am using tGoogleAdWordsReport-8.3 in Talend job and getting below error.

SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
Exception in component tGoogleAdWordsReport_2 (Google_adwords_report)
HTTP Response Code: 400, Trigger: <null>, Type: QuotaCheckError.DEVELOPER_TOKEN_NOT_APPROVED
at com.google.api.ads.adwords.lib.utils.v201809.DetailedReportDownloadResponseException$Builder.build(DetailedReportDownloadResponseException.java:35)
at com.google.api.ads.adwords.lib.utils.AdHocReportDownloadHelperImpl.handleResponse(AdHocReportDownloadHelperImpl.java:117)
at com.google.api.ads.adwords.lib.utils.AdHocReportDownloadHelperImpl.downloadReport(AdHocReportDownloadHelperImpl.java:60)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.google.api.ads.common.lib.utils.AdsUtilityInvocationHandler.handleInvocation(AdsUtilityInvocationHandler.java:46)
at com.google.common.reflect.AbstractInvocationHandler.invoke(AbstractInvocationHandler.java:84)
at com.sun.proxy.$Proxy13.downloadReport(Unknown Source)
at com.google.api.ads.adwords.lib.utils.AdHocReportDownloadHelper.downloadReport(AdHocReportDownloadHelper.java:46)
at com.google.api.ads.adwords.lib.utils.v201809.ReportDownloader.downloadReport(ReportDownloader.java:65)
at de.jlo.talendcomp.google.adwords.AdWordsReport.executeQuery(AdWordsReport.java:342)
at local_project.google_adwords_report_0_1.Google_adwords_report.tGoogleAdWordsReport_2Process(Google_adwords_report.java:900)
at local_project.google_adwords_report_0_1.Google_adwords_report.runJobInTOS(Google_adwords_report.java:1533)
at local_project.google_adwords_report_0_1.Google_adwords_report.main(Google_adwords_report.java:1382)
[statistics] disconnected

Thanks
RAJ
Seventeen Stars

Re: getting error while extracting data from GoogleAdWordsReport using tGoogleAdWordsReport component

OK perhaps the error message ist not user friendly enough but "DEVELOPER_TOKEN_NOT_APPROVED" should be quite clear.

Your developer-token is not valid! At first check your configuration, if you use the right developer token.

Please check the Help pages of Google AdWords and you can also ask the AdWords support in case your account is not registered to use the AdWords API.

 

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download