Hi,
Thanks for Input.
To get Data for Manage Placement I have used this query. But the no of rows
in the report and in UI are different.
UI has 45 rows while report has 30.
$query = "SELECT campaign.id, "
. "campaign.name, "
. "campaign.status, "
. "ad_group.id, "
. "ad_group.name, "
. "ad_group.status, "
. "ad_group_criterion.criterion_id, "
. "ad_group_criterion.placement.url, "
.
"ad_group_criterion.mobile_app_category.mobile_app_category_constant, "
. "ad_group_criterion.mobile_application.app_id, "
. "ad_group_criterion.youtube_channel.channel_id, "
. "ad_group_criterion.youtube_video.video_id, "
. "ad_group_criterion.status, "
. "ad_group_criterion.negative, "
. "ad_group_criterion.type, "
. "FROM managed_placement_view "
. "WHERE segments.date BETWEEN '$startDate' AND
'$this->endDate' "
. "AND campaign.status = 'ENABLED' "
. "AND ad_group.status = 'ENABLED' "
. "AND ad_group_criterion.negative = 'FALSE' "
. "AND ad_group_criterion.criterion_id > '0' "
. "AND ad_group_criterion.type IN ('MOBILE_APPLICATION',
'MOBILE_APP_CATEGORY', 'PLACEMENT', 'YOUTUBE_CHANNEL', 'YOUTUBE_VIDEO') "
. "ORDER BY segments.date ASC";
On Monday, 5 August 2019 20:11:43 UTC+5:30, adsapiforumadvisor wrote:
>
> Hi,
>
> This report view will give you placements from the ad group. You can use
> the ad_group_criterion.negative
> <https://developers.google.com/google-ads/api/fields/v2/ad_group_criterion#ad_group_criterionnegative>
>
> to see whether the placement is added or excluded.
>
> Regards,
> Anthony
> Google Ads API Team
>
> ref:_00D1U1174p._5001UEGyF4: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/e27c2cf3-9902-4bee-8a2b-1e62223282f8%40googlegroups.com.
