Using python3 for campaigns report

2020-02-12 Thread Олеся Васина
Hello!
I am trying to get stats from campaign report and got an error module 
'google.ads.google_ads.v2.proto.errors' has no attribute 'errors_pb2'.

Here is a part of code:

client = GoogleAdsClient.load_from_string(yaml.safe_dump(adwords_client_config))


ga_service = client.get_service('GoogleAdsService', version='v2')

query = """
SELECT
  campaign.name,
  campaign.status,
  segments.device,
  metrics.impressions,
  metrics.clicks,
  metrics.ctr,
  metrics.average_cpc,
  metrics.cost_micros
FROM campaign
WHERE segments.date DURING LAST_30_DAYS
"""
response = ga_service.search(client_customer_id, query, 1000)
for row in response:
print(row)


Please help me with this error.

Thanks a lot!

Olesya

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/52264b6d-22bc-4667-86c2-a6af9a62cd92%40googlegroups.com.


Re: Download UAC RT campaigns stat using adwords api

2020-02-06 Thread Олеся Васина
Hi!
Thank you for answering!

I download stats by such query, but i can't download UAC engagement type 
campaigns.
So my question is about possibility of downloading engagements stats using 
Adwords API.

Have a nice day!

Thank you,
Olesya



среда, 5 февраля 2020 г., 23:53:17 UTC+3 пользователь adsapiforumadvisor 
написал:
>
> Hi Olesya,
>
> Thanks for reaching out. For UACs except the engagement type you could 
> download stats by querying reports from this list 
> 
>  
> in Adwords API. Please let me know if you have any other questions.
>
> Thanks and regards,
> Xiaoming, Google Ads API Team
>
>
>  
>
> ref:_00D1U1174p._5001UV01rJ: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 
"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/88a980a0-255d-4ef3-a290-9957b0e31f82%40googlegroups.com.


Download UAC RT campaigns stat using adwords api

2020-02-05 Thread Олеся Васина
Hi!
We have a problem with downloading UAC RT campaigns stat using adwords api. 
I lnow that it is not supported by old API and we should use google Ads 
instead.
But we can not do it, because it is in beta testing and we have very 
important regular process.

Can you please advise us, may be you have a workaround for such cases?


Thank you in advance!

Have a nice day,

Olesya

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/609b6de6-99f0-4b98-b3cb-a85703c70224%40googlegroups.com.


Re: CRITERIA_PERFORMANCE_REPORT in Adwords API

2020-08-16 Thread Олеся Васина
One more question.
How to such request

Введитеreport = client.GetReportDownloader().DownloadReportAsStreamWithAwql(
query, 'CSV', skip_report_header=True,
skip_column_header=True, skip_report_summary=True,
include_zero_impressions=False, 
client_customer_id=client_customer_id

)код...





