Looker Studio Dashboard

I created a Looker Studio dashboard that looked at the google ads accounts we were running. The first slide or dashboard looks at a snapshot of our favorite metrics along with the budget associated. The second dashboard looks at trends in a graph form and the third looks at month over month performance. The last page shows the bottom 5 performers and top 5 performers. The feature on this dashboard is the last pages custom formula that I created. The formula evaluates the top 5 ad performers and bottom 5. This score looks at month-over-month growth in both clicks and phone calls. Because calls are a stronger signal of customer intent, we give them a higher weight: Phone Calls = 65% of the score Clicks = 35% of the score. To make them comparable, each campaign’s growth is normalized (put on the same scale, 0 to 1). Then we combine them using the weights: Top Performer Score = (Normalized Calls Change × 0.65) + (Normalized Clicks Change × 0.35) Finally, campaigns are ranked by this score.