Query: List all archived blog posts

Description

Discover the segments that contain all your archived blog posts. This aids in understanding the range and history of content that is no longer actively promoted but may still hold value.

Query

Tables used in this query:

• hubspot_blog_post

SQL