Quick Tip: Avoid Waiting for Reports to Load

Anonymous
Not applicable

We all have some reports in Marketo that take a while to load. Many people will open them in a tab and just come back to them after lunch. I, however, am super impatient and when I want something, I want it right now. Plus I also have a bad short term memory and tend to forget what I was waiting on and only realize at the end of the day when I shut down and see this report in a random tab.

So here's a quick tip to get those complex reports fast:

  • Set up your report settings as you would normally but do not go to the Report tab to load the report.
  • Instead, click on Report Actions > Save As and give your report a name.
    pastedImage_2.png
  • Then when it refreshes, you'll see a new tab for Subscriptions. Click on New Report Subscription and set up a subscription for yourself. It's really irrelevant what settings you choose.
    pastedImage_3.png
  • Then click the little email icon next to your name. This will send you an email of the report as soon as it generates. pastedImage_4.png

Generally I find that this is faster than waiting for the report to load and it will also work in situations where you just can't get the report to load in the UI at all because of complex filters, etc.

4582
23
23 Comments
Grégoire_Miche2
Level 10

Thx Kristen, Nice one.

-Greg

Anonymous
Not applicable

You might have just made my life. 2016 complete.

Thank you!!!!

Anonymous
Not applicable

Hi Kristen,

Wondering if you have any tricks to speed up smart list loading. Whenever I have to pull a list of leads based on their inactivity (Not Clicked Link in Email, Not Visited Web Page, etc.), it takes quite a while and sometimes Marketo doesn't even cache it.

Regards,

Amanda

Anonymous
Not applicable

Hey Amanda,

Since we can subscribe to Smart Lists now, I bet you could replicate this same process for Smart Lists. Create the logic, and instead of clicking the "Leads" tab, go to List Actions > New Smart List Subscription > Subscribe (yourself) > and then click the email icon button to send it to yourself immediately.

Nina_Valtcheva5
Level 5

You are correct, Zach! Just tried this out and it works for Smart Lists as well. Very useful!!

Phillip_Wild
Level 10

One further thing on the speed to run reports - there's a great article in the Community about the order of your filters. I can't seem to find it right now, but long story short, use the simpler filters first (such as "is", "is not", "is empty" as opposed to "contains" and so forth), and the more complex ones later.

Marketo effectively narrows it down from the first filter down - so if your first filter is something like "Name is John Smith", and the second is "Did Not Open Any Email In Last 12 Months" it will be substantially quicker if you have the Name filter first. Marketo effectively says "Ok, I've got 12 John Smiths, let's run that complex criteria against ONLY 12 leads".

Phil

Anonymous
Not applicable

That is awesome to know Phillip - I'm going to write that into our team SOP from now on. Thanks man!

Phillip_Wild
Level 10

No problem! I'm sure Roxann McGlumphy​ can let us know where the full article is....Roxann, could you direct us to that blog you wrote about ordering filters and how this helps processing time?

Roxann_McGlump1
Community Manager

There used to be an article in the old community about optimizing Smart List performance but I didn't write it.  I don't think that old article is still around, but someone else wrote this, which covers pretty much the same information. Tips for Building Better Performing Smart Lists

Anonymous
Not applicable

This is awesome thanks Roxann!!