Under the Feature controls tab, you can manage the General feature control for DataPrep and Open AI Integration.
General
General feature controls for Zoho DataPrep allows you to retain raw and prepared data for the last 6 months.
OpenAI Integration with Zoho DataPrep
Open AI integration with Zoho DataPrep helps you enrich your data with advanced AI-based features using ChatGPT, a generative artificial intelligence developed by OpenAI.
OpenAI in Zoho DataPrep works in a BYOK (Bring Your Own Key) model, in which users bring their own ChatGPT API Key and OpenAI Organization ID. If you are already an OpenAI user, you can use your API key and organization ID to unlock AI features in DataPrep.
Here's a quick video on ChatGPT integration with Zoho DataPrep.
Data Privacy Notice : Zoho DataPrep utilizes OpenAI's ChatGPT API, an external service based in the USA, subject to OpenAI's Terms of Use . Please be aware that the information sent to OpenAI depends on the access provided by you, the user. The data shared with ChatGPT is based on the features you enable. Details such as column names and/or selected cell data will be shared based on each feature. You can choose to enable or disable each feature based on the level of data you want to share. Therefore, exercise caution while using this service and ensure that the data you provide does not contain confidential or personal information.
Notes:
The generative response are coming in from ChatGPT's training data. Accuracy, consistency, and relevance of the response are subjective to the type of prompts and the data available in its training set.
ChatGPT doesn't respond to prompts about personal information.
Here's a short demo that illustrates the various features in Zoho DataPrep powered by OpenAI's ChatGPT integration.
To configure and enable OpenAI's ChatGPT integration
1. Go to the OpenAI Integration tab in the Settings page by clicking the settings icon at the top-right corner in the top bar.
Note: The OpenAI configuration in DataPrep's Settings page will be visible to only the Account admin.
The features can enabled for your DataPrep organization only by the Account admin.
2. Provide the Organization ID and API Key of your OpenAI organization to configure OpenAI integration in your DataPrep organization.
3. Click the Save button. Consent popup will be shown. Please read the data privacy notice carefully before you proceed. By proceeding, you acknowledge and accept the risks, and OpenAI's terms of use policy.
4. Once saved, you can choose to enable the OpenAI's ChatGPT features you want.
5. After enabling the features, you will be able to use them in your DataPrep organization.
You can find the External dataset finder feature while importing data using the +Add dataset button.
You can find the Formula suggester feature in the "Add formula" transform available in the Transform menu in the DataPrep studio page.
You can find the Transform by example feature in the right-click menu of your data column.
You can find the Prepare data using Ask Zia feature from the top right corner of the Studio page.
Notes:
1. The ChatGPT powered features, when enabled can be used by the Account admin and the Organization admins in your DataPrep organization.
2. The API key entered is specific to the particular organization that it is configured in. If you are a part of multiple Zoho DataPrep organizations, the API key still won't be shared across organizations.
3. The API key entered is specific to Zoho DataPrep, and will not be shared with any other Zoho service.
Organization ID and API key in OpenAI
1. Go to your settings page in Open AI to get the Organization name and ID. Here's a snapshot for reference. Read more from OpenAI
2. Go to the API keys tab under the Organization section to get your API Key. Here's a snapshot for reference. Read more from OpenAI
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
Install the PageSense code snippet on your site in a matter of minutes and start collecting in-depth data about the website visitors to grow your business.
Set up goals in PageSense to measure every single action performed by visitors on your website like button or link clicks, form submissions, and page engagements.
Create funnels in PageSense to quickly see which pages visitors use to enter your website, where they navigate to next, and which pages they decide to leave without converting.
Visualize your visitor's behavior with color codes
Set up heatmaps in PageSense to see where users have clicked more, how far they've scrolled, and on which parts of a page they've spent the most time using color-coded patterns in reports.
Use form analytics in PageSense to see how people interact with different fields in your form, whether they complete the form successfully or not, and where exactly they drop out on your form.
Use session recordings in PageSense to watch a video of all the visitor actions performed on your website including the pages they navigate, the buttons they click, the UX issues they face, and more.
Run A/B or Split URL tests in PageSense to figure out which version of your web page works best for your business and results in the best conversion rate.
Use personalization in PageSense to deliver customized versions of your website for every individual customer based on their demographics, local weather, browsing history, and more.
Run polls on your website using PageSense to understand what your customers think about your products/services and what needs improvement on your site.
Use web push notifications in PageSense to schedule and notify your customers about an upcoming flash sale, product releases, promotional coupons, and a lot more that can spark conversions on your website.
Use pop-ups in PageSense to instantly grab the attention of visitors by showing attractive signup offers, coupon code discounts, or email newsletters that can eventually convert them into subscribers.
Use PageSense's advanced features like creating mutually exclusive groups, enabling cross-domain tracking, configuring customized project JS, and more to get deeper insights about your website.
Download the PageSense extension app available for your web browser with a few clicks and start collecting all of your required website metrics in real time.
Discover your favorite integrations with PageSense
Get a deeper look at your website's data by seamlessly integrating PageSense with a host of popular third-party apps like Google Analytics, Mixpanel, Intercom, and more.
You can manage the settings of your organization, subscription and preference to data propagation under the Organization tab in the Settings page. Manage subscription In the Manage subscription tab, you can review your current plan, the number of ...
Zoho DataPrep allows you to manage all user activities and user access in your organization using the Audit tab under the Compliance tab in the Settings page. You can also export and download these audit logs. DataPrep provides you with the below ...
Zoho DataPrep helps you clean and transform your data based on prompts to Ask Zia in Natural Language. Using this feature, you can enter the required prompt, and the rest of the output will be auto-generated for you by Zia. The Ask Zia feature is ...
List of other languages supported and steps to switch to a different language Zoho DataPrep is available in the following languages. Arabic [ar] Chinese[zh] Dutch[nl] English [en] French[fr] German[de] Hungarian[hu] Italian[it] Japanese[ja] ...
In the Settings page, select Databridges from the side panel to manage the linked databridges. If you have added Databridges already, you can view details such as: The name of the Databridge, the host server, and the OS it runs on. Status of the ...