Objective

Process

Use Case Scenarios

Conclusion

Objective

• To equip you with the knowledge necessary to determine which keywords and which product targets are causing the most impact on your campaign.
• To maximize optimization for the top sales drivers to further increase Sales, even organically

Process

1. Download a bulksheet. (See Bulksheets Explained for more information)
2. Open your downloaded report.
3. Add filters and Entity [Column B] to only show:
   1. Keyword
   2. Product Targeting
4. Select all the data then Copy.
5. Paste the data into a new sheet and add filters again.
6. Sort the report by Sales [Column AN] from Largest to Smallest.
7. Insert a new column between Sales [Column AN] and Orders [Column AO].
8. Now, a new column is in Column AO. Name the header as % of Total Sales.
9. Highlight % of Total Sales [Column AO] and update the format as a percent (%).
10. Enter this formula in cell AO2: =AN2/SUM(AN:AN) then drag the formula to the rest of the rows in this column.
11. Identify the top sales drivers based on the % of Total Sales [Column AO].