Subjective cognitive decline (SCD) and amnestic mild cognitive impairment (aMCI) are considered as the spectrum of preclinical Alzheimer's disease (AD), with abnormal brain network connectivity as the main neuroimaging feature. Repetitive transcranial magnetic stimulation (rTMS) has been proven to be an effective non-invasive technique for addressing neuropsychiatric disorders. This study aims to explore the potential of targeted rTMS to regulate effective connectivity within the default mode network (DMN) and the executive control network (CEN), thereby improving cognitive function. This study included 86 healthy controls (HCs), 72 SCDs, and 86 aMCIs. Among them, 10 SCDs and 11 aMCIs received a 2-week rTMS course of 5-day, once-daily. Cross-sectional analysis with the spectral dynamic causal model (spDCM) was used to analyze the DMN and CEN effective connectivity patterns of the three groups. Afterwards, longitudinal analysis was conducted on the changes in effective connectivity patterns and cognitive function before and after rTMS for SCD and aMCI, and the correlation between them was analyzed. Cross-sectional analysis showed different effective connectivity patterns in the DMN and CEN among the three groups. Longitudinal analysis showed that the effective connectivity pattern of the SCD had changed, accompanied by improvements in episodic memory. Correlation analysis indicated a negative relationship between effective connectivity from the left angular gyrus (ANG) to the anterior cingulate gyrus and the ANG.R to the right middle frontal gyrus, with visuospatial and executive function, respectively. In patients with aMCI, episodic memory and executive function improved, while the effective connectivity pattern remained unchanged. This study demonstrates that PCUN-targeted rTMS in SCD regulates the abnormal effective connectivity patterns in DMN and CEN, thereby improving cognition function. Conversely, in aMCI, the mechanism of improvement may differ. Our findings further suggest that rTMS is more effective in preventing or delaying disease progression in the earlier stages of the AD spectrum. http://www.chictr.org.cn, ChiCTR2000034533.