I'm stuck in the story line rn. I've done daisy's quest and I've done Cali's quest to the point you have to go to William's mansion but then it just says "your attempt to set a visit has failed" "you'll have to gain more renown". I can find any other main story quests. What am I missing?

You need to be elected Mayor.

how do I do that

If you're playing sandbox, it's likely it's not possible to get elected mayor, so that quest may not be doable.