Greetings.
We are extracting data from the CAMPAIGN_PERFORMANCE_REPORT using the API
from this repository: https://github.com/googleads/googleads-python-lib
We have three accounts from which we would like to extract information, A,
B, and C, getting the following fields:
Date, Device, AccountCurrencyCode, AccountDescriptiveName, AccountTimeZone,
AdvertisingChannelSubType, AdvertisingChannelType, Amount, BaseCampaignId,
BiddingStrategyId, BiddingStrategyName, BiddingStrategyType, BudgetId,
CampaignDesktopBidModifier, CampaignGroupId, CampaignId,
CampaignMobileBidModifier, CampaignName, CampaignStatus,
CampaignTabletBidModifier, CampaignTrialType, CustomerDescriptiveName,
EndDate, EnhancedCpcEnabled, ExternalCustomerId, FinalUrlSuffix,
HasRecommendedBudget, IsBudgetExplicitlyShared, LabelIds, Labels,
MaximizeConversionValueTargetRoas, Period, RecommendedBudgetAmount,
ServingStatus, StartDate, TotalAmount, TrackingUrlTemplate,
UrlCustomParameters, AbsoluteTopImpressionPercentage, ActiveViewCpm,
ActiveViewCtr, ActiveViewImpressions, ActiveViewMeasurability,
ActiveViewMeasurableCost, ActiveViewMeasurableImpressions,
ActiveViewViewability, AllConversionRate, AllConversions,
AllConversionValue, AverageCost, AverageCpc, AverageCpe, AverageCpm,
AverageCpv, AveragePosition, Clicks, ContentBudgetLostImpressionShare,
ContentImpressionShare, ContentRankLostImpressionShare, ConversionRate,
Conversions, ConversionValue, Cost, CostPerAllConversion,
CostPerConversion, CostPerCurrentModelAttributedConversion,
CrossDeviceConversions, Ctr, CurrentModelAttributedConversions,
CurrentModelAttributedConversionValue, EngagementRate, Engagements,
GmailForwards, GmailSaves, GmailSecondaryClicks, Impressions,
InteractionRate, Interactions, InteractionTypes, InvalidClickRate,
InvalidClicks, SearchAbsoluteTopImpressionShare,
SearchBudgetLostAbsoluteTopImpressionShare,
SearchBudgetLostImpressionShare, SearchBudgetLostTopImpressionShare,
SearchClickShare, SearchExactMatchImpressionShare, SearchImpressionShare,
SearchRankLostAbsoluteTopImpressionShare, SearchRankLostImpressionShare,
SearchRankLostTopImpressionShare, SearchTopImpressionShare,
TopImpressionPercentage, ValuePerAllConversion, ValuePerConversion,
ValuePerCurrentModelAttributedConversion, VideoQuartile100Rate,
VideoQuartile25Rate, VideoQuartile50Rate, VideoQuartile75Rate,
VideoViewRate, VideoViews, ViewThroughConversions
Using the following call:
report_query = """SELECT {}
FROM {}
DURING {},{}""".format(','.join(fields),
'CAMPAIGN_PERFORMANCE_REPORT','20201127' ,'20201127')
We are able to return every necessary data for accounts A and B, but not
for C. On further investigation we have realized that if we take off the
first two fields (Date, Device) for account C, the results can finally be
recovered, but they would not be partitioned with the dates neither with
devices as we wish.
Could you guys help us? Thank you very much
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/12cdb667-3a0f-47b8-ac41-700218d0b662n%40googlegroups.com.
