Wednesday, 11 June 2014

5 Streamlined Keywords Processes before Compilation to PPC campaign

We identified 5 keywords process flows that can be streamlined before compiling them into a format that can be loaded to Adwords through Adwords Editor.

  1. Permute
  2. Combine
  3. Extract
  4. Filter
  5. Select 

Permutation


Permutation is the process of rearranging word order of a keyword phrase. This process is useful in expanding your existing campaigns in the following scenario:
  • When you have high performing Modified Broad Match keywords that you want to expand to Phrase Match and Exact Match in order to serve more precise ad copy and to have better control of CTR and CPC.
  • When you have high performing Phrase Match or Exact Match keywords that you want to explore variations of different word order.

4 Quick Steps:
  1. Select cells with the keywords you want to permute
  2. Click Permute Ribbon button
  3. Define settings, i.e. ad group grouping method and name, Max CPC, keywords status, etc.
  4. Click Permute button to process and compile keywords to a format readily to be copy and paste to Adwords Editor

The streamlined process is fast with Excel VBA (Macro) automation.


Notes:
  • You can permute as many keywords in any one time with the limit of 1,000,000 output keywords.
  • You can group the keyword variations based on 
    • the original keyword, and 
    • further grouped by match type. 
  • If you further grouped your variations by match type, you can easily select and copy 
    • the Exact Match output and load to Adwords as negative keywords in the Ad Group for Phrase Match
    • the Phrase Match output and  load to Adwords as negative keywords in the Ad Group for Broad Match
  • This will ensure a more predictable Adwords' ad triggering behavior.
  • More about Permutation Process.



  • Use first, pay later. Download now
  • 30-day evaluation period
  • Authentic full version (non trial)
  • 30-day money back guarantee
  • Future new functions and bug fix
  • You may download from Dropbox
It runs on desktop, Windows 7 and higher, Excel 2007 and higher.


Combination


Combination is the process to combine and mix words in multiple columns words lists to create new keywords. This is the process useful to build a new campaign from scratch. Below is an example:

You can combine multiple keywords list like:
  • sport wear, i.e. running shoes, athletic shoes, sneakers, etc.
  • colors, i.e. red, blue, white, rainbow, etc.
  • brand, i.e. Nike, Reebok, Puma, etc.

To keyword phrases like "running shoes red Nike", "running shoes blue Reebok", etc.

This process is particular useful when you start a new project where the search terms contain many possible combination of words.


4 Quick Steps:
  1. Select multiple columns of words (each column is a list of words)
  2. Click Combine Ribbon button
  3. Define settings, i.e. ad group grouping method and name, Max CPC, keywords status, etc.
  4. Click Combine button to process and compile keywords to a format readily to be copy and paste to Adwords Editor

The streamlined process is fast with Excel VBA (Macro) automation.

Note:

  • You can combine as many columns of words or as many words in a columns as you like. The limit is 1,000,000 output keywords.
  • You can select column or columns that the words in the columns will be combined to become ad group name. Keywords will be grouped accordingly.
  • You may further group the keywords by match types.
  • You can have extra combinations that skip words in certain columns
  • More about Combination Process


Extract


Keywords come from different sources, i.e. Google Keyword Planner, keywords competition tools, suggested search terms at the bottom of SERP, download from Adwords account, etc.

You can extract and compile the keywords that contain specific words as indicated in a text box.

4 Quick Steps:
  1. Select range of cells of the entire keyword list
  2. Click By Words Ribbon button
  3. Define settings, i.e. specific words, ad group grouping method and name, Max CPC, keywords status, etc.
  4. Click Group button to extract and compile keywords to a format readily to be copy and paste to Adwords Editor


The extracted keywords will be deleted from its original cells. You can continue to work on the remaining keywords without fear of duplication.

Extract and compile from raw keywords to table readily to be loaded to Adwords.


Filter


It works like Extract above, but it is the reversal. You extract and compile the keywords that does not contain specific words in the text box.

4 Quick Steps:
  1. Select range of cells of the entire keyword list
  2. Click By Words Ribbon button
  3. Define settings, i.e. specific words, mark Inverse check box, ad group grouping method and name, Max CPC, keywords status, etc.
  4. Click Group button to extract and compile keywords to a format readily to be copy and paste to Adwords Editor

The extracted keywords will be deleted from its original cells. You can continue to work on the remaining keywords without fear of duplication.

Filter out the keywords that contain specific words and extract the remaining.


Manually Select


How many times when you go through your keywords reports or SEO keywords lists, you hope to be able to just select, group and upload them to Adwords into ad groups? You can now.

4 Quick Steps:
  • Press Ctrl + multiple Mouse Clicks (and click and drag to select a range) to select the range or ranges of cells with keywords that you want to compile. 
  • Click Select Ribbon button
  • Define settings, i.e. use keywords in active cell as ad group name, match types, Max CPC, etc.
  • Click Group button. All your selected keywords will be compiled to a format readily to be copy and paste to Adwords Editor

The selected keywords will be deleted from its original cells. You can continue to work on the remaining keywords without fear of duplication.

Select the keywords, group and compile. More notes here.




  • Use first, pay later. Download now
  • 30-day evaluation period
  • Authentic full version (non trial)
  • 30-day money back guarantee
  • Future new functions and bug fix
  • You may download from Dropbox
It runs on desktop, Windows 7 and higher, Excel 2007 and higher.

  • The above 5 streamlined keyword processes are merely part of the functions of Keywords Editor.
  • Keywords Editor have more functions which are flexible enough for user to edit, expand and manipulate keywords on the fly and compile them quickly into a format readily for upload to Adwords.
  • Read more about Keywords Editor




No comments:

Post a Comment