Quick optimize of Ad groups on Adwords. Take each keyword's impression multiply by quality score, add all of them up, then divide them by ad group's total impre

Quick optimize of Ad groups on Adwords. Take each keyword's impression multiply by quality score, add all of them up, then divide them by ad group's total impressions to give you a good idea which ad groups need Quality Score Improvement. You can do this through excel by creating pivot tables.