Google Sheet Calculation based on a Database of Information

All,

I hope this is alright.

I am newer to Google Sheets than I am to Excel. I'm looking to see if anyone can help me figure out how to make this sheet work for what I'm trying to accomplish. Hopefully, I explain myself well enough for you all.


Problem Set: I Want to figure out information in the red-colored cells off the DBs at the bottom. I want to break it out based on Brand and Non-Brand Campaigns.

Each Campaign is labeled ([Customer] [Google Search] [Non-Brand] [Manufacturer]) or something similar. Based on [Non-Brand] or [Brand] I want to count the number of impressions, clicks, conversions, cost, and so on.


Also, I would like to have a weekly, monthly, quarterly, & yearly report based on the numbers. I know this is going to be difficult unless I pull the data differently than just an all-time report.


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

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

Hi Akeller10,

I did a few calculations in the Analysis Table sheet for Google Search, Microsoft Search and Google Shopping campaigns to help get you started (if, of course, this is what you're after). Not sure what columns make up the Revenue column.

Lastly, could I do this based on increments such as 7, 30, 90, 365 days?

I don't see any dates on any of the sheets. Maybe you could give an example of what you mean.