How to calculate Price Genius uplifts with data taken directly from GAM?

Last edited: 2025/04/08

We are encouraging our clients to double-check the results of PriceGenius on their own, anytime they want to. In order to make this process as simple as possible, we are helping with setting up the right GAM queries, and we have prepared an Excel template where your only job is to copy and paste the outcome of the GAM queries.

Hence if you want to double check the uplift using data taken directly from your GAM you need to:

1. Reach out to your Customer Success Manager and ask for GAM querries necessary for uplift checkup
2. Download this excel file:

Uplift check-up using GAM querries - Excel template.xlsx

<aside> <img src="/icons/info-alternate_blue.svg" alt="/icons/info-alternate_blue.svg" width="40px" /> Note that:

• You need to have Microsoft Excel in order to be able to run the file.
• If you have trouble running the calculations, try saving the file in a .xlsb format - it generally calculates formulas much faster. </aside>

1. Run the querries prepared by Yieldbird team (point 1) and copy and paste their contents according to the instructions in the Excel template.

<aside> <img src="/icons/info-alternate_blue.svg" alt="/icons/info-alternate_blue.svg" width="40px" />

See also:

• Why there are data discrepancies GAM vs Price Genius dashboard?
• Why do you have to sum uplift revenue to calculate uplift? </aside>