I don't know if the above information was enough to go off of so I wrote it in a different way to hopefully give you all a better idea of what I'm trying to accomplish.

First off thanks for trying to help me.

What I’m trying to do is pull some data into DB (Database) Sheets and have it automatically calculate the following (Ad Spend, Impressions, Clicks, Conversions, and Revenue) based on if its [Brand] or [Non-Brand] for the respective types i.e. Google Search, Microsoft Search, Google Shopping, etc.
First off, I would like to know if it is possible? Secondly, if possible, how would I accomplish this? Lastly, could I do this based on increments such as 7, 30, 90, 365 days?

Again, thank you for your help with this project.

https://docs.google.com/spreadsheets...it?usp=sharing