I got 99 problems but an excel formula ain't one of them thanks to [USER=4107]@jon.berna[/USER] (and [USER=688]@Jason[/USER] for confirming)!
Our group had a pretty good review game before I left for DI but over the last couple years they stopped asking for new reviews. Most of the GM's did reply and resolve a lot of the bad reviews that came in except there was no longer a flow of good reviews to offset. Beyond the obvious gaming (fake reviews or the head-em-off-at-a-qualifying-question-before-sending-them-to-your-review-links) that went on when "Reputation" was the new shiny nickel at NADA back in the day, I'm sure if anyone revealed their algorithm for Stars now the industry would see new types of cheating. I do know that Google games me within Local Guides. I leave a one-star review, 1 point, but if I add comments, more points, and if I add a picture, I'm practically Google royalty!
Issue I have now is if I fire DealerRater back up, that wasn't used for 2 years, would you point people to leave reviews on their program, in order to build it back up, knowing they're going to see your crappy 3.4? Oh, and if it is a straight math algo on DealerRater I would need 1,263 new 5-start reviews to get the current 3.4 to a 4.6 at one of the stores (according to Berna's formula).
We did fire up Reputation.com trials with FordDirect and Podium is wanting the same for our Kia stores. Anyone have an opinion on best method to increase review volume (for Service as well)? Prior to 2017 I had everyone handing out cards with our review page links, a couple automated emails asking for reviews, as well as we incentivized sales people with contests for a few months (which apparently a lot of salesperson's moms had great experiences at the stores).