With Supermetrics Studio, you can show data from free public sources, such as weather, public holidays, or stock prices, next to your marketing data. SuperAI finds the source and connects to it after you approve the source.
This article explains how to add public data to a dashboard, how site approval works, and gives use case ideas. Sources that need a login or secret can't be used.
How site approval works
When no Supermetrics connector exists for the data you ask for, SuperAI looks for a free public source. Before SuperAI connects to the source, you approve the site. The approval request shows:
The address of the site
The result of an AI check on whether the site is a public service that needs no login or secret
You choose how much of the site to approve:
Option | What it covers |
|---|---|
Only this endpoint | The address in the request, and anything under that address. |
The whole site | Every address on the site. |
After you approve a site, every dashboard in your team can use it, and nobody needs to approve the same source again. The dashboard owner can see the approved sites in the dashboard settings and remove any of them at any time.
Before you begin
To build or edit a dashboard with SuperAI, you need an eligible Supermetrics subscription with the Supermetrics Studio destination. SuperAI uses AI credits when it builds or edits a dashboard.
The dashboard owner approves each new site. If you're an editor, ask the owner to approve the site.
Instructions
Add a public data source to a dashboard
Go to Supermetrics Studio.
Open a dashboard and click Edit, or click New board to start a new dashboard.
In the SuperAI chat window, describe the data you want, such as
Show the daily weather forecast for [city] next to my ad spend.SuperAI finds a public data source for your use case, or you can suggest .Click Allow for this chat to give SuperAI access to the data.
When the Allow a new site for your team's boards? request appears, check the site address and the result of the AI check.
Select Only this endpoint or The whole site, and click Allow. To decide later, click Not now.
If the dashboard needs more sites, approve them one at a time as SuperAI asks.
Check the result on the dashboard. Ask SuperAI for any changes.
Click Save.
Review or remove approved sites
Go to Supermetrics Studio.
Open the dashboard and click the cog icon at the top right to open the settings.
In the External sources section, review the approved sites.
Remove the sites you no longer want your team's dashboards to use.
Use case examples
Public data gives your marketing results more context. Use these examples as a starting point, and describe the data, the place, and the time period you need in your own prompt.
Compare weather with sales or ad results
Add a weather forecast or past weather next to your sales or ad performance. You can see whether rain, heat, or cold changes how people respond to your campaigns, and plan around the forecast.
Example prompt: Show daily temperature and rainfall for [city] next to my ecommerce sales for the last 90 days.
Add public holidays to a campaign calendar
Mark public holidays on your performance charts, so you can explain spikes and dips in a region and plan campaigns around holiday dates.
Example prompt: Mark public holidays in [country] on my campaign performance chart for this year.
Follow stock prices, crypto, or public company data
Show the share price of a public company, such as a client or competitor, or the price of a cryptocurrency, next to your campaign spend.
Example prompt: Add a line chart of the share price of [company] next to my weekly ad spend.
Put economic indicators beside your spend
Place consumer confidence or inflation next to your marketing spend and results. You can check whether changes in the economy match changes in your performance.
Example prompt: Show consumer confidence and inflation for [country] next to my monthly marketing spend for the last 2 years.
Build a news tracker
Follow the news about your brand or your industry in the same place as your reports. SuperAI can use public news sources and RSS feeds.
Example prompt: Build a news tracker that lists the latest headlines about [brand or industry].
You can also build a prediction market tracker with public data.
Which sources SuperAI can use
SuperAI can use free public sources that need no login or secret. When SuperAI can't use a site, the request shows the reason, and you can click Ask AI to fix to try another approach.
SuperAI doesn't use these types of sites:
Pages that ask you to sign in
Pages that imitate another site
Link shorteners and redirectors
Sources that need an API key aren't supported.
Things to know
Public data sources are different from Public Data connectors, such as Instagram Public Data. Public Data connectors are data source connectors that we build and maintain.
For data that sits behind a login, such as a private spreadsheet, see How to connect a Google Sheets spreadsheet to Supermetrics Studio.