topic Re: getting error while extracting data from GoogleAdWordsReport using tGoogleAdWordsReport component in Talend Studio

getting error while extracting data from GoogleAdWordsReport using tGoogleAdWordsReport component

RAJ6 — Sat, 16 Nov 2024 06:40:24 GMT

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]

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

Anonymous — Tue, 05 Feb 2019 12:32:24 GMT

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

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

RAJ6 — Tue, 05 Feb 2019 13:31:33 GMT

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?

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

RAJ6 — Wed, 06 Feb 2019 08:54:30 GMT

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

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

Anonymous — Thu, 07 Feb 2019 21:20:48 GMT

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.