How To Add Negative Mobile Placements in Google Ads
Overview
This Action allows you to automatically exclude app inventory from campaigns running on the display network.
This tutorial focuses on mobile placements with clicks in last 7 days
Instructions
This Action setup uses the Campaign Negative Mobile Apps Action Type
Set up your change logic
Login to Alli Data and select the client you want to create an action for
Navigate to Reports → Explorer and select New Data Report
Give your report a Name and update the Report Type to Custom Redshift
Copy and paste the SQL Example in from below and update anything within and including
{
}
to match your client settingsOnce your SQL is updated, click Publish to update the query
Click Preview to ensure the output is as expected
Create a new Action
Go to Alli Actions then select Create Action
Filter the Vendor column for Google Ads and select the Campaign Negative Mobile Apps Google Ads Action Type
Continue to the Configure screen and select your authenticated account
Click Next to set up and link where your changes are coming from, for this example that will be Alli Data
Insert your report name i.e. {client}.{view name you set in step 1-c}
Review your action setup
Save and Schedule your action to run
SQL Example
Login_customer_id
This corresponds to the MCC ID. If you don’t have MCC for your account, this line can be removed.
Ex: ‘{XXX-XXX-XXXX}’ becomes ‘012-345-6789’
Context for the WHERE section below:
This is where you choose campaigns to include or exclude from this action.
The way this is done is saying “campaignname ILIKE '%TEXTHERE%'”.
The ILIKE means “contains” and is not case sensitive, it will match uppercase or lowercase.
The TEXTHERE piece is where you can put common pieces of your campaign names to identify which campaigns to select, such as “brand”, “nonbrand”, “retargeting”, etc.
That text needs to be surrounded by a tick ' on each side
The percent signs mean that it is looking for that text no matter what is before or after it in the campaign name.
Essentially using percent signs means “look for campaign names that contain this text”, not using percent signs would mean “look for campaign names that exactly match this text”
Example
ILIKE '%part%' will match to party & apartment
ILIKE 'part%' will match to party but not apartment
SELECT
'{XXX-XXX-XXXX}' as login_customer_id
account_id as customer_id,
campaign_resource_name,
appid
FROM
(
SELECT
account_id,
campaign_resource_name,
campaignid
REPLACE(DOMAIN, 'mobileapp::', '') AS appid,
campaignname,
DOMAIN,
sum(clicks) AS clicks
FROM {client}.{YOUR REPORT NAME}
WHERE DOMAIN ILIKE '%mobileapp%'
AND date >= convert_timezone('US/Central',SYSDATE)::DATE - 7
AND
(
{campaign inclusions or exclusions}
Example:
campaignname ILIKE '%brand%'
OR campaignname ILIKE '%nonbrand%'
)
GROUP BY campaignname,
campaignid,
account_id,
campaign_resource_name,
DOMAIN
)
WHERE clicks > 3
Related articles
- How To Handle Common Types of Actions Issues
- How To Filter Alli Data Reports by Date to Power Actions - Tips & Tricks
- How To Run an Action One-Off with Manual File
- How To Connect your Google Sheet to Actions
- How To Set Up a Manual Upload Action
- How To Test Your Action
- How To Schedule Your Action to Run
- How To Disable or Remove an Action
- How To QA Your Action Runs
- How To View Error Messages on an Action That Ran
- How Manage Partner Platform Authentication in Actions
- How-To Add Locations to Campaigns in Google Ads
- How-to Pause or Activate Meta (Facebook) Ads
- How To Add Negative Mobile Placements in Google Ads
- How To Add Negative Keywords to Google Ads