Title:Unlocking AGN Variability with Custom ZTF Photometry for High-Fidelity Light Curves and Robust Selection

Abstract:(Abridged)We explore the potential of optical variability selection methods to identify AGN, including those challenging to detect with conventional techniques. Using the unprecedented combination of depth, sky coverage, and cadence of the ZTF survey, we target even starlight-dominated AGN, known for their redder colours, weaker variability signals, and difficult nuclear photometry due to their resolved hosts. We perform aperture photometry on ZTF reference-subtracted images for 40 million sources across 8,000 deg^2, assemble light curves and classify objects employing an RF algorithm into 14 classes, including 341,938 candidate AGN. We compare variability metrics derived from our photometry to those obtained from ZTF Data Release light curves (DR11-psf), to assess the impact of our analysis. We find that the fraction of low-z quiescent galaxies exhibiting significant variability drops dramatically (from 98\% of the sample to 7\%) when replacing the DR11-psf light curves with our difference image, aperture photometry (DI-Ap) version. The overall number of variable low-z AGN remains high (99\% when using DR11-psf lightcurves, 83\% when using DI-Ap), however, implying that our photometry can detect the fainter variability in host dominated AGN. The classifier effectively distinguishes between AGN and other sources, demonstrating high recovery rates even for AGN in resolved nearby galaxies. AGN candidates in eROSITA's eFEDS field, detected in X-rays and bright enough for ZTF optical observations, were classified as AGN (79\%) and non-variable galaxies (20\%). These groups show a 2 dex difference in X-ray luminosity but not in X-ray flux. A significant fraction of X-ray AGN are optically too faint for ZTF, and conversely, a quarter of ZTF AGN in the eFEDS area lack X-ray detections, highlighting a wide range of X-ray-to-optical flux ratios in AGN.