So we recently acquired a new dealership and ran into this exact issue when examining the dealership's paid search account. The vendor had every model in a single campaign which gave them no control over the spend of each individual model. One of the things we look at is our annual sales volume vs our annual paid search spend for each model to quickly see if anything is way out of whack. In the chart below, the orange line is our annual unit sales and the blue bars are the annual paid search spend. You'll notice we spent way too much money on the Camaro, Suburban, Volt, and Corvette but not enough money on the Equinox, Traverse, and Trax. Why did this vendor spend $6,000 advertising the Corvette when we only sold 3 the entire year and probably would have sold them with zero paid search advertising. This is a report everyone can easily run using Microsoft Excel to help identify wasted spend and areas of opportunity.