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.
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:
Put the name of the account in column A.
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.
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 ...
... voilá: the account has been added to the overview.
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.
Tibbe van AstenHead of PPC @ Increase
Nils RooijmansWater Cooler Topics
Martijn KraanFreelance PPC Specialist
Bas BaudoinTeamlead SEA @ Happy Leads
How about you?JOIN US!
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.