CRITERIA_PERFORMANCE_REPORT in Google Ads Api

[Олеся Васина]

Hello!

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

Thank you in advance,

Have a nice fay,

Olesya

[Google Ads API Forum Advisor Prod]

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

[Олеся Васина]

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 написал:

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

[Google Ads API Forum Advisor Prod]

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

[Олеся Васина]

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 написал:

[Google Ads API Forum Advisor Prod]

Hi Olesya,

Thanks for reaching out. The segments.keyword.ad_group_criterion is fields/resources can be selected with this segment and the ad_group_criterion report contains no metrics.

Select Customer.id, Campaign.id, ad_group.id, ad.id, 

segments.keyword.ad_group_criterion

from Ad_group_criterion WHERE segments.date DURING LAST_7_DAYS

Let me know if you have nay questions.