Maybe this will help where cell A1 is housing the URL;

=REGEXEXTRACT(A1,"_campaign=(.+)&utm_content")