Google Ads Keyword Report Sample Dataset

Google Ads exports keyword performance reports from the Report Editor with exact production columns: Campaign, Ad group, Keyword, Match type, Clicks, Impressions, Cost, Conversions, and Conv. value. This dataset contains 4,800 synthetic keyword performance rows representing a mid-market PPC account. The Google Ads export quirk that silently destroys automated parsers is that the CSV file prepends two metadata rows before the actual header row: Row 1 contains the quoted report title (e.g., 'Keywords performance report') and Row 2 contains the date range string. When pandas reads the file with pd.read_csv() using default settings, it treats the report title as the header row, causing every column name to be wrong and all downstream df['Clicks'] references to throw KeyError. You must use skiprows=2 or programmatically detect and skip metadata rows. The structural dirty data inventory includes: the 2-row quoted metadata header that must be skipped, 1,120 rows with zero impressions and zero clicks, Cost values formatted with currency symbols, and 380 Keyword values containing special characters like + and [exact match] brackets. Expected Output: Yields 3,680 actionable keyword performance rows, 2 metadata rows skipped. Ideal for: ETL testing, DuckDB demos, Power BI, Excel Power Query, CI pipelines. Use the format-cleaner tool to automatically detect and strip the metadata header rows.