Call · 30 min
MarketingMattia Esposito12 November 202615 min read

Market research with AI. The right questions, the public sources that answer them, and no figure used until you have found it at the source.

Most of the answers in a piece of market research sit in free public databases, and AI finds them fast but sometimes cites them wrongly. Here is the Excel worksheet, with the prompts.

In brief

You do market research with AI by writing down the decision and the questions, choosing for each question the public source that answers it, and having the AI search only there. Before you use a figure, you open the source again.

Italy’s public sources are free. Istat makes all its data available at no cost under a CC BY 4.0 licence; Movimprese, from the chambers of commerce, counts business registrations and closures every quarter by sector and province; the Istat-ICE yearbook has more than 1,000 tables on foreign trade.

Always check. In a test by Columbia’s Tow Center, eight AI search engines gave wrong answers to more than 60% of questions about their sources.

The Excel worksheet is free to download below, with eight questions already filled in, the prompts and a worked example, also as a PDF.

Written by: Mattia Esposito, AI and marketing consultant, founder of Itria AI. From Puglia, based in Turin since 2023, he works remotely in Italy and abroad. LinkedIn profile.

The market research worksheet, free to download

An Excel worksheet with one row per question: the public source, the link to the table, the figure with its unit and year, the AI tool used, the source check and what it changes for the decision. The summary counts on its own how many figures you found at the source, and the verdict is picked from a menu. The second sheet holds the prompts, the third a worked example for a made-up pasta maker.

Worked example of the AI market research worksheet: a made-up pasta maker weighs up Germany with six questions, the public source for each, the figure and the check at the source
FileContentsLink
Excelto fill in, in Italian

The 20-row worksheet with the eight questions filled in, the source-check menu, the calculated summary, the prompts and the example.

analisi-di-mercato-con-ai-foglio.xlsx

PDFworked example, in Italian

Six questions for a made-up pasta maker, the tally of checks and the verdict.

analisi-di-mercato-con-ai-esempio.pdf

Worksheet questionPublic source to start fromWhat it won’t tell you
Is there demand in the area?

Google Trends, for interest over time and across areas.

How many people search

How big is the market?

IstatData; Eurostat to compare with other EU countries.

Your share of it

How is the local economy doing?

Istat: Congiuntura.Stat and the permanent business census.

How your own customers behave

Where are the customers?

Istat: the municipal statistical atlas and Demo; OMI for the cost of a shop.

Whether they will walk into yours

How many competitors are there?

Movimprese, by ATECO 2025 code and province.

Which of them sell well

What do they charge?

Competitors’ public websites and price lists, read by hand.

Negotiated discounts

What do their ads say?

Meta Ad Library, Google Ads Transparency Center.

Whether the ads pay off

Abroad: duties and trade flows?

Access2Markets, the Istat-ICE yearbook, foreign trade in IstatData.

Which importer is the right one

At the end of September I took 249 company websites from the showcase run by ICE, the agency that promotes Italian businesses abroad and where foreign buyers look for suppliers. I wanted to know what a visitor finds there. Of the 121 food and wine producers, 120 had some way to be contacted. A downloadable product specification sheet was offered by 19, and only one set out its terms for ordering.

In wine the specification sheet was there for 13 wineries out of 25, in the rest of food for 6 out of 96. All of it was public information, opened one site at a time. I closed the post like this: “How much you want to sell abroad can’t be measured. What a buyer finds when they look for you can.” The post of 30 September.

In August, before writing about the AI gap between large and small businesses, I read fifty-four sources in one day. The first thing to go was one of my own beliefs: I was sure the South of Italy lagged behind, and the sources said medium-sized firms in the South invest in technology at higher rates than those in the Centre and North. The gap lay in company size more than in geography. So the worksheet has a column for what changes in the decision: the post of 20 August.

Three readings made with public sources only

249 websites from the ICE showcase. Of 121 food and wine producers, 19 offered a downloadable specification sheet and one set out its ordering terms. The study of producers’ websites is in the food producers’ websites lab.

54 sources in one day. A belief that fell at the first reading: the lag in AI adoption depended on company size more than on region.

23 competitor profiles. Rewriting my own positioning, I read 23 Italian profiles: 21 said “automation” and none used a verb of measurement. That was the open ground: the post of 14 October.

What market research is, and what it does for an established small business

Market research measures the size, trends and competition of the sector you want to sell in, so that you can make a decision. The business plan guide from Unioncamere, the Italian chambers of commerce network, describes it as the way to assess the features, size, trends and opportunities of the sector you plan to work in.