суббота, 15 августа 2020 г., 9:24:58 UTC+3 пользователь Олеся Васина 
написал:
>
> HI!
>
> I am getting strange logs while fetching data 
> from CRITERIA_PERFORMANCE_REPORT.
>
> Code has worked successfully before.
>
> DEBUG zeep.cache: Cache HIT for 
> https://adwords.google.com/api/adwords/reportdownload/v201809/reportDefinition.xsd
> DEBUG zeep.xsd.schema: Init schema document for None
>  DEBUG zeep.xsd.schema: register_type('{
> http://www.w3.org/2001/XMLSchema}string',  object at 0x7f1c594f2cc0>)
> DEBUG zeep.xsd.schema: register_type('{
> http://www.w3.org/2001/XMLSchema}boolean', 
>  
>
> DEBUG zeep.xsd.schema: register_type('{
> http://www.w3.org/2001/XMLSchema}time',  object at 0x7f1c5951bf60>)
>  DEBUG zeep.xsd.schema: register_type('{
> http://www.w3.org/2001/XMLSchema}gYear',  object at 0x7f1c5951bcf8>)
>
>
> Looks like non valid XML schema, but i don't know how to fix it.
>
> query 
>
> SELECT
>   Date,
>   ExternalCustomerId,
>   CampaignId,
>   AdGroupId,
>   Id,
>   Criteria,
>   CriteriaType
> FROM CRITERIA_PERFORMANCE_REPORT
> WHERE Status = 'ENABLED'
> DURING {start_date}, {end_date}
>
>
> python code
> def fetch_data_from_adwords_api(client, subperiod: dtu.period, 
> client_customer_id: str, **kwargs: dict) -> Iterable:
> awql_start_dt = subperiod.start.strftime(AWQL_DATE_FORMAT)
> awql_end_dt = subperiod.end.strftime(AWQL_DATE_FORMAT)
>
> logger.info('Fetching data using Adwords API')
>
> query = kwargs['query'].format(
> start_date=awql_start_dt,
> end_date=awql_end_dt
> )
>
> report = client.GetReportDownloader().DownloadReportAsStreamWithAwql(
> query, 'CSV', skip_report_header=True,
> skip_column_header=True, skip_report_summary=True,
> include_zero_impressions=False, 
> client_customer_id=client_customer_id
> )
>
> data_df = pd.read_csv(
> report, encoding='utf8', names=kwargs['data_structure'].keys(),
> converters={}, dtype=kwargs['data_structure'],
> )
>
> if data_df.empty:
> logger.info(f'Empty results for {client_customer_id}')
> return []
>
> return data_df.to_dict(orient='records')
>
> Is a result i get an empty dataframe for one customer.
>
> But when i try to load report for all customers, code is working for about 
> 20 hours and fails for timeout.
>
> I tried to filter empty df, but it didn't help to prevent these logs.
>
> Please hep me to handle this situation.
>
>
>
>
> Thank you in advance!
>
> Best regads,
> Olesya
>
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/9b36d2dd-54bb-4b43-a6a4-10cc8968d8e3o%40googlegroups.com.


Re: CRITERIA_PERFORMANCE_REPORT in Adwords API

2020-08-16 Thread Олеся Васина
One more question about this problem.

How can i set timeout to such request?

report = client.GetReportDownloader().DownloadReportAsStreamWithAwql(
query, 'CSV', skip_report_header=True,
skip_column_header=True, skip_report_summary=True,
include_zero_impressions=False, 
client_customer_id=client_customer_id
)



суббота, 15 августа 2020 г., 9:24:58 UTC+3 пользователь Олеся Васина 
написал:
>
> HI!
>
> I am getting strange logs while fetching data 
> from CRITERIA_PERFORMANCE_REPORT.
>
> Code has worked successfully before.
>
> DEBUG zeep.cache: Cache HIT for 
> https://adwords.google.com/api/adwords/reportdownload/v201809/reportDefinition.xsd
> DEBUG zeep.xsd.schema: Init schema document for None
>  DEBUG zeep.xsd.schema: register_type('{
> http://www.w3.org/2001/XMLSchema}string',  object at 0x7f1c594f2cc0>)
> DEBUG zeep.xsd.schema: register_type('{
> http://www.w3.org/2001/XMLSchema}boolean', 
>  
>
> DEBUG zeep.xsd.schema: register_type('{
> http://www.w3.org/2001/XMLSchema}time',  object at 0x7f1c5951bf60>)
>  DEBUG zeep.xsd.schema: register_type('{
> http://www.w3.org/2001/XMLSchema}gYear',  object at 0x7f1c5951bcf8>)
>
>
> Looks like non valid XML schema, but i don't know how to fix it.
>
> query 
>
> SELECT
>   Date,
>   ExternalCustomerId,
>   CampaignId,
>   AdGroupId,
>   Id,
>   Criteria,
>   CriteriaType
> FROM CRITERIA_PERFORMANCE_REPORT
> WHERE Status = 'ENABLED'
> DURING {start_date}, {end_date}
>
>
> python code
> def fetch_data_from_adwords_api(client, subperiod: dtu.period, 
> client_customer_id: str, **kwargs: dict) -> Iterable:
> awql_start_dt = subperiod.start.strftime(AWQL_DATE_FORMAT)
> awql_end_dt = subperiod.end.strftime(AWQL_DATE_FORMAT)
>
> logger.info('Fetching data using Adwords API')
>
> query = kwargs['query'].format(
> start_date=awql_start_dt,
> end_date=awql_end_dt
> )
>
> report = client.GetReportDownloader().DownloadReportAsStreamWithAwql(
> query, 'CSV', skip_report_header=True,
> skip_column_header=True, skip_report_summary=True,
> include_zero_impressions=False, 
> client_customer_id=client_customer_id
> )
>
> data_df = pd.read_csv(
> report, encoding='utf8', names=kwargs['data_structure'].keys(),
> converters={}, dtype=kwargs['data_structure'],
> )
>
> if data_df.empty:
> logger.info(f'Empty results for {client_customer_id}')
> return []
>
> return data_df.to_dict(orient='records')
>
> Is a result i get an empty dataframe for one customer.
>
> But when i try to load report for all customers, code is working for about 
> 20 hours and fails for timeout.
>
> I tried to filter empty df, but it didn't help to prevent these logs.
>
> Please hep me to handle this situation.
>
>
>
>
> Thank you in advance!
>
> Best regads,
> Olesya
>
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/10a8545c-fcf9-4051-8429-836c94dc6292o%40googlegroups.com.


Re: CRITERIA_PERFORMANCE_REPORT in Adwords API

2020-08-15 Thread Олеся Васина
More strange logs with Unresolved schema 
2020-08-15 09:36:50.912 pid=590231 MainThread 
run_id=15c0f23c-1755-4f9c-8bb6-aa505742cce2   DEBUG zeep.xsd.schema: Add 
document with tns http://www.w3.org/2001/XMLSchema to schema 139759520401672
2020-08-15 09:36:50.912 pid=590231 MainThread 
run_id=15c0f23c-1755-4f9c-8bb6-aa505742cce2   DEBUG zeep.xsd.schema: Init 
schema document for None
2020-08-15 09:36:50.912 pid=590231 MainThread 
run_id=15c0f23c-1755-4f9c-8bb6-aa505742cce2   DEBUG zeep.xsd.schema: Add 
document with tns https://adwords.google.com/api/adwords/cm/v201809 to 
schema 139759520401672
2020-08-15 09:36:50.913 pid=590231 MainThread 
run_id=15c0f23c-1755-4f9c-8bb6-aa505742cce2   DEBUG zeep.xsd.schema: 
register_element('{https://adwords.google.com/api/adwords/cm/v201809}reportDefinition',
 
)>)
2020-08-15 09:36:50.913 pid=590231 MainThread 
run_id=15c0f23c-1755-4f9c-8bb6-aa505742cce2   DEBUG zeep.xsd.schema: 
register_type('{https://adwords.google.com/api/adwords/cm/v201809}Selector', 
)
2020-08-15 09:36:50.913 pid=590231 MainThread 
run_id=15c0f23c-1755-4f9c-8bb6-aa505742cce2   DEBUG zeep.xsd.schema: 
register_type('{https://adwords.google.com/api/adwords/cm/v201809}Predicate', 
)
2020-08-15 09:36:50.914 pid=590231 MainThread 
run_id=15c0f23c-1755-4f9c-8bb6-aa505742cce2   DEBUG zeep.xsd.schema: 
register_type('{https://adwords.google.com/api/adwords/cm/v201809}DateRange', 
)
2020-08-15 09:36:50.914 pid=590231 MainThread 
run_id=15c0f23c-1755-4f9c-8bb6-aa505742cce2   DEBUG zeep.xsd.schema: 
register_type('{https://adwords.google.com/api/adwords/cm/v201809}OrderBy', 
)
2020-08-15 09:36:50.914 pid=590231 MainThread 
run_id=15c0f23c-1755-4f9c-8bb6-aa505742cce2   DEBUG zeep.xsd.schema: 
register_type('{https://adwords.google.com/api/adwords/cm/v201809}Paging', 
)
2020-08-15 09:36:50.915 pid=590231 MainThread 
run_id=15c0f23c-1755-4f9c-8bb6-aa505742cce2   DEBUG zeep.xsd.schema: 
register_type('{https://adwords.google.com/api/adwords/cm/v201809}Predicate.Operator',
 
https://adwords.google.com/api/adwords/cm/v201809}Predicate.Operator',
 
base_type=http://www.w3.org/2001/XMLSchema}string')>)>)
2020-08-15 09:36:50.915 pid=590231 MainThread 
run_id=15c0f23c-1755-4f9c-8bb6-aa505742cce2   DEBUG zeep.xsd.schema: 
register_type('{https://adwords.google.com/api/adwords/cm/v201809}SortOrder', 
https://adwords.google.com/api/adwords/cm/v201809}SortOrder',
 
base_type=http://www.w3.org/2001/XMLSchema}string')>)>)
2020-08-15 09:36:50.915 pid=590231 MainThread 
run_id=15c0f23c-1755-4f9c-8bb6-aa505742cce2   DEBUG zeep.xsd.schema: 
register_type('{https://adwords.google.com/api/adwords/cm/v201809}ReportDefinition.ReportType',
 
https://adwords.google.com/api/adwords/cm/v201809}ReportDefinition.ReportType',
 
base_type=http://www.w3.org/2001/XMLSchema}string')>)>)
2020-08-15 09:36:50.915 pid=590231 MainThread 
run_id=15c0f23c-1755-4f9c-8bb6-aa505742cce2   DEBUG zeep.xsd.schema: 
register_type('{https://adwords.google.com/api/adwords/cm/v201809}ReportDefinition.DateRangeType',
 
https://adwords.google.com/api/adwords/cm/v201809}ReportDefinition.DateRangeType',
 
base_type=http://www.w3.org/2001/XMLSchema}string')>)>)
2020-08-15 09:36:50.915 pid=590231 MainThread 
run_id=15c0f23c-1755-4f9c-8bb6-aa505742cce2   DEBUG zeep.xsd.schema: 
register_type('{https://adwords.google.com/api/adwords/cm/v201809}DownloadFormat',
 
https://adwords.google.com/api/adwords/cm/v201809}DownloadFormat',
 
base_type=http://www.w3.org/2001/XMLSchema}string')>)>)
2020-08-15 09:36:50.916 pid=590231 MainThread 
run_id=15c0f23c-1755-4f9c-8bb6-aa505742cce2   DEBUG zeep.xsd.schema: 
Resolving in schema 







суббота, 15 августа 2020 г., 9:24:58 UTC+3 пользователь Олеся Васина 
написал:
>
> HI!
>
> I am getting strange logs while fetching data 
> from CRITERIA_PERFORMANCE_REPORT.
>
> Code has worked successfully before.
>
> DEBUG zeep.cache: Cache HIT for 
> https://adwords.google.com/api/adwords/reportdownload/v201809/reportDefinition.xsd
> DEBUG zeep.xsd.schema: Init schema document for None
>  DEBUG zeep.xsd.schema: register_type('{
> http://www.w3.org/2001/XMLSchema}string',  object at 0x7f1c594f2cc0>)
> DEBUG zeep.xsd.schema: register_type('{
> http://www.w3.org/2001/XMLSchema}boolean', 
>  
>
> DEBUG zeep.xsd.schema: register_type('{
> http://www.w3.org/2001/XMLSchema}time',  object at 0x7f1c5951bf60>)
>  DEBUG zeep.xsd.schema: register_type('{
> http://www.w3.org/2001/XMLSchema}gYear',  object at 0x7f1c5951bcf8>)
>
>
> Looks like non valid XML schema, but i don't know how to fix it.
>
> query 
>
> SELECT
>   Date,
>   ExternalCustomerId,
>   CampaignId,
>   AdGroupId,
>   Id,
>   Criteria,
>   CriteriaType
> FROM CRITERIA_PERFORMANCE_REPORT
> WHERE Status = 'ENABLED'
> DURING {start_date}, {end_date}
>
>
> python code
>

CRITERIA_PERFORMANCE_REPORT in Adwords API

2020-08-15 Thread Олеся Васина
HI!

I am getting strange logs while fetching data 
from CRITERIA_PERFORMANCE_REPORT.

Code has worked successfully before.

DEBUG zeep.cache: Cache HIT for 
https://adwords.google.com/api/adwords/reportdownload/v201809/reportDefinition.xsd
DEBUG zeep.xsd.schema: Init schema document for None
 DEBUG zeep.xsd.schema: 
register_type('{http://www.w3.org/2001/XMLSchema}string', 
)
DEBUG zeep.xsd.schema: 
register_type('{http://www.w3.org/2001/XMLSchema}boolean', 
http://www.w3.org/2001/XMLSchema}time', 
)
 DEBUG zeep.xsd.schema: 
register_type('{http://www.w3.org/2001/XMLSchema}gYear', 
)


Looks like non valid XML schema, but i don't know how to fix it.

query 

SELECT
  Date,
  ExternalCustomerId,
  CampaignId,
  AdGroupId,
  Id,
  Criteria,
  CriteriaType
FROM CRITERIA_PERFORMANCE_REPORT
WHERE Status = 'ENABLED'
DURING {start_date}, {end_date}


python code
def fetch_data_from_adwords_api(client, subperiod: dtu.period, 
client_customer_id: str, **kwargs: dict) -> Iterable:
awql_start_dt = subperiod.start.strftime(AWQL_DATE_FORMAT)
awql_end_dt = subperiod.end.strftime(AWQL_DATE_FORMAT)

logger.info('Fetching data using Adwords API')

query = kwargs['query'].format(
start_date=awql_start_dt,
end_date=awql_end_dt
)

report = client.GetReportDownloader().DownloadReportAsStreamWithAwql(
query, 'CSV', skip_report_header=True,
skip_column_header=True, skip_report_summary=True,
include_zero_impressions=False, 
client_customer_id=client_customer_id
)

data_df = pd.read_csv(
report, encoding='utf8', names=kwargs['data_structure'].keys(),
converters={}, dtype=kwargs['data_structure'],
)

if data_df.empty:
logger.info(f'Empty results for {client_customer_id}')
return []

return data_df.to_dict(orient='records')

Is a result i get an empty dataframe for one customer.

But when i try to load report for all customers, code is working for about 
20 hours and fails for timeout.

I tried to filter empty df, but it didn't help to prevent these logs.

Please hep me to handle this situation.




Thank you in advance!

Best regads,
Olesya

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/0429628d-f045-422b-9c7e-5b2f9b9c57d4o%40googlegroups.com.


Google Ads Api Beta

2020-05-26 Thread Олеся Васина

Hi all! 

We need to fetch different statistics using Ads API and Adwords API. Now we 
get more and more accounts from which we can't download statistics using 
Adwords API, but we can download using Ads API.
So we need to upgrade our production code to new API. 
That is why i would like to ask, if this API is still in beta and is it 
safety for resources and data to upgrade? 

Is Ads API used in production processes successfully?  

O would appreciate any recommendations.

Thank you in advance!

Have a nice day, 

Olesya

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/0d8aef61-b4ed-4fa7-a59d-d25b8c8e2832%40googlegroups.com.


CRITERIA_PERFORMANCE_REPORT in Google Ads Api

2020-06-17 Thread Олеся Васина
Hello!

Can you please help me to migrate CRITERIA_PERFORMANCE_REPORT  to Google 
Ads Api?

Thank you in advance,

Have a nice fay,

Olesya

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/ab063099-3530-43fe-b179-c8332387c3ebo%40googlegroups.com.


Re: CRITERIA_PERFORMANCE_REPORT in Google Ads Api

2020-06-22 Thread Олеся Васина
Nirmita, thank you!

Query is quite appropriate for me.

But i can't select fields from segments, such as segments.date  and 
segments.keyword.ad_group_criterion which i need for my task.

Can you please help me to solve this problem?


Thank you!

Best regards,
Olesya

понедельник, 22 июня 2020 г., 21:24:26 UTC+3 пользователь 
adsapiforumadvisor написал:
>
> Hi Olesya,
>
> Thanks for reaching out. With regards to your concern, you can combine the 
> report and  you can query all of that info from the  ad_group_criterion 
>  
>  report and you can pull fields from the reports in the "attributed 
> resources”, Please see the below query to get the data  what you are 
> looking for.
>
> Query: 
>
> Select Customer.id, Campaign.id, ad_group.id, ad.id, 
>
> segments.keyword.ad_group_criterion
>
> from Ad_group_criterion
> Let me know if you have any questions.
>
> Thanks,
> Nirmita Patel Google Ads Team
>  
>
> ref:_00D1U1174p._5004Q217B54: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 
"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/65e4b9ca-2dad-4c2f-b299-91415270bda8o%40googlegroups.com.


Re: CRITERIA_PERFORMANCE_REPORT in Google Ads Api

2020-06-22 Thread Олеся Васина
Hi Nirmita,

Thanks for your answer.

I need to migrate this code to Google Ads API

SELECT
  Date,
  ExternalCustomerId,
  CampaignId,
  AdGroupId,
  Id,
  Criteria,
  CriteriaType
FROM CRITERIA_PERFORMANCE_REPORT
DURING {start_date}, {end_date}


I can't use ad_group_criterion 
 
report 
because there is no data field in it.
In keyword view there are no fields except resource_name 

 in 
resource_fields.


Also i have problems with CriteriaType and Criteria.


Can i combine some reports? 


среда, 17 июня 2020 г., 22:33:02 UTC+3 пользователь adsapiforumadvisor 
написал:
>
> Hi Olesya,
>
> Thanks for reaching out. With regards to your concern 
> about migrating CRITERIA_PERFORMANCE_REPORT  to Google Ads API, here is our 
> migration 
> guide 
>  for 
> reports. In it, you will see which reports types and fields map from the 
> AdWords API to Google Ads API.  If you would like to get those metrics, you 
> have to use the specific report for that criterion type. For example, if 
> you want keyword metrics you have to use the Keyword View 
> , 
> gender metrics would use Gender View 
> , age 
> range stats the Age Range View 
> , 
> etc. The ad_group_criterion 
>  
> report is the closest to the Criteria Performance Report. However, this 
> report contains no metrics.
>
> Let me know if you have any questions.
>
> Thanks,
> Nirmita Patel Google Ads Team
>
>  
>
> ref:_00D1U1174p._5004Q217B54:ref
>
SELECT
  Date,
  ExternalCustomerId,
  CampaignId,
  AdGroupId,
  Id,
  Criteria,
  CriteriaType
FROM CRITERIA_PERFORMANCE_REPORT
DURING {start_date}, {end_date}





-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/39563375-efd8-4ea5-8635-0277953541c8o%40googlegroups.com.


Filter active accounts using Google ads Api

2020-08-14 Thread Олеся Васина
Hello!

I have many accounts and i don't want to worry about their inability.

Please help me to exclude inactive or paused accounts from my report.


Thank you in advance!

Have a nice day!

Olesya

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/bd9ec457-28d7-4906-97a3-2b3bd7697aa2o%40googlegroups.com.