getting error while extracting data from GoogleAdWordsReport using tGoogleAdWordsReport component

[RAJ6]

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]

[Anonymous]

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

[RAJ6]

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?

[RAJ6]

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

[Anonymous]

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.