The same guide notes that the work is for businesses that have been trading for years, as well as for new ones. A small business does it when it has to choose: a new area, a new product, a different kind of customer, a foreign country. Without a decision to make, the analysis turns into a document nobody reads twice.

The Small Business Administration, the US federal agency for small businesses, treats them as two jobs. In its words: “Market research helps you find customers for your business. Competitive analysis helps you make your business unique.” The worksheet keeps them together, because the second answers the question the first leaves open: who the customer will compare you with.

How to do market research with AI, step by step

Start from the decision, write the questions, and find the source that answers each one. The SBA lists six basic questions: whether there is demand, how big the market is, how the economic indicators look, where the customers are, how many alternatives already exist and at what price. The worksheet has eight, adding competitors’ advertising and selling abroad.

The six moves of market research with AI: the decision, the questions, the public source for each question, the AI search restricted to those sites, the check at the source, the verdict The decisiona single question The questionssix, plus yours Sourcepublic and free AI searchesonly those sites The checkopen the source The verdictgo in or not youSBA, UnioncamereIstat, Movimprese ChatGPT, Claudeyou, alwaysyou
AI does one step out of six: it searches and summarises. The decision, the questions, the choice of sources, the check and the verdict stay with the person deciding.

The SBA also separates two kinds of data. Existing sources, such as public statistics, are quick but general, and suit questions you can count. Primary research with customers, through interviews and surveys, is precise but slow and costly. AI shortens the first. The second stays with you, and the page on your customers’ words explains how to do it.

The last step is the verdict, and it has three possible outcomes: go in, stay out, or carry on with primary research. The third is the most common, and a good result. An analysis ending in “we need ten calls to these customers” has already narrowed the field, and work on brand positioning starts from there.

Free public data for market research in Italy: Istat, chambers of commerce, ICE, Eurostat

For a business looking at the Italian market, the main sources are IstatData, Movimprese from the chambers of commerce, the Istat-ICE yearbook for exports and Eurostat for European comparisons, all of them free. Istat says plainly that access, browsing and downloads of all its data are free of charge.

SourceWhat it gives youAttentionData reuse
IstatData (Istat)

Official aggregate data: businesses, employees, population, short-term indicators.

It replaced I.Stat.

CC BY 4.0, commercial use included

Foreign trade (Istat)

Exports and imports by product and country.

Coeweb is gone: the data now sit in IstatData.

CC BY 4.0

Istat-ICE yearbook

More than 1,000 tables on trade, exporting firms and foreign investment.

2026 edition published on 16 July.

CC BY 4.0

Movimprese (Unioncamere, InfoCamere)

Registrations and closures every quarter, by province and sector, as CSV.

Sectors in ATECO 2025 from 2026.

Its own terms of use

Business Register (Registro Imprese)

Company reports, accounts, shareholders and officers of a single business.

Documents are paid for.

Legal publicity register

Eurostat

The same indicators for every EU country, with shared definitions.

If you modify the data, say so.

Free reuse with attribution

Access2Markets (European Commission)

Duties, product requirements, rules of origin and statistics for more than 140 markets.

You start from product and country.

Free, also in Italian

OMI (Italian Revenue Agency)

Values per square metre for shops and property, by zone in every municipality.

Only rough guide values.

Terms on the page

Google Trends

Relative interest from 0 to 100 over time and across areas.

No search volumes.

Google’s terms

Ad libraries (Meta, Google)

Competitors’ ads, with dates and countries.

To read, not to copy.

Platform terms

Two details trip up AI tools too. The first is Coeweb: Istat’s database page says foreign trade statistics now sit in IstatData, replacing Coeweb, so an assistant sending you to the old address wastes your time. The second is classification: since the first quarter of 2026 Movimprese counts sectors under ATECO 2025, and InfoCamere warns to take care when comparing with earlier periods.

The Business Register works differently. InfoCamere describes it as a legal publicity tool: company reports and accounts for a single business are paid for, and automated access to the databases is reserved for business information providers. The aggregate counts from Movimprese are free, and they are enough to count the competitors in a province.

Competitor analysis: how to do it, with an example

To see what competitors say, and how long they have been saying it, open the ad libraries, which in the European Union are a legal requirement. Article 39 of the Digital Services Act requires very large platforms to keep a public repository of ads, with the content, who paid, the period and the targeting criteria.

Under the regulation, each ad stays in the repository for as long as it runs and for a year after it was last shown. In August 2023 Meta extended its Ad Library to every ad shown to people in the EU, commercial ads included. Google runs the Ads Transparency Center, where ads on Search, Display, Gmail and YouTube can be searched by advertiser.

