[Bug] Linkedin Ads URL not showing up due to API changes

### Is there an existing issue for this?

- [X] I have searched the existing issues

### Describe the issue

I am using the dbt `ad_reporting` package and while testing I noticed the `ad_reporting__url_report` has no data for LinkedIn. Looking at the underlying models - the URL value is being pulled and parsed from the `creative_history.click_uri` value which doesn't appear to exist in our connector.

I reached out to support and they told me that there was an API change:

> Your click_uri should now be spotlight_landing_page and text_ad_landing_page in the CREATIVE_HISTORY table based on the [LinkedIn API Creative migration](https://learn.microsoft.com/en-us/linkedin/marketing/community-management/contentapi-migration-guide?view=li-lms-2024-05#adcreativesv2-api-creatives-api).

This would mean the models starting from the source model: https://github.com/fivetran/dbt_linkedin_source/blob/main/models/stg_linkedin_ads__creative_history.sql and all that rely on it would need to be updated to ensure the URL is being passed to the final ad_report model.

### Relevant error log or model output

_No response_

### Expected behavior

The dbt package uses the updated fields to support the final URL report.

### dbt Project configurations

NA

### Package versions

- package: fivetran/ad_reporting
version: 1.7.1

### What database are you using dbt with?

snowflake

### dbt Version

latest version

### Additional Context

_No response_

### Are you willing to open a PR to help address this issue?

- [ ] Yes.
- [ ] Yes, but I will need assistance and will schedule time during our [office hours](https://calendly.com/fivetran-solutions-team/fivetran-solutions-team-office-hours) for guidance
- [X] No.