'seo_opportunities_grid', 'label' => 'Traffic × conversion grid', 'description' => '', 'source' => 'sql', 'sql' => $aieo_opp_sql, 'registry_id' => 'seo_opportunities.opportunities_content_opportunities', 'scope' => 'both', 'version' => '1', 'per_page' => 25, 'row_key' => 'object_id', 'default_sort' => array( 'priority', 'desc' ), 'empty_state' => 'Nothing scored yet. Press "Recompute now" — the grid builds from the analytics metrics the data-prep schedule produces, so it needs those to have run at least once.', 'filter_bar' => array( 'first' => array( 'quadrant', 'object_type', 'priority' ) ), 'capabilities' => array( 'edit' => 'aieo_report_edit', ), 'actions' => array( array( 'id' => 'pin', 'label' => 'Pin as pillar', 'when' => array( 'key' => 'pin_state', 'is' => 'pinnable' ), 'data' => array( 'otype' => 'object_type' ), ), array( 'id' => 'unpin', 'label' => '★ Pinned', 'variant' => 'primary', 'when' => array( 'key' => 'pin_state', 'is' => 'pinned' ), 'data' => array( 'otype' => 'object_type' ), ), array( 'id' => 'suggest', 'label' => 'Suggest keyphrase', 'variant' => 'ghost', 'data' => array( 'otype' => 'object_type' ), ), ), 'columns' => array( array( 'key' => 'object_id', 'label' => 'Content', 'type' => 'object', 'subline' => 'object_type', 'sortable' => true, 'sort_key' => 'post_title', 'truncate' => 55, 'tooltip' => true, ), array( 'key' => 'post_title', 'label' => 'Title', 'type' => 'text', 'searchable' => true, 'hidden' => true, ), array( 'key' => 'object_type', 'label' => 'Type', 'type' => 'badge', 'width' => '110px', 'sortable' => true, 'filter' => 'select', 'hidden' => true, ), array( 'key' => 'quadrant', 'label' => 'Quadrant', 'type' => 'badge', 'width' => '150px', 'sortable' => true, 'filter' => 'select', 'format' => array( 'labels' => array( 'hidden_gem' => 'Hidden gem', 'intent_mismatch' => 'Intent mismatch', 'defend' => 'Defend', 'prune' => 'Prune', ), 'map' => array( 'hidden_gem' => 'success', 'intent_mismatch' => 'warning', 'defend' => 'info', 'prune' => 'danger', ), ), ), array( 'key' => 'traffic_score', 'label' => 'Traffic', 'type' => 'bar', 'width' => '120px', 'sortable' => true, 'filter' => 'number_range', 'format' => array( 'max' => 100 ), ), array( 'key' => 'conversion_score', 'label' => 'Conversion', 'type' => 'bar', 'width' => '120px', 'sortable' => true, 'filter' => 'number_range', 'format' => array( 'max' => 100 ), ), array( 'key' => 'cornerstone_score', 'label' => 'Cornerstone', 'type' => 'integer', 'width' => '110px', 'sortable' => true, 'filter' => 'number_range', ), array( 'key' => 'priority', 'label' => 'Priority', 'type' => 'integer', 'width' => '90px', 'sortable' => true, 'filter' => 'number_range', ), array( 'key' => 'recommendation', 'label' => 'What to do', 'type' => 'text', 'sortable' => false, 'truncate' => 90, 'tooltip' => true, 'empty' => '', ), array( 'key' => 'focus_keyphrase', 'label' => 'Focus keyphrase', 'type' => 'editable', 'width' => '190px', 'sortable' => true, 'filter' => 'text', 'editable' => true, ), array( 'key' => 'sitemap_priority', 'label' => 'Sitemap priority', 'type' => 'editable', 'width' => '130px', 'sortable' => true, 'editable' => true, 'format' => array( 'as' => 'number' ), 'header_tip' => 'Between 0.0 and 1.0. Raising it tells search engines this page matters more than its siblings; it is a hint, never a promise.', ), array( 'key' => 'is_pillar', 'label' => 'Pillar', 'type' => 'boolean', 'width' => '70px', 'align' => 'center', 'sortable' => true, 'filter' => 'select', ), array( 'key' => 'pin_state', 'label' => 'Pin state', 'type' => 'text', 'select' => "''", 'hidden' => true, ), array( 'key' => 'updated_at', 'label' => 'Scored', 'type' => 'datetime', 'width' => '140px', 'nowrap' => true, 'tone' => 'secondary', 'sortable' => true, 'format' => array( 'tz' => 'utc' ), 'hidden' => true, ), ), );