Google Cloud SQL for PostgreSQL is a fully-managed database service that makes it easy to set up, maintain, manage, and administer your relational PostgreSQL databases in the cloud.
Autopilot is a visually-focused marketing software that provides tools for automating a customer’s journey. These include custom triggers that can be mapped out and automated ahead of time so that you can send the right kind of follow-up communications to the right customers. Autopilot can also automatically capture visitors, segment contacts using pre-established filters, and track the progress that a company is making towards a marketing goal. This allows users to make modifications that increase efficiency in real time.
Bring all your Autopilot data to Amazon Redshift
Load your Autopilot data to Google BigQuery
ETL all your Autopilot data to Snowflake
Move your Autopilot data to MySQL
Manage your contacts by updating, deleting, or retrieving contact data, including names, emails, phone numbers, the source of the lead and their affiliated company. With this information, you can more easily segment each contact into appropriate groupings that will make your marketing more targeted and effective.
Retrieve a list of existing smart segments, including the names and IDs for those segments. Then, gather data from a single smart segment to see relevant contact information, including how many contacts are grouped into that segment and who the first 100 contacts are. You will also get a bookmark link to the next batch of contacts, should there be more.
Get a list of Autopilot journeys that have API triggers, which includes their names and trigger IDs. Then, use that trigger to automatically add a contact to a journey via the contact’s ID or email address.