Flexoelectricity is a universal property of all dielectrics, by which they generate a voltage in response to an inhomogeneous deformation. One of the controversial issues in this field concerns the magnitude of flexoelectric coefficients measured experimentally, which greatly exceed theoretical estimates. Furthermore, there is a broad scatter amongst experimental measurements. The truncated pyramid compression method is one of the common setups to quantify flexoelectricity, the interpretation of which relies on simplified analytical equations to estimate strain gradients. However, the deformation fields in 3D pyramid configurations are highly complex, particularly around its edges. In the present work, using three-dimensional self-consistent simulations of flexoelectricity, we show that the simplified analytical estimations of strain gradients in compressed pyramids significantly overestimate flexoelectric coefficients, thus providing a possible explanation to reconcile different estimates. In fact, the interpretation of pyramid compression experiments is highly nontrivial. We systematically characterize the magnitude of this overestimation, of over one order of magnitude, as a function of the truncated pyramid configuration. These results are important to properly characterize flexoelectricity, and provide design guidelines for effective electromechanical transducers exploiting flexoelectricity.