This is part two of the Google Ads Audit tutorial. We'll look at Campaign Performance in the Data Studio.
I recommend doing a short analysis with Google Sheets - a benefit for marketing consultants as well as for the clients they're working to scale.
The data will usually be sorted by cost conversion for lead generation clients and all conversion value and cost for eCommerce.
1. Click on Campaign overview report. Confirm the date range is correct.
2. Take a screenshot. Make sure to include the top text because it helps to describe and explain the data.
3. Copy and paste the report data into the Analysis page.
4. Export the Campaign performance report to Google Sheets.
5. Then share the page. Now if the client wants to review the numbers, they can be referenced.
5. Link the spreadsheet to the Analysis header.
6. Go back to the breakdown of the campaign in Google Sheets. Sort the data by costs. This is typically the best way to find which ones have the most spend. Clicks may be a good feature to note as well.
That is how to audit the campaign performance for Google ads. It’s a useful way of determining the success of an account as well as tangible evidence to show the client why changes may need to be implemented.
Part three will look at Ad Group Performance.
Shorten your learning curve, make the most of your resources, an maximize your impact both online and off.
Ted is the founder of TGQ Marketing a PPC, Analytics and CRO agency focused on client results.