Multiple clients and trainees have asked us how they can use Google Data Studio to track their organization’s progress toward a goal, such as an annual sales goal, traffic goals or the number of leads they received (as measured by Google Analytics goals).
Here’s a way to do it.
- Create a scorecard and pull in your comparison metric that’s working toward your goal. (In this example, I’ll use Google Analytics Sessions and say we want to hit 3,000 per month)
- Select your Metric, then select “Create Field.” This creates a new metric that you calculate from your comparison metric divided by your set goal. Just make sure you have the right Data source selected such as Google Analytics (which is called Get Found Madison in the screenshot below),
3. In this case, we want to know Sessions/3000. Set the number Type to be a Percent (under Numeric).
Voila! You can now see the percent of your goal that you’ve reached! (We often rename the Google Analytics Sessions metric to “Visits” for the sake of clarity for our clients.)
Try this for sessions, users, leads, revenue and more!