Unable to get data partitioned by Date and Device for some accounts

[Gustavo Buosi De Almeida Hernandes]

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

[Google Ads API Forum Advisor Prod]

Hi Gustavo,

Thank you for reaching out.

To better investigate the behavior your are observing, could you provide the complete customer IDs of accounts A, B, and C, and also the generated report files of each of the accounts?

These details will allow me to have a closer look at the issue being encountered on the said accounts. You may send the requested information using the Reply privately to author option.

Best regards,

Peter Laurence Napa Oliquino Google Ads API Team

ref:_00D1U1174p._5004Q28mexY:ref

[Gustavo Buosi De Almeida Hernandes]

Hi Peter, thanks for reaching out.

Unfortunately, when I try to hit the Reply privately to author option it says that I do not have permissions to do so. Any reason for this to be happening? May I send to you via another e-mail?

Thank you very much.

[Google Ads API Forum Advisor Prod]

Hi Gustavo,

You may provide the requested details on this email address googleadsa...@google.com so that we can receive it privately for security purposes.

Regards,

Ernie John Blanca Tacata Google Ads API Team

ref:_00D1U1174p._5004Q28mexY:ref