Hello,
My apologies in my delay in getting back to you. We had a high priority
issue that came in that was affecting a number of users, and you're
question takes a lot of research and diving into the data to figure out. On
the surface, it doesn't look easy. Your issue is my next task. I'll get
back to you soon.
Cheers,
Nadine Sundquist, AdWords API Team
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 01/15/19 10:38:59 [email protected] wrote:
I download data from CAMPAIGN_LOCATION_TARGET_REPORT via API v201809.
At the same time I download data from CAMPAIGN_PERFORMANCE_REPORT.
I use fileds: Cost, Impressions, Clicks.
The SUM in total of this fields (Cost, Impressions, Clicks) has some
differens beetween two repots: CAMPAIGN_LOCATION_TARGET_REPORT,
CAMPAIGN_PERFORMANCE_REPORT
Numbers from CAMPAIGN_PERFORMANCE_REPORT are the same like in Web-inferface
- everything is OK.
But number from CAMPAIGN_LOCATION_TARGET_REPORT is little bit bigger. I
don't understand why?
Can you download this two reports for account 478-325-6348 and dates
2018-12-01 - 2018-12-31 all campaigns (no restrictions) and see the
difference.
My excpectations: SUMs should be the same. But I didnt get.
The code is below:
1)
fields = ['CampaignId', 'CampaignName', 'CampaignStatus', 'Id', 'Date',
'Interactions', 'InteractionTypes', 'Clicks', 'Impressions',
'Cost','Engagements', 'VideoViews', 'ViewThroughConversions',
'AveragePosition', 'CampaignStatus']
include_zero_impressions = True
report_query = (adwords.ReportQueryBuilder()
.Select(*fields)
.From('CAMPAIGN_LOCATION_TARGET_REPORT')
.Where('CampaignStatus').In('ENABLED', 'PAUSED')
.During(start_date.strftime('%Y%m%d') + ',' +
end_date.strftime('%Y%m%d'))
.Build())
res = report_downloader.DownloadReportAsStringWithAwql(
report_query, 'CSV', skip_report_header=True,
skip_column_header=False, skip_report_summary=True,
include_zero_impressions=include_zero_impressions)
import pandas as pd
from io import StringIO
adwords_df = pd.read_csv(StringIO(res))
2)
report = 'CAMPAIGN_PERFORMANCE_REPORT'
fields_query = ['Date', 'AccountDescriptiveName', 'AdvertisingChannelType',
'AdvertisingChannelSubType', 'AdNetworkType1', 'CampaignId',
'CampaignName', 'Impressions', 'Clicks', 'Cost', 'AccountCurrencyCode']
report_query = (adwords.ReportQueryBuilder()
.Select(*fields_query)
.From(report)
.Where('CampaignStatus').In('ENABLED', 'PAUSED')
.During(start_date.strftime('%Y%m%d') + ', ' +
end_date.strftime('%Y%m%d'))
.Build())
res = report_downloader.DownloadReportAsStringWithAwql(
report_query, 'CSV', skip_report_header=True,
skip_column_header=False, skip_report_summary=True,
include_zero_impressions=False,
)
adwords_df = pd.read_csv(StringIO(res))
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 [email protected]
To unsubscribe from this group, send email to
[email protected]
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 [email protected].
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/94044857-61d3-45f9-a8e6-32ef4e0f11c8%40googlegroups.com
<https://groups.google.com/d/msgid/adwords-api/94044857-61d3-45f9-a8e6-32ef4e0f11c8%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 [email protected]
To unsubscribe from this group, send email to
[email protected]
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 [email protected].
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/00d12i8id80000008rh3ca004jttrmw70mj4chk6co30c1g68q3id1l%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