In the worksheet example, a made-up pasta maker weighing up Germany opens the Ad Library with the country set and finds three Italian competitors running ads, all about tradition. None of them speaks to restaurants, and that gap is the first one to test. How to read a library line by line, with a competitor sheet, is in the guide to the Meta Ad Library.

The SBA adds market share, barriers to entry and indirect competitors, who solve the same problem in a different way. What competitors promise also shows how aware the market has become, and the page on Schwartz’s levels of awareness explains how to read it.

Can ChatGPT do market research? Using ChatGPT and Claude

Market research needs tools that search the web and cite their sources: ChatGPT deep research, and Claude Research or Claude web search. OpenAI writes that every deep research report includes citations or source links; Anthropic says each Claude web search answer includes citations.

Deep research proposes a research plan you can edit before it starts, and lets you restrict the search to chosen sites or put them first. This keeps it working on istat.it, infocamere.it and Eurostat rather than on blogs. Reports download as Markdown, Word and PDF, and usage is capped at a monthly number of runs that depends on your plan.

Claude Research runs several searches in a row and decides what to look at next based on what it finds. It comes with paid plans, and Anthropic notes that on mobile it searches the web only. With ordinary web search, if you give Claude the exact address of a table, it reads the whole page: the most direct way to make it cite the right source.

Market research AI prompt, one per worksheet question

Act as a market analyst. Question: [a question from the worksheet]. Product: [product]. Area: [area]. Use only these sites: [list].

For every figure give the value, unit, year of the data and a link to the exact table, not the home page. If the source does not say, write “not found” and do not estimate.

The model name matters little, because it changes every few months. What matters are the two things the prompt asks for: where to look, and what to do when the source has no answer. The worksheet has a prompt for each of the eight questions, with the check to run on the reply.

How far can you trust AI in market research?

Far enough to find the sources, never far enough to use their figures without opening them. The Tow Center for Digital Journalism at Columbia put 1,600 queries to eight AI search engines, asking each to trace a passage back to its source: “Collectively, they provided incorrect answers to more than 60 percent of queries.”

In the same test the tools rarely admitted they did not know, the paid versions were wrong with more confidence than the free ones, and several links led to copies rather than the original. The test covers news, in February 2025: it does not measure market research, but it shows that a citation next to a figure does not guarantee the source says so.

The underlying risk was already known. In 2023 Walters and Wilder, in Scientific Reports, checked 636 citations written by ChatGPT by hand: 55% of those from GPT-3.5 and 18% of those from GPT-4 were made up. Those models had no web search, and today’s tools cite real pages. The worksheet rule stays the same: Found, Different or Not found, after opening the source.

ErrorHow you spot itWhat you do
Made-up citation

The link does not open, or the page does not contain the figure.

Not found: drop the figure

Different figure

The table exists but shows another value.

Different: the source’s value wins

Wrong year

The figure is real but from another year.

Write the year in its column

Mixed classifications

Comparisons across years with different ATECO codes, or US codes on Italian data.

Drop the comparison

Index read as volume

“Searches per month” from Google Trends, which gives a relative index.

Rewrite it as relative interest

Copy instead of original

The link goes to a site that republishes.

Find the body that issues the figure

Outdated database

An address that no longer responds, such as Coeweb.

Find the table in the current database

On Google Trends, Google itself warns that the data come from a sample and do not mirror search activity perfectly. Two areas with the same value do not have the same number of searches, and queries from very few people show up as zero.

Italy, the European Union and the United States: different sources and classifications

Public sources don’t translate: each country has its own databases, its own sector codes and its own rules on ads. An assistant that mixes Italian and American data in one table produces wrong comparisons even when every figure is right.

ItemItalyEuropean UnionUnited States
Official statistics

Istat, IstatData

Eurostat

The federal databases listed by the SBA

Sector codes

ATECO 2025, in Movimprese from 2026

NACE Rev. 2.1

NAICS

Data reuse

CC BY 4.0, commercial use included

Free with attribution

SBA pages in the public domain

Reference public guide

Unioncamere, business plan guide

Access2Markets for exporters

SBA, market research and competitive analysis

Public ad repository

Yes, under the Digital Services Act

Article 39 duty for very large platforms

The DSA does not apply

How much market research costs, and who does it

With public sources and AI, the desk research costs the time of the person doing it plus a subscription to the tool; company reports and accounts from the Business Register are paid for separately. Istat, Eurostat, Movimprese, Access2Markets, Google Trends and the ad libraries are free; in-depth research in AI assistants usually needs a paid plan, and Claude Research always does.

