Optimization based on Ranking

1. First, follow the steps on how to perform the usual bid optimization (see Bulksheet Optimization).
2. Insert a column to the right of Keyword Text for the ranking. Label the column accordingly.
   • For the purpose of this training, we’ll assume that:
     • Keyword Text is in Column AD
     • New column will be Column AE and will be labeled as ‘Sponsored Ranking’.

1. Highlight Sponsored Ranking [Column AE] and update the Format from Text to Number

   • In the Home tab > Number section, click the dropdown to the right of ‘Text’ and select Number.

   

2. Using Helium 10, extract the Organic Ranking keywords for your ASIN

3. In another sheet (for this training, let’s call this sheet KW Ranking) where your keywords are found (in Column A) , indicate in:

   1. Column B: Organic Ranking
   2. Column C: Sponsored Ranking

1. Go back to Sponsored Ranking [Column AE] in the bulksheet, in cell AE2 (right below the header), add a formula to automatically pull the Sponsored Ranking for the respective keyword from the other sheet.

   • Formula: IFERROR(VLOOKUP(AD2,’KW Ranking’!A:C,3,0),””)
   • Copy the formula to the very last cell of the column by hovering the mouse pointer to the lower right corner of the cell where it turns into a cross, then double click.
   • Remove the decimal points.

   2023-06-09_11-38-04.mp4

2. In Sponsored Ranking [Column AE], select ranking of 5 and above.

   

3. In Match Type [Column AF], select “exact” only.

1. In New Bids [Column AC], increase by 5%.

Want a Quick Chat for you Brand ? Connect me here 👉

Q&A Session or Consultation

Comparing New Bid for Exact versus Broad and Phrase Match Types

Make sure that the Bids for exact match type are higher than the ones with broad and phrase type.

1. For Match [Column AF], update the filter to select all match types.