Mailchimp URL from Email not available
I am looking to pull into Sheets the URLs used in Emails (via Mailchimp).
These URLs are stored in Mailchimp under the alias "URL".
I've combed through the available metrics and dimensions and cannot find what I need. I would want to break these out by Campaign ID. Is this possible? Am I missing the field in the list somewhere?