A transition magnetic moment between active and sterile neutrinos can induce the Primakoff upscattering process at the coherent elastic neutrino nucleus scattering experiments, leading to very stringent limits on the transition dipole coupling as a function of the sterile neutrino mass. Here we discuss how a novel radiative upscattering mode with an additional photon emitted in the final state can lead to exploration of new parameter space in the transition dipole coupling vs. sterile neutrino mass plane and provide distinguishable differential distributions for a Dirac vs Majorana sterile state mediating such a mode