Hey Ejay, Thanks for your reply! Just want to clarify, are you using the following fields not the one in the post? Did you try both two different field combinations? query_report = self._get_report_selector( _QUERY_DAILY_INSIGHTS_NAME, _QUERY_REPORT_TYPE, [ 'AdGroupId', 'Cost', 'Query'] ) I retried, the issue persists.
Best, Ying On Monday, April 22, 2019 at 11:03:07 PM UTC-7, googleadsapi-forumadvisor wrote: > > Hi Ruby, > > Upon impersonating the report on my test AdWords API by using the provided > customer ID and by using the same fields, I wasn't able to replicate the > issue as the returned cost for the ad group ID *56257520389* is > *161890000*. The returned cost of the API report is also matched in UI > (upon mapping the report in UI). With this, you may re-try the API call and > let me know if the issue still persists so I can further investigate. > > Regards, > Ejay > Google Ads API Team > > =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ > Also find us on our blog and discussion group: > https://ads-developers.googleblog.com/search/label/google_ads_api > https://developers.google.com/adwords/api/community/ > =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ > > Was your question answered? Please rate your experience with us by taking > a short survey. > If not -- reply to this email and tell us what else we can do to help. > > Take Survey > <https://support.google.com/google-ads/contact/survey_transactional?caseid=3-2789000026257&hl=en&ctx=1> > > Also find us on our blog and discussion group: > http://googleadsdeveloper.blogspot.com/search/label/adwords_api > https://developers.google.com/adwords/api/community/ > On 04/23/19 08:38:33 ying...@pinterest.com <javascript:> wrote: > > Hey Team, > > I got a different result when adding 'Query' attribute to pull seach query > performance report. > Check the code below, the total cost for ad group id 56257520389 > is 161890000. However, when I query ['Query', 'AdGroupId', 'Cost'], the > cost turned out to be 159570000. > > Is this expected? If not, any idea about how to fix it? > > import pandas as pd > > def _get_report_selector(self, name, report_type, fields): > campaign_report = { > 'reportName': name, > 'dateRangeType': 'CUSTOM_DATE', > 'reportType': report_type, > 'downloadFormat': 'CSV', > 'selector': { 'fields': fields, 'dateRange': { 'min': '2019-04-19'), > 'max': '2019-04-19' } } } > return campaign_report > > self.client.SetClientCustomerId('984-844-9049') > query_report = self._get_report_selector( _QUERY_DAILY_INSIGHTS_NAME, > _QUERY_REPORT_TYPE, [ 'AdGroupId', 'Cost', ] ) > insightsCSV = pd.read_csv(self.report_downloader.DownloadReportAsStream( > report, skip_report_header=True, skip_column_header=False, > skip_report_summary=True)) > insightsCSV.columns = [column.replace(" ", "_") for column in > insightsCSV.columns] > filtered_insight = insightsCSV.query('Ad_group_ID == 56257520389') > filtered_insight['Cost'].sum() > > > Best, > Ruby > > -- > -- > =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ > Also find us on our blog: > https://googleadsdeveloper.blogspot.com/ > =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ > > You received this message because you are subscribed to the Google > Groups "AdWords API and Google Ads API Forum" group. > To post to this group, send email to adwords-api@googlegroups.com > To unsubscribe from this group, send email to > adwords-api+unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/adwords-api?hl=en > --- > You received this message because you are subscribed to the Google Groups > "AdWords API and Google Ads API Forum" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to adwords-api+unsubscr...@googlegroups.com. > Visit this group at https://groups.google.com/group/adwords-api. > To view this discussion on the web visit > https://groups.google.com/d/msgid/adwords-api/59c876a7-c225-4157-a54d-43c5e156f480%40googlegroups.com > > <https://groups.google.com/d/msgid/adwords-api/59c876a7-c225-4157-a54d-43c5e156f480%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/6407f243-b7f6-43c6-bbad-017acb149572%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
