Create a report to show accounts with no media campaigns in the last 90 days

Question

Hello everyone,

Hoping to get some help with a tricky report that I'm trying to create.

What I'm hoping to achieve is a report that will list out all of the accounts that have no media campaigns created in the last 90 days, with the caveat that the account must have had a previous media campaign at some point in its lifetime.

I've tried various report types and even looked at creating a custom report type but just can't seem to get it to do what I intend.

Any help would be hugely appreciated.

Thanks,

Curt

Curt Greveson · Answer

Hi Ines,

Thanks for your response.

We use ADvendio to create all of our records.

I'm not sure if Media Campaign goes further than the standard salesforce functionality, but assumed it would be a core functionality.

Once we create a campaign, we can view that from the Account details page for each customer.

Apologies if the above doesn't help you understand my query any better.

Thanks

Curt

Create a report to show accounts with no media campaigns in the last 90 days

Reports & Dashboards

Aprendizaje relacionado

Más ayuda