I'm trying to create a report that allows me to see closed won opportunities from the current fiscal year, but only from accounts created prior to this year and created from a Google Ads campaign (this is a linked field passed along from Pardot).
We have a custom report type of "Accounts & Contacts with Opportunities & Quotes" that gives me access to all the fields I need to filter by, but my report only returns the total closed/won for the entire account and won't return just the current year's revenue.
Is this caused by the report type being based on the account object with opportunities being included? Should it be opportunities with the account object being included?
It doesn't appear that an accounts report or an opportunities report gives me access to all the fields I need.
I don't have admin access to create new report types. I'm sure I can have the admin do it on Monday if that is the route I need to take.
How do I create this report?