cost difference between adgroup performance report and ad performance report

2018-05-31 Thread Vikram Tiwari
Is there any reason why there would be a difference between the cost from adgroup performance report and ad performance report? SDK Details: Python SDK Latest API (v201802) Queries used: AdGroup Performance: ```SELECT Date, AdGroupId, AdGroupName, AdNetworkType1, CampaignId, CampaignName, Impre

data difference - aggregated vs breakdown reports

2017-04-04 Thread Vikram Tiwari
The issue is: - When API is queried for aggregated data, sum of a numerical column (impressions, clicks, cost etc) is X - When API is queried for data with multiple breakdowns (ad, adset, campaign and more), the resultant sum is X +/- n The reason for the discrepancy of n is unknown but is sus

Re: Get accounts associated to manager account

2017-04-04 Thread Vikram Tiwari
Makes sense. But then shouldn't a better example be: - get accounts using CustomerService.getCustomers - loops though accounts to check if the account has canManageClients set as true - if so, then gets all the associated accounts to that manager account Returns all accounts, including the hierar

Re: Get accounts associated to manager account

2017-04-03 Thread Vikram Tiwari
refresh_token. On Monday, April 3, 2017 at 11:26:46 PM UTC-7, Vikram Tiwari wrote: > > Hey Peter - Thanks for the quick reply. > > I am using the exact same code on my local and getting following error: > > suds.WebFault: Server raised fault: > '[AuthenticationError.CLIE

Re: Get accounts associated to manager account

2017-04-03 Thread Vikram Tiwari
Hey Peter - Thanks for the quick reply. I am using the exact same code on my local and getting following error: suds.WebFault: Server raised fault: '[AuthenticationError.CLIENT_CUSTOMER_ID_IS_REQUIRED @ ; trigger:'']' Not sure what I am supposed to pass here. On Monday, April 3, 2017 at 8:38

Get accounts associated to manager account

2017-04-03 Thread Vikram Tiwari
Sample code: customerService = adwords_client.GetService( 'CustomerService', version='v201609') customers = customerService.getCustomers() When I use this, for most accounts I am able to get all the accounts associated. But recently I got issues with one of the accounts where

Re: Download campaigns - Not included in report

2017-01-17 Thread Vikram Tiwari
With some support in the private thread, we were able to resolve this. To get complete data one would need to run two queries: 1. To get all the UAC campaign data: `Select CampaignId, CampaignName, Clicks, Impressions, Cost FROM CAMPAIGN_PERFORMANCE_REPORT where AdvertisingChannelType = MULTI_C

Re: Download campaigns - Not included in report

2017-01-06 Thread Vikram Tiwari
Hey Peter - I tried it that way and it seems that I started missing more campaigns. Campaign Query: `SELECT CampaignId FROM CAMPAIGN_PERFORMANCE_REPORT DURING YESTERDAY` I expect this query to return all the results, regardless of campaign type. I pass the result of this query to following: D

Re: Download campaigns - Not included in report

2017-01-05 Thread Vikram Tiwari
Hey Peter - A follow-up question. I want to get UAC campaigns data grouped by ad groups. But as I see, from various available report types, it seems that there's no way to query that. Could you help? -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and Google+:

Re: Download campaigns - Not included in report

2017-01-05 Thread Vikram Tiwari
Thanks Peter - That was helpful. On Thursday, January 5, 2017 at 12:04:47 AM UTC-8, Peter Oliquino wrote: > > Hi Vikram, > > The campaign type you are referring to are the Universal App Campaigns > (UAC). For reporting, UAC statistics can be found in the following reports > mentioned here >

Download campaigns - Not included in report

2017-01-04 Thread Vikram Tiwari
I am trying to download report data using API for adgroup_performance_report. I get all the campaigns etc in the report except download campaigns. How do I get about that? What am I missing? Details: AWQL query: `SELECT Date,HourOfDay, AdGroupId, AdGroupName,AdNetworkType1, CampaignId, Campai

Re: Raw Enum Values Header - Not working as expected

2016-11-21 Thread Vikram Tiwari
Thanks for the suggestion. Yes, it seems to be limited to python client library. I have opened up the issue here: https://github.com/googleads/googleads-python-lib/issues/160 On Monday, November 21, 2016 at 3:16:52 PM UTC-8, Anthony Madrigal wrote: > > Hi Vikram, > > This issue appears to be spe

Re: Report format - Columnar vs Flat struture

2016-11-21 Thread Vikram Tiwari
That works! :) Thanks. On Monday, November 21, 2016 at 12:46:49 PM UTC-8, Vikram Tiwari wrote: > > I am trying to replicate how reports are shown/generated from the UI via > Python SDK. > > In the UI if I take Conversion Action Name (ConversionTypeName) I get the > ability to

Re: Report format - Columnar vs Flat struture

2016-11-21 Thread Vikram Tiwari
Thanks for the quick update Shwetha. Is this something that team is looking to add in next versions or no such plans? A simple flag or a totally different field name should do the trick (at least on the API side). On Monday, November 21, 2016 at 1:23:58 PM UTC-8, Shwetha Vastrad (AdWords API Te

Raw Enum Values Header - Not working as expected

2016-11-21 Thread Vikram Tiwari
While downloading reports from Python SDK, we get the ability to pass various headers. One of them being `use_raw_enum_values` which makes sure that the column headers of the downloaded report have the enum values rather than UI display values as headers. Current Python SDK is not behaving as e