So here we are on part 11 of the Google Ads Audit tutorial with a focus on Age Analysis.
We'll use the Data Studio report to assist in grabbing concise visuals and we'll utilize Google Sheets/Excel and Google Slides to help analyze the data. The information gathered from this section can be used for bid adjustments, as well as excluding or changing your campaign offers.
1. Head to the Overview report in Data Studio under the Age section. Make sure the date range is correct. I set this one for 14 days.
2. Screenshot, copy and paste the data chart into the Analysis report.
3. Export the Age Overview report to Google Sheets.
4. Tap into the Ads Account Maintenance Checklist and hit Age Bidding.
5. Pick a bid modifier and pick the level.
6. To double check this, go into Google Ads Editor since this is where it will be uploaded. Click Ages, then Bid Adjustment. 'Modifier' is changed into Bid Adjustment.
7. Go back to the Age Report chart and sort it by cost.
Looking at the click-through-rate (CTR), these are fairly expensive. I’ll do some small bid adjustments like -5 percent on anything that’s spent over $20. It hasn’t converted yet.
8. Copy the data, go to Google Ads Editor and click Multiple Changes. Then Paste from Clipboard. It lists the Campaign, ad group along with age is listed along with other features.
9. Hit Process, then Finish and Review Changes.
10. Click Keep, then Post to All Campaigns. Close this tab.
11. Go back to the Google Spreadsheet and share and link this to the Analysis report.
12. Under Analysis, I made note that “Undetermined has a majority of spend” and “Performed bid adjustments on this possible exclusion.”
The Age Analysis is complete in our Google Ads Audit.
Part 12 of this tutorial will take us through the Hour Analysis.
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.