Content Audit Summary (WP-CLI)

if ( ! defined( 'WP_CLI' ) || ! WP_CLI ) {
    return;
}

WP_CLI::add_command( 'content-audit', function ( $args, $assoc_args ) {
    global $wpdb;

    $stale_days = max( 1, (int) ( $assoc_args['stale-days'] ?? 730 ) );
    $cutoff     = gmdate( 'Y-m-d H:i:s', time() - $stale_days * DAY_IN_SECONDS );
    $items      = array();

    foreach ( get_post_types( array( 'public' => true ), 'objects' ) as $type ) {
        if ( 'attachment' === $type->name ) {
            continue;
        }
        $counts = wp_count_posts( $type->name );
        $row    = $wpdb->get_row( $wpdb->prepare(
            "SELECT
                SUM( t.meta_id IS NULL ) AS no_image,
                SUM( p.post_excerpt = '' ) AS no_excerpt,
                SUM( p.post_modified_gmt < %s ) AS stale
            FROM {$wpdb->posts} p
            LEFT JOIN {$wpdb->postmeta} t ON t.post_id = p.ID AND t.meta_key = '_thumbnail_id'
            WHERE p.post_type = %s AND p.post_status = 'publish'",
            $cutoff,
            $type->name
        ) );

        $items[] = array(
            'post_type'  => $type->name,
            'published'  => (int) $counts->publish,
            'drafts'     => (int) $counts->draft,
            'no_image'   => post_type_supports( $type->name, 'thumbnail' ) ? (int) $row->no_image : '-',
            'no_excerpt' => (int) $row->no_excerpt,
            'stale'      => (int) $row->stale,
        );
    }

    WP_CLI\Utils\format_items( $assoc_args['format'] ?? 'table', $items, array( 'post_type', 'published', 'drafts', 'no_image', 'no_excerpt', 'stale' ) );
}, array(
    'shortdesc' => 'Summarizes content health per post type.',
    'synopsis'  => array(
        array( 'type' => 'assoc', 'name' => 'stale-days', 'optional' => true, 'default' => 730 ),
        array( 'type' => 'assoc', 'name' => 'format', 'optional' => true, 'default' => 'table', 'options' => array( 'table', 'csv', 'json' ) ),
    ),
) );