```json { "queries": [ { "query": "SELECT * FROM callyeah_analytics_2026_07_23 WHERE \"CallYeah — Analytics Export\" IS NOT NULL LIMIT 20", "description": "Preview first 20 rows with non-null primary column values." }, { "query": "SELECT COUNT(*) AS total_rows, COUNT(\"CallYeah — Analytics Export\") AS non_null_primary FROM callyeah_analytics_2026_07_23", "description": "Total row count and non-null values in the primary column." }, { "query": "SELECT \"CallYeah — Analytics Export\", \"Unnamed: 1\", \"Unnamed: 2\" FROM callyeah_analytics_2026_07_23 WHERE \"Unnamed: 1\" IS NOT NULL LIMIT 15", "description": "First three columns for rows with data in the second column." }, { "query": "SELECT COUNT(DISTINCT \"CallYeah — Analytics Export\") AS unique_values FROM callyeah_analytics_2026_07_23 WHERE \"CallYeah — Analytics Export\" IS NOT NULL", "description": "Count of unique non-null values in the primary analytics column." }, { "query": "SELECT * FROM callyeah_analytics_2026_07_23 WHERE \"Unnamed: 3\" IS NOT NULL AND \"Unnamed: 4\" IS NOT NULL LIMIT 10", "description": "Rows where both the fourth and fifth columns contain data." }, { "query": "SELECT \"CallYeah — Analytics Export\", COUNT(*) AS occurrences FROM callyeah_analytics_2026_07_23 WHERE \"CallYeah — Analytics Export\" IS NOT NULL GROUP BY 1 ORDER BY 2 DESC LIMIT 10", "description": "Most frequently occurring values in the primary analytics column." }, { "query": "SELECT * FROM callyeah_analytics_2026_07_23 WHERE \"Unnamed: 5\" IS NOT NULL OR \"Unnamed: 6\" IS NOT NULL LIMIT 15", "description": "Rows with data in either the sixth or seventh column." }, { "query": "SELECT COUNT(*) AS rows_with_data FROM callyeah_analytics_2026_07_23 WHERE \"Unnamed: 7\" IS NOT NULL OR \"Unnamed: 8\" IS NOT NULL OR \"Unnamed: 9\" IS NOT NULL", "description": "Count of rows containing data in the last three columns." } ] } ```