Hi Himanshu,

Thank you for your feature request. I've looked into both of these and confirmed they are available through the Google Ads API v23.

The Final URL Expansion status is available at the campaign level via the campaign.asset_automation_settings field. Each entry includes an asset_automation_type and asset_automation_status (OPTED_IN or OPTED_OUT). The FINAL_URL_EXPANSION_TEXT_ASSET_AUTOMATION entry indicates whether Final URL Expansion is enabled for a given campaign. The connector can be updated to expose this on the CAMPAIGN table.

Search themes for Performance Max campaigns are available via the asset_group_signal resource (field: asset_group_signal.search_theme.text). The connector can be updated to sync a new ASSET_GROUP_SIGNAL table.

I've created an internal feature improvement ticket to add both of these to the Fivetran Google Ads connector. While we can't provide a specific timeline, your request has been logged and will be considered in our prioritization process. Any additional upvotes from other Fivetran customers for this data will help increase the releative priority in our backlog. 

We'll follow up on this thread when we have an update. Thank you for helping us improve the Google Ads connector.

Cheers,
Luke