Skip to main content
Skip table of contents

Matching Logic - Alli Search Automation

Table of Contents

Explanation

Matching Logic refers to a process used at PMG, where information from a single row in an input Google Sheet is systematically applied to multiple related campaigns, ad groups, or accounts. This method is especially useful for managing large-scale advertising efforts, ensuring consistency, and streamlining the application of data across various entities.

This approach allows for efficient management of large-scale advertising efforts. Instead of manually updating each campaign or ad group, the matching logic automates the process, ensuring that each piece of data is correctly applied where needed.

In all Search Automation Google Sheets, you will see something similar to the following columns:

These columns use following matching logic to match to your accounts, campaigns, and ad-sets / ad-groups. Columns with ‘Inclusion’ or ‘Exclusion' in them are generally used for matching logic, and will determine which information is included or excluded.

How To - Basic

To match using words, the phrase/text of the naming structure that you use to indicate whether to pull must be separated from the other parts of the naming structure by some type of delimiter.

The following are delimiters recognized by Matching Logic:

  1. Bar |

  2. Underscore _

  3. Hyphen -

  4. Space

  5. Carat ^

  6. Tilde ~

The following are two examples of the words you can match to using Matching Logic, after it is broken out by a delimiter:

Campaign Name

Applicable Keywords

RT-USDPA_WomenAll_FB|No|US|FEFB|D_M|FB|DPAM|18|65|NoList|Noint

RT, USPDA, WomenALL, FB, No, US, FEFB, D, M, DPAM, 18, 65, NoList, Noint

GAFA_Outlet_Coupons_Search_Branded_Exact_National

GAGA, Outlet, Coupons, Search, Branded, Exact, National

Matching Logic also automatically checks for plurality. This means if you want to match to "Jean", the logic will automatically check for "Jeans" as well. This is true for the inverse, if you search for "Jeans", then Alli will also match to the word singular word "Jean".

How To - Advanced

Similar to SQL, Matching Logic uses ‘AND' and ‘OR' logic. Parenthesis can be used to group logic for more complexed combinations.

Logic

Symbol

Basic explanation

Campaign Inclusions Example

Explanation

AND

&

"this and that"

RT&DPA

Will only match adsets that have both RT and DPA in the name

OR

,

"this or this"

DPA,DPAM

Will match adsets that have either DPA or DPAM

AND and OR

& ,

"this and that or this"

RT&DPAM,RetargetingDPA

Will match adsets that have RT and DPA or only RetargetingDPA

AND OR

&(,)

Ralph Lauren&(US,CA)

Will match to accounts that have ‘Ralph Lauren’ AND (US OR CA). The parentheses manipulate the order of operations. Otherwise it would only match to accounts with “Ralph Lauren US” OR accounts with “CA”

For example, if I wanted to match to my Retargeting DPAs with the following campaign names:

Original Campaign Names

Available Words to Match to

RT-USdpashirts_alldevices_DPAM

RT, USdpashirts, alldevices, DPAM

RT-USdpashoes_mobile_DPAM

RT, USdpashoes, mobile, DPAM

In order to match to these, I would want to use RT&DPAM because those are the only available words they have in common. I can NOT match to USdpa because is it not an exact match to USdpashirts and USdpashoes.

**If the word(s)/phrase you are looking for already contains a delimiter (like a dash or underscore) make sure to replace that delimiter with an "&". Example: If you wanted to match to all campaigns that contain 'RT-USjuly' (like RT-USjuly_shirts), you should use 'RT&USjuly', not the whole phrase'RT-USjuly'

If you wanted to match to all Accounts, Campaign, and/or Adsets for you client, simply pull the word 'All' in each of the inclusion columns.

You also must do this for every Inclusion column if you don't have specific inclusions for that column. (So if you have specific inclusions in the Campaign Inclusions, put "All" in both Adset and Account. Or if you have specifics in the Adset Inclusions, put "All" in Account and Campaign.)

More Examples

The following are some sample DPA campaigns:

PR-USDPA_DBA_W_060718_DPAM_MF

PR-USDPA_DBA_Promo_W_070118_MF_DPAM

PR-USDPA_DBA_Promo_M_070118_MF_DPAM

PR-USDPA_DBA_M_060718_DPAM_MF

If you wanted to match to all of the campaigns ANY of the following entries would work:

If you wanted to match to all DPA's but wanted to exclude Promos ANY of the following entries would work:

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.