Tabular Reports in Journey Orchestrator

  • 7
  • Article
  • Updated 3 weeks ago
Hi All,

One of the frequently asked feature in Journey Orchestrator has been the need for sending tabular reports in emails.

We are looking at addressing that use case using the following approach - 

a. You will be able to use any of the tabular reports configured as part of email configuration.
b. You will have two options-  CSV/Inline Option for sending a tabular report.
    - CSV option is aimed at use cases where there are many rows and columns and the data is of high volume.
    - Inline Option is aimed at use cases where the data you want to share are simple tabular reports in email with very few rows and columns.
c. For inline option, a maximum of 5 columns and 20 rows will be allowed in tabular reports.If the report exceeds this limit , then the report will be sent as CSV to the recipient. 

We are looking for feedback on the above proposal and guide us with respect to whether the above approach will meet the use case of  tabular reports. Are there any other use cases which you felt we have missed?

As we are in the early stages of this design, things might become flexible in the future based on other considerations or use cases. :) 

Abhishek S
Photo of Abhishek Sivaraman

Abhishek Sivaraman, Senior Product Manager

  • 9,028 Points 5k badge 2x thumb
  • Confident

Posted 1 month ago

  • 7
Photo of Heather Hansen

Heather Hansen, Champion

  • 9,254 Points 5k badge 2x thumb
That sounds great to me.  This would work for most of my use cases.
Photo of Sagan Sherlin

Sagan Sherlin, Champion

  • 4,344 Points 4k badge 2x thumb
+ a Million.  This would be awesome, and amazing!  I can't like this post enough!  I was actually reading the other post (2 pages, WOW) and saw your post Abhishek and about screamed in my office.

Our executives enter in a weekly Timeline entry that we've created a Dashboard for.  But because the posts and can be rather long at times - they have to export.  With the new proposed feature - we could automate that report instead - which would be a huge win!

I agree with the size limit - what you proposed works much like when exporting an Excel items from Reporting.  If small enough - it will open right for you.  But large enough - and it's emailed to you.  Consistency :)

But to also be able to have the ability to NOT have to have linked to Account, would be awesome.  For the example, the people that would receive the excel report of the executive - may not have posted or be tied to an account.  It would be internal only.

Photo of Karl Rumelhart

Karl Rumelhart, Official Rep

  • 10,242 Points 10k badge 2x thumb
Thanks for the use case.  One perspective I have (but feel free to disagree) is that the user experience of Timeline data in a tabular report is pretty poor.  While it is nice to be able to export and share it, getting a big CSV with lots of text in it is painful.  One of the motivations for building the Global Timeline is to provide a good consumption experience for Timeline data across Customers.  At the moment, the filters on Global Timeline aren't good enough -- can't filter by Company attributes, for example.  Suppose we had those filters -- and suppose we could be a filtered global Timeline on a dashboard.  Would that be a better way to address this use case?   An alternative could be to put effort into making working with text in a tabular report better.  Thanks.

Photo of Bryan Zwahlen

Bryan Zwahlen

  • 66 Points
Works for our use case.
Photo of Liam Nicholls

Liam Nicholls

  • 248 Points 100 badge 2x thumb
Works for our use too.

In particular I don't mind the CSV report, I've had to build scheduled reports from SFDC in some cases, and would prefer not to have to do that