Skip to main content
New Introducing Mosaic Learn more

Amazon Redshift sync and AI SQL generation V2

Amazon Redshift sync and AI SQL generation V2

Amazon Redshift is now a warehouse source alongside Snowflake, BigQuery, Databricks, and ClickHouse. Connect it from Settings → Integrations with a dedicated IAM user, then write a query and pick the object to sync contacts, events, or your own custom objects on a schedule. Conversion reads through the Redshift Data API, so your cluster can stay private, with no public endpoint or IP allowlist. Both Serverless workgroups and provisioned clusters work.

AI SQL generation, V2

Conversion’s AI-to-SQL gets an upgrade, now built into the full-screen sync SQL editor for every warehouse. Describe the records you want to sync, and the query lands in your sync’s draft with a summary of what it does and notes such as “Every run reads all rows”. Undo restores your previous query, and nothing reaches the live sync until you publish the draft. The generator writes in the dialect of the warehouse you chose, including the incremental filter for scheduled syncs.

LinkedIn Ads: ad set tracking parameters

The LinkedIn Ads integration now covers ad set tracking parameters, so ad sets can be managed end to end from Conversion. Edit URL tracking parameters, with custom or dynamic values, in a table with a one-line URL preview. Pushing writes them to LinkedIn, and refresh reads back whatever was changed in Campaign Manager. Renaming a campaign, ad set, or ad that’s already live writes to LinkedIn first, so a name never drifts between the two.

Custom object trash

Deleting a custom object now moves it to the trash instead of refusing when it has records. Its records and fields are kept and reappear on restore, so an accidental delete is no longer a data loss.

Improvements

  • Agents Custom agents can search their own past sessions, the same way chats can search earlier conversations.
  • Agents Agents can list ads audiences and manage their additional members, the people uploaded only to an audience to reach a platform’s minimum size. Adds and removals ask for approval.
  • CRM Sync Timeline entries in Conversion Connect link to the email, form, or campaign in Conversion.
  • Automations Workflow nodes and email sends that hit a temporary error keep retrying for about six hours, up from about 77 minutes.

Fixes

  • Data Model Picklist options for fields whose values Conversion, Salesforce, or an event platform writes, such as Original Traffic Channel and Opportunity Stage, can no longer be edited by hand.
  • Admin Okta SSO setup no longer fails when the certificate you paste contains extra whitespace.
  • Campaigns Campaign members sync under their webinar or field event instead of being left unresolved.
  • Audiences The audience creator no longer disappears when you switch browser tabs.
  • Data Model A contact’s Company Name saves correctly, and the venue on a field event can be updated.
Read the docs