Re: Not receiving all the columns in the query

2022-03-07 Thread Poojitha Gandra 
below is the response for the query: 
*customer id is 2297774595*
*request id is : *5hahIwRH26jj0i8tsCGOaQ

d is  {'results': [{'customer': {'resource_name': 'customers/2297774595', 
'id': '2297774595', 'descriptive_name': 'NerdWallet - Small Business Loans 
- NW', 'currency_code': 'USD', 'time_zone': 'America/Los_Angeles'}, 
'campaign': {'resource_name': 'customers/2297774595/campaigns/16088255717', 
'status': 'ENABLED', 'advertising_channel_type': 'SEARCH', 
'serving_status': 'SERVING', 'bidding_strategy_type': 
'MAXIMIZE_CONVERSIONS', 'name': 
'smb_mktg_paid_020222_businessloans_nw_desktop', 'id': '16088255717', 
'campaign_budget': 'customers/2297774595/campaignBudgets/10297015189', 
'start_date': '2022-02-02', 'end_date': '2037-12-30'}, 'metrics': 
{'active_view_measurability': 0.0}, 'segments': {'device': 'DESKTOP', 
'ad_network_type': 'SEARCH', 'date': '2022-02-17'}}, {'customer': 
{'resource_name': 'customers/2297774595', 'id': '2297774595', 
'descriptive_name': 'NerdWallet - Small Business Loans - NW', 
'currency_code': 'USD', 'time_zone': 'America/Los_Angeles'}, 'campaign': 
{'resource_name': 'customers/2297774595/campaigns/16088255717', 'status': 
'ENABLED', 'advertising_channel_type': 'SEARCH', 'serving_status': 
'SERVING', 'bidding_strategy_type': 'MAXIMIZE_CONVERSIONS', 'name': 
'smb_mktg_paid_020222_businessloans_nw_desktop', 'id': '16088255717', 
'campaign_budget': 'customers/2297774595/campaignBudgets/10297015189', 
'start_date': '2022-02-02', 'end_date': '2037-12-30'}, 'metrics': 
{'active_view_measurability': 0.0}, 'segments': {'device': 'DESKTOP', 
'ad_network_type': 'SEARCH', 'date': '2022-02-18'}}, {'customer': 
{'resource_name': 'customers/2297774595', 'id': '2297774595', 
'descriptive_name': 'NerdWallet - Small Business Loans - NW', 
'currency_code': 'USD', 'time_zone': 'America/Los_Angeles'}, 'campaign': 
{'resource_name': 'customers/2297774595/campaigns/16088255717', 'status': 
'ENABLED', 'advertising_channel_type': 'SEARCH', 'serving_status': 
'SERVING', 'bidding_strategy_type': 'MAXIMIZE_CONVERSIONS', 'name': 
'smb_mktg_paid_020222_businessloans_nw_desktop', 'id': '16088255717', 
'campaign_budget': 'customers/2297774595/campaignBudgets/10297015189', 
'start_date': '2022-02-02', 'end_date': '2037-12-30'}, 'metrics': 
{'active_view_measurability': 0.0}, 'segments': {'device': 'DESKTOP', 
'ad_network_type': 'SEARCH', 'date': '2022-02-21'}}, {'customer': 
{'resource_name': 'customers/2297774595', 'id': '2297774595', 
'descriptive_name': 'NerdWallet - Small Business Loans - NW', 
'currency_code': 'USD', 'time_zone': 'America/Los_Angeles'}, 'campaign': 
{'resource_name': 'customers/2297774595/campaigns/16088255717', 'status': 
'ENABLED', 'advertising_channel_type': 'SEARCH', 'serving_status': 
'SERVING', 'bidding_strategy_type': 'MAXIMIZE_CONVERSIONS', 'name': 
'smb_mktg_paid_020222_businessloans_nw_desktop', 'id': '16088255717', 
'campaign_budget': 'customers/2297774595/campaignBudgets/10297015189', 
'start_date': '2022-02-02', 'end_date': '2037-12-30'}, 'metrics': 
{'active_view_measurability': 0.0}, 'segments': {'device': 'DESKTOP', 
'ad_network_type': 'SEARCH', 'date': '2022-02-22'}}, {'customer': 
{'resource_name': 'customers/2297774595', 'id': '2297774595', 
'descriptive_name': 'NerdWallet - Small Business Loans - NW', 
'currency_code': 'USD', 'time_zone': 'America/Los_Angeles'}, 'campaign': 
{'resource_name': 'customers/2297774595/campaigns/16088255717', 'status': 
'ENABLED', 'advertising_channel_type': 'SEARCH', 'serving_status': 
'SERVING', 'bidding_strategy_type': 'MAXIMIZE_CONVERSIONS', 'name': 
'smb_mktg_paid_020222_businessloans_nw_desktop', 'id': '16088255717', 
'campaign_budget': 'customers/2297774595/campaignBudgets/10297015189', 
'start_date': '2022-02-02', 'end_date': '2037-12-30'}, 'metrics': 
{'active_view_measurability': 0.0}, 'segments': {'device': 'DESKTOP', 
'ad_network_type': 'SEARCH', 'date': '2022-02-23'}}, {'customer': 
{'resource_name': 'customers/2297774595', 'id': '2297774595', 
'descriptive_name': 'NerdWallet - Small Business Loans - NW', 
'currency_code': 'USD', 'time_zone': 'America/Los_Angeles'}, 'campaign': 
{'resource_name': 'customers/2297774595/campaigns/16088255717', 'status': 
'ENABLED', 'advertising_channel_type': 'SEARCH', 'serving_status': 
'SERVING', 'bidding_strategy_type': 'MAXIMIZE_CONVERSIONS', 'name': 
'smb_mktg_paid_020222_businessloans_nw_desktop', 'id': '16088255717', 
'campaign_budget': 'customers/2297774595/campaignBudgets/10297015189', 
'start_date': '2022-02-02', 'end_date': '2037-12-30'}, 'metrics': 
{'active_view_measurability': 0.0}, 'segments': {'device': 'DESKTOP', 
'ad_network_type': 'SEARCH', 'date': '2022-02-24'}}, {'customer': 
{'resource_name': 'customers/2297774595', 'id': '2297774595', 
'descriptive_name': 'NerdWallet - Small Business Loans - NW', 
'currency_code': 'USD', 'time_zone': 'America/Los_Angeles'}, 'campaign': 
{'resource_name': 'customers/2297774595/campaigns/16088255717', 'status': 
'ENABLED', 'advertising

Re: Not receiving all the columns in the query

2022-03-07 Thread Poojitha Gandra 
Thank you for your response.

I am using python API to run these report queries.
Could you please elaborate on from where i can get the values you are
mentioning?

On Mon, Mar 7, 2022 at 5:38 AM Google Ads API Forum Advisor
 wrote:

> Hi Poojitha,
>
> ​​Thank you for raising this concern to Google Ads API support team.
>
> For a clearer view to these issues, could you provide the complete request
> 
>  and response
> 
>  logs
> with request ID
> 
>  and request header
> 
>  that
> generated on your end? This information will help our team to investigate
> further.
>
> You can provide it via *Reply privately to the author* option. If this
> option is not available, then send it instead on this email address
> googleadsapi-supp...@google.com alias instead.
>
> Best regards,
> [image: Google Logo]
> Jinky
> Google Ads API Team
>
>
> ref:_00D1U1174p._5004Q2XlaSB:ref
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"Google Ads API and AdWords 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/CAAKBDikxoBBeF-NofcEA5xswaou-z74rbOJFOfFzywZKXW94hw%40mail.gmail.com.

Not receiving all the columns in the query

2022-03-04 Thread Poojitha Gandra 
Hi,

I am not receiving the column *campaign.percent_cpc.enhanced_cpc_enabled* 
while running the below query in google ads API. I am facing the similar 
issue with other reports as well.

*Below is my query for campaign:*

select 
campaign.id,segments.date, campaign.name, customer.descriptive_name, 
campaign.status,customer.currency_code, 
customer.descriptive_name,customer.time_zone,metrics.active_view_measurability,campaign.serving_status,
 
segments.ad_network_type, segments.ad_network_type, 
bidding_strategy.name,campaign.bidding_strategy,campaign.bidding_strategy_type,segments.device,
*campaign.percent_cpc.enhanced_cpc_enabled*, customer.id, 
campaign.url_custom_parameters, campaign.start_date,campaign.end_date, 
campaign.advertising_channel_sub_type, campaign.advertising_channel_type, 
campaign.campaign_budget from 
campaign where segments.date DURING LAST_14_DAYS

*Output*:

['customer.resource_name', 'customer.id', 'customer.descriptive_name',
   'customer.currency_code', 'customer.time_zone',
   'campaign.resource_name', 'campaign.status',
   'campaign.advertising_channel_type', 'campaign.serving_status',
  'campaign.bidding_strategy_type', 'campaign.name', 'campaign.id',
   'campaign.campaign_budget', 'campaign.start_date', 
'campaign.end_date',
 'metrics.active_view_measurability', 'segments.device',
 'segments.ad_network_type', 'segments.date',
 'campaign.bidding_strategy', 'bidding_strategy.resource_name',
  'bidding_strategy.name', 'campaign.url_custom_parameters',
 'campaign.advertising_channel_sub_type']







-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"Google Ads API and AdWords 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/982156e4-6968-47cc-906c-9ca7dc3c373dn%40googlegroups.com.