How can I get a report on draft and unpublished content?

Hi Christopher G. Stanton 

I looked into this one - short answer is no, Reporting doesn't have anything for this today. None of the built-in reports (Content, Active Content, Viewed Content, the Blog/Wiki Details reports, etc.) break things out by draft or unpublished status, they're all scoped to published content.

REST API gets you partway there, but there's a distinction worth knowing: List Blog Post has an IncludeUnpublished parameter, but that only catches posts that were published and then later unpublished - it won't show you posts still sitting in draft. There's no IsDraft flag exposed anywhere for blog posts, so drafts really aren't queryable via API right now. Wikis are a little better off - List Wiki Page does return an IsPublished field per page, it's just not something you can filter by in the request, so you'd have to pull all pages and filter on your end.

So bottom line, there's no clean way to get a full drafts + unpublished view across all authors today. I'd throw this in as an Ideation request since it seems like a reasonable ask (even just an IsDraft filter on the Blog Post/Wiki Page endpoints would go a long way), and in the meantime it might be worth asking your CSM if this is something the data warehouse/BI reporting can get at, since the public API can't fully answer it yet.

Happy to help think through the idea submission if that's useful!

Hi Christopher G. Stanton 

I looked into this one - short answer is no, Reporting doesn't have anything for this today. None of the built-in reports (Content, Active Content, Viewed Content, the Blog/Wiki Details reports, etc.) break things out by draft or unpublished status, they're all scoped to published content.

REST API gets you partway there, but there's a distinction worth knowing: List Blog Post has an IncludeUnpublished parameter, but that only catches posts that were published and then later unpublished - it won't show you posts still sitting in draft. There's no IsDraft flag exposed anywhere for blog posts, so drafts really aren't queryable via API right now. Wikis are a little better off - List Wiki Page does return an IsPublished field per page, it's just not something you can filter by in the request, so you'd have to pull all pages and filter on your end.

So bottom line, there's no clean way to get a full drafts + unpublished view across all authors today. I'd throw this in as an Ideation request since it seems like a reasonable ask (even just an IsDraft filter on the Blog Post/Wiki Page endpoints would go a long way), and in the meantime it might be worth asking your CSM if this is something the data warehouse/BI reporting can get at, since the public API can't fully answer it yet.

Happy to help think through the idea submission if that's useful!

Sara Collins said:

and in the meantime it might be worth asking your CSM if this is something the data warehouse/BI reporting can get at,

We're on prem, not in the cloud, so I imagine we'd have to self-serve this.

Sara Collins said:

REST API gets you partway there, but there's a distinction worth knowing: List Blog Post has an IncludeUnpublished parameter, but that only catches posts that were published and then later unpublished - it won't show you posts still sitting in draft. There's no IsDraft flag exposed anywhere for blog posts, so drafts really aren't queryable via API right now. Wikis are a little better off - List Wiki Page does return an IsPublished field per page, it's just not something you can filter by in the request, so you'd have to pull all pages and filter on your end.

If only content in the 'draft' status also had the 'unpublished' status that sounds like a suitable patch, and then reporting adapted to suit. Sigh.