How to use AI features with custom fields

We've introduced an AI functionality into our custom fields. With this feature, you can do custom prompt engineering based on whatever field or custom field you have available. Use this feature to get creative and leverage the power of AI to automate simple analysis, especially correlation analysis.

This feature is currently in open beta. You can try out this feature, but be aware that we're still working on some details.

You can use this feature for many use cases, for example: 

• US national holiday correlation analysis: Provide a specific date from the 'date' column, and ask the AI to check if the date was a US national holiday. With this information, you can correlate the 'spend' and 'revenue' for that specific date with the AI's response to determine if there was any significant impact on marketing metrics due to the holiday.
• Extract a particular part of a text dimension without knowing Regex: Describe in human language what part of a text — a campaign name for example — you want to extract. For example, ask the AI to "extract the value in between parentheses" or "extract the last part of the campaign, where each part is separated by an underscore". Supermetrics will create a new dimension based on these rules.
• Advertising guideline check: Provide a specific ad copy element (such as a headline, a body, or a call to action). Ask Open AI the following: "Our advertising must follow these guidelines: xxxxx. Does this ad copy follow the guidelines?" Based on the recommendations given by the AI, you can adapt your ad copy.
• Understand different sources of traffic: Provide a traffic source dimension (such as Session source from Google Analytics 4), and ask the AI to describe the traffic source in 10 words. The result gives you a quick understanding on where your website visitors are coming from without having to do laborious research yourself.
• Social media sentiment analysis: Provide a content field (such as Post message or Comment from Facebook Insights), and ask the AI what the sentiment of the post is. With this, you can get a quick understanding of the sentiment of your community for each piece of content.
• Translate the report: Provide a content field that needs to be translated, such as a post message or comment, and a target language to translate to. Use this feature to get reports on different text-based content from multiple languages translated into one.
• Analyze images with AI: Enrich your data with AI insights from images by performing image analysis, such as image descriptions, image sentiment, or text, logo, or landmark recognition. This can help you when analyzing ad performance by creative or benchmarking competition on public media.

Instructions

1. On the Supermetrics Hub , go to Transform → Custom fields.
2. Click New custom field.
3. Select either dimension or metric and click Next.
   This selection is based on the aspect of the data you aim to manipulate.
4. Select the data source you want to apply a transformation to and click Next.
5. Select Function as your transformation type.
   This selection enables you to manipulate your selected data using a variety of mathematical or textual operations.
6. In the Select function field, select Transform with AI, Translate, or Sentiment analysis, depending on the task you want AI to do.
   For image analysis, select an option from the AI image analysis section. Note that the AI image analysis requires the input value to be an image URL field.
7. Select the field you want to transform in the Input value field.
8. Write your AI prompt in the Prompt field.
9. After configuring your function, click Next.
10. Give a name for your custom field.
11. Click Create custom field.

Usage limits

Prompt length limit

A prompt is the combined value of the prompt defined by the user in the custom field definition, and the value to be transformed. With AI, the prompt can be a maximum of 1,500 characters long.

For example, for a custom field using "Transform with AI" prompt with prompt "Is this a public holiday in the US", the value sent to the AI is the customer prompt + the actual value in the report (here a date), such as "Is this a public holiday in the US 2024-01-01". In this case, the character count is 45.

For a custom field without a prompt in the editor (such as "Translation" or "Sentiment analysis"), the number of characters will only be the value in the report. For example, if the custom field uses the "Translation" function with the "Post comment" field on Facebook Insights, the value sent to the AI will be the length of the actual comment in the report.

Row limit

A row is a line on a table. Without any dimension, there's only one row. Splitting metrics into dimensions will add rows. You can only transform 100,000 unique rows per month using the AI features.

For example, when splitting a 30-day date range, there will be 30 unique rows. When splitting a report into campaigns, there will be as many rows as unique campaigns returned. So when you split the metrics by both campaigns and date, there will be 30 times the number of campaigns. 

When using the date to create a custom field with AI, only 30 rows of the AI custom fields quota will be consumed for this report even if it's split by campaign. This is because the same date doesn't have to be sent as many times as there are campaigns. The date can be sent only once and the same date value can be pre-populated with the cached result.