PHP Get active campaigns with less than 100 remarketing users

[Marketing Xilon]

Hello,

Using PHP, how can I get the list of et active campaigns with less than 100 remarketing users?

Thanks

[Shwetha Vastrad (AdWords API Team)]

Hi,

For a CrmBasedEmailList, the user list size will show as zero until the list has at least 1,000 members. You could use AdwordsUserListService to retrieve the list of remarketing lists with size as zero, and then retrieve CampaignCriterion and AdGroupCriterion associated with these UserLists using predicates via CampaignCriterionService and AdGroupCriterionService respectively. You can retrieve the associated CampaignIds and their states. The code samples available here provide examples of basic operations using AdWords API PHP client library. 

I hope this helps. 

Regards,

Shwetha, AdWords API Team.

[Marketing Xilon]

Hi Shwetha,

I'm afraid I'm a little confused about your explanation.

"You could use AdwordsUserListService to retrieve the list of remarketing lists with size as zero, and then retrieve CampaignCriterion and AdGroupCriterion associated with these UserLists using predicates via CampaignCriterionService and AdGroupCriterionService respectively"

What exactly may I get retrieving CampaignCriterion and AdGroupCriterion?

"You can retrieve the associated CampaignIds and their states"

Why should I need the states of the campaigns?

Thanks!

[Shwetha Vastrad (AdWords API Team)]

Hi,

There is no straightforward way to get all enabled campaigns with less than 100 remarketing users. If you just want to get all enabled campaigns, you can use CampaignService as shown here using a predicate to filter for ENABLED campaigns. A campaign's state indicates if it is active or not. 

When you use remarketing lists for targeting, you are essentially creating CampaignCriterion or AdGroupCriterion of type USER_LIST. You need to use AdwordsUserListService to first retrieve the UserLists with size as 0. You can then query for data from Audience Performance Report using the following query and use the UserList names obtained above in the predicate:

SELECT Id, UserListName, AdGroupId, CampaignId FROM AUDIENCE_PERFORMANCE_REPORT WHERE CampaignStatus = 'ENABLED' AND UserListName IN [userList_names]

Let me know if this works. 

[Marketing X]

Thank you for clarifying!