The Sha3 member of the BZ Oilfield in Bohai Sea represents a typical ultra-low permeability thin interbedding reservoir. Hydraulic fracturing is an effective method for increasing oil and gas production. However, the complex geological conditions make it difficult to screen out the optimal frac spot. Consequently, the design of hydraulic fracturing exhibits certain limitations. A novel method for evaluating sweet spots is proposed, based on a refined geological reservoir model that considers the varying degrees of influence that geological and engineering factors have on fracturing effectiveness. This method utilizes grey correlation and hierarchical analysis to quantify and characterize the weight coefficients of each factor, ultimately leading to a combined weight coefficient approach. The results indicate that permeability and fracturing scale are the primary factors that impact the post-frac production of the BZ oilfield, with their respective combined weights being 0.33 and 0.25. The average weight for geological factors is 0.18, while for engineering factors it is 0.15. This suggests that geological factors have a greater influence on production than engineering factors. Furthermore, the correlation coefficient between the dual sweet spot index and the production is 0.96, indicating a strong positive correlation between the two variables. After comparing the predicted and actual production of each well, it was determined that the anastomosis rate is 80%. This finding holds significant guiding significance for selecting the optimal fracturing spot.