The person making the decision does it, at least the first part: nobody else knows which question counts. Primary research with customers is what the SBA calls precise but slow and costly, and where you need representative figures it goes to a research firm. For a small business, primary research often means ten well-prepared conversations.

After the analysis come the choices that use it: the company name if the market is new, and the customers to find one by one through B2B lead generation or with AI tools for finding clients. The other guides along the way are in the small business marketing index.

Questions and answers

How do you do market research with AI?

Write down the decision you need to make and the questions to answer, pick the public source that answers each question (Istat, Movimprese, Eurostat, the ad libraries) and have the AI search only those sites. Check every figure against its source before you use it, and finish with a choice: go in, stay out, or keep going by talking to customers.

Which AI tool is best for market research?

One that searches the web and cites its sources: ChatGPT deep research, which lets you restrict the search to chosen sites, or Claude Research and Claude web search. The model name changes every few months; what matters is that each answer links to its source and that you can tell it where to look.

Can you do market research for free?

Largely, yes. Istat makes all its data free, Eurostat allows reuse even for commercial purposes, Movimprese publishes quarterly business registrations and closures as CSV files, and the Meta and Google ad libraries are open to anyone. You pay for company reports and accounts from the Business Register, and for AI plans that include in-depth research.

Can ChatGPT do market research?

It can handle the desk research: finding existing data, summarising it, putting it in a table with links. It does not replace primary research with customers, interviews and phone calls, and it gets citations wrong: in a Tow Center test at Columbia, eight AI search engines gave wrong answers to more than 60% of queries.

Where can I find data on competitors in Italy?

How many there are, by sector and province, comes from Movimprese, run by Unioncamere and InfoCamere. Data on a single company, its company report and accounts, are bought from the Business Register. What competitors say in their ads, and since when, is in the Meta Ad Library and the Google Ads Transparency Center.

How do you do a competitor analysis for free?

With the ad libraries, which in the European Union are public by law: Article 39 of the Digital Services Act requires very large platforms to keep a register with the message, who paid and the period, and Meta’s Ad Library and Google’s Ads Transparency Center can be searched without an account.

Note what each competitor promises and for how long, then add market shares, barriers to entry and indirect competitors, as the SBA suggests. The space nobody occupies is the first one to test.

Notes on sources

  1. US Small Business Administration, Market research and competitive analysis: the market research questions, existing sources and primary research, competitive analysis; source of the quotation. US federal government work, public domain in the United States. Read on 12 November 2026.
  2. Unioncamere, Servizio Nuove Imprese, Guida alla compilazione del business plan per l’avvio di imprese e start-up (PDF, December 2023, in Italian): source of the definition, paraphrased.
  3. Istat, databases (IstatData, foreign trade replacing Coeweb) and legal notes (CC BY 4.0); Istat and ICE, press release on the 2026 yearbook, 16 July 2026.
  4. InfoCamere for Unioncamere, Movimprese (ATECO 2025 from the first quarter of 2026) and Business Register. Read on 12 November 2026.
  5. Eurostat, Copyright notice and free re-use of data; European Commission, About Access2Markets; Italian Revenue Agency, OMI property values, updated on 15 October 2026.
  6. Google, Google Trends data FAQ and Ads transparency; Meta, transparency measures for the Digital Services Act, 22 August 2023; Regulation (EU) 2022/2065, Art. 39.
  7. OpenAI, Deep research in ChatGPT; Anthropic, Use research on Claude, updated on 30 October 2026, and Enable and use web search, updated on 9 November 2026.
  8. Klaudia Jaźwińska and Aisvarya Chandrasekar, AI Search Has A Citation Problem, Columbia Journalism Review, Tow Center, 6 March 2025: 1,600 queries to eight tools, on news. Walters and Wilder, Fabrication and errors in the bibliographic citations generated by ChatGPT, Scientific Reports, 2023, CC BY 4.0: 636 citations from models without web search.
  9. The counts on the 249 websites from the ICE showcase and the reading of the 23 profiles are Mattia Esposito’s own, published in his posts of 30 September and 14 October 2026. The worksheet example uses a made-up company, figures and competitors.
·Who does it for you

The worksheet lines up the market data. Finding the ground competitors leave open is the work that follows. Positioning is built starting from the market.

Mattia Esposito, who wrote this guide, also works with Itria on positioning: in-depth market analysis to find where competitors are exposed and take that ground. He did it on his own site first. In August, asked who had founded itria.io, ChatGPT couldn’t find him. From 11 October to 7 November 2026 itria.io pages appeared 13,803 times in Google and Bing results and 3,818 times in AI answers: Google’s AI Overviews and AI Mode, and Microsoft Copilot.