If you use the Quality Score Tracker from PPC Epiphany in multiple accounts or our modified version for MCC use, it would be nice to place the scores of all these accounts in one overview. That is why we use a Google Sheet ourselves with the average performance per month for all added accounts.

Quality Score Summary

How it works

Unfortunately, you will still have to do some work here yourself, not everything is automated. But it's not too bad. If you want to add an account to the sheet, use the following steps:

  1. Put the name of the account in column A.
  2. Open the Quality Score Tracker document 'Dashboard + Summary' for this customer. Copy the part of the URL between '/ spreadsheets / d /' and '/ edit'. Place this code in column B.
  3. Permission must be given to retrieve the score from this document. If all goes well, after adding the code in column B, an error message will be displayed in column C. Move your mouse over it. A small window appears with the error message and an 'Allow' button. Click this button and ...
  4. ... voilá: the account has been added to the overview.

Grab a copy of the sheet!

You can add as many accounts as you want. Just copy row 2 to include the existing formulas to a new row. And if you use this document for a longer period of time, you may have to extend the bar with months.

 

Sharing Knowledge

Adsscripts.com is all about sharing knowledge. In the current market, PPC specialists like to keep their knowledge and experience to themselves. We're convinced that sharing knowledge can ensure that everyone gets better at their work. We want to change this by sharing our knowledge about scripts with everyone.

Do you also want to contribute? We are open to new ideas and feedback on everything you find on Adsscripts.com.

Contact us

Nils Rooijmans
Google Ads Scripter
Water Cooler Topics
Nils Rooijmans, Google Ads Scripter
Bas Baudoin
Teamleader PPC
Happy Leads
Bas Baudoin, Teamleader PPC
Martijn Kraan
Freelance PPC Specialist
Brightstep
Martijn Kraan, Freelance PPC Specialist
Tibbe van Asten
PPC Specialist
Founder Adsscripts
Tibbe van Asten, Senior PPC Automation Specialist