Pubrio integration

Pubrio is a data provider for company and contact research, covering firmographics, tech stacks, hiring, advertising, news, and market-expansion signals. With this integration, you can enrich companies and people in Clay, find contact details, and build tables of companies that match your filters or are moving into a new market.

Creating a table with Pubrio

1. In a workbook, click + Add at the bottom.
2. Search for Pubrio and select Find companies expanding into a market with Pubrio or Find companies with Pubrio from the results.

Source Find companies expanding into a market with Pubrio

Find companies expanding into one or more markets using expansion signals, firmographic filters, company filters, or a plain-language search query.

Inputs

At least one of Expanding from, Expanding into, or Search query is required. Everything else narrows the results.

• Expanding from: Origin markets — the home countries a company is expanding out of.
• Expanding into: Target markets — the countries a company is expanding into.
• Search query: A plain-language description of the companies you want, which Pubrio interprets into expansion and company filters. For example, "fintech companies expanding into the UK".

Expansion filters:

• Expansion stage: How far along the company is in the market — Exploring, Committing, Expanding, or Scaling. Leave blank to include every stage.
• Expansion momentum: The trajectory of the company's movement in the market — Advancing, Steady, or Pulling back.
• Signal freshness: How recent the underlying expansion evidence is — Fresh (last ~30 days), Cooling (~30-60 days), or Stale (~60-90 days).
• Signal type: Only include companies with these kinds of expansion signals. The options come from Pubrio and only include signal types that are available to filter on.
• Signal strength: The evidence-confidence bucket of the expansion signals — Low, Medium, or High.

Company filters:

• Industry: A comma-separated list of industries. Pubrio matches the full industry name and ignores case, so use complete names like Software Development — a partial name like software matches nothing.
• Technology: A comma-separated list of technologies the company should use, such as Shopify, Salesforce. Terms Pubrio can't match are ignored.
• Employee count: Headcount ranges to filter companies by.
• Minimum revenue: Lowest estimated annual revenue, in US dollars.
• Maximum revenue: Highest estimated annual revenue, in US dollars.
• Company keywords: A comma-separated list of keywords to match against company specialties and descriptions, such as ecommerce, fintech.
• Job location: Only include companies posting jobs in these locations.
• Job title: A comma-separated list of job titles the company should be hiring for, such as country manager, sales manager.
• Ad target location: Only include companies running advertisements targeted at these locations.
• Advertisement keywords: A comma-separated list of keywords to match against advertisement content or titles.
• News category: Only include companies with news coverage in these categories.

Timing and volume:

• Expansion transition date from: Only include expansions that changed stage on or after this date. Accepts relative dates like 30 days ago or a date like 2026-08-01.
• Expansion transition date to: Only include expansions that changed stage on or before this date, in the same formats.
• Signal lookback window: Size of the rolling window in days, used only when no transition date range is set. Defaults to 90.
• Number of companies: How many companies to pull into the table. Defaults to 500, and Pubrio serves at most 12,500 per search.

Outputs

The source creates the following columns:

• Name: The company name.
• Domain: The company's domain.
• Target market: The market the company is expanding into.

Each row also carries the rest of the expansion record, including the expansion stage, the expansion model, the market presence, the company's home market, and its description, industry, founded year, employee count, and company size.

Source Find companies with Pubrio

Find companies by size, revenue, location, industry, technology, hiring, news, advertising, or cloud footprint.

Inputs

Add at least one filter. The filters are grouped into these sections:

• Company: Specific companies to look up, by name, domain, company professional profile URL, or the company search ID that other Pubrio actions return.
• Location: The countries a company is headquartered in, and cities or regions, each with a matching filter to exclude them.
• Industry and technology: Industries, industry categories and sub-categories, the technologies and technology categories a company uses, and company keywords.
• Firmographics: Employee count, estimated annual revenue, founded year, and the social platforms a company has a profile on.
• Hiring: The countries a company is posting jobs in, the job titles it's hiring for, and when the jobs were posted.
• News: The news categories a company has coverage in, and when that news was published.
• Advertising: The platforms, formats, status, keywords, headlines, and target countries of a company's ads, when those ads started, ended, or ran, and ranges for ad counts and estimated impressions.
• Advertising in a specific country: A company's advertising inside one country, such as its advertising rank or percentile there. Set Ad activity country and at least one other filter in this section.
• Cloud footprint: The cloud and hosting providers a company uses, the countries, regions, and cities its infrastructure runs in, when that infrastructure was first and last seen, and ranges for counts like hosts, servers, and providers.
• Cloud footprint in a specific country: A company's infrastructure inside one country. Set Cloud activity country and at least one other filter in this section.

For the job posting, news, and ad date ranges, set the start of the range whenever you set the end.

Results:

• Require all values for: Filters you pick here have to match every value you entered instead of any one of them. For example, picking Technology means a company must use every technology you listed.
• Sort by: How to order results: Relevance, Employee count, Founded year, or Advertising rank in a country. Sorting by advertising rank needs Ad activity country set.
• Sort descending: Reverse the sort order. This isn't available when sorting by relevance, which is ascending only.
• Number of companies: How many companies to pull into the table. Defaults to 500, and Pubrio serves at most 12,500 per search.

Outputs

The source creates the following columns:

• Name: The company name.
• Domain: The company's domain.
• Location: The company's location.

Each row also carries the rest of the company record, including the company URL, country, industry, logo URL, employee count and range, founded year, specialties, company keywords, company ranking, social profile URLs, and Pubrio's company search ID.

Enriching data with Pubrio

1. While in a Clay table, click Add enrichment and search for Pubrio.
2. Under Integrations, select one of the Pubrio options.

Action Find people at company

Search for key contacts at a target company, filtered by role, department, and location.

Inputs

Required:

• Company domain: The website domain of the company to search within, such as clay.com. (Required if Company professional profile URL is not provided.)
• Company professional profile URL: The company's professional profile URL. (Required if Company domain is not provided.)

Optional:

• Job title: A comma-separated list of job titles, such as Software Engineer, Product Manager.
• Management level: Filter by the management level of the contacts.
• Department title: Filter by specific department names.
• Department function: Filter by department functions.
• Company size: Filter by company size ranges.
• People locations: Filter by contact locations.
• Company locations: Filter by company locations.

Outputs

• People: Each matching contact, with their name, job title, seniority, departments and functions, headline, employment history, location, professional profile URL, and company details.
• Total people found: How many contacts matched your filters in Pubrio.
• Total people returned: How many contacts came back in this run, up to 25.

Action Find phone number (APAC)

Look up phone numbers for a contact from their professional profile URL.

Inputs

Required:

• Professional profile URL: The professional profile URL of the contact to find a phone number for.

Outputs

• Professional profile URL: The validated professional profile URL.
• Profile name: The profile's name in slug format.
• Phones: Each phone number found, with:
  • Value: The phone number in E.164 format, such as +16468089010.
  • Type: The type of phone number.
  • Status: The verification status of the number, such as Verified.

Action Find email (APAC)

Look up and validate email addresses for a contact from their professional profile URL.

Inputs

Required:

• Professional profile URL: The professional profile URL of the contact to find an email for.

Optional:

• Email type: The type of email to find. All email types are returned if you leave this blank.

Outputs

• Professional profile URL: The validated professional profile URL.
• Profile name: The profile's name in slug format.
• Emails: Each email address found, with:
  • Value: The email address.
  • Type: The type of email address.
  • Status: The verification status of the address.

Action Enrich personal profile (APAC)

Return a full contact record for a person from their professional profile URL.

Inputs

Required:

• Professional profile URL: The professional profile URL of the contact to enrich.

Outputs

• Data: The contact record, including:
  • Name, first name, last name, and headline.
  • Job title and seniority.
  • Departments and subdepartments.
  • Employment history, with the job title, company name, start date, and whether the role is current.
  • Location, city, state, country, and country code.
  • Professional profile URL.
  • Company: The contact's company, including its name, domain, company URL, logo URL, founded year, location, and any emails and contact details on file.

Action Enrich company

Return a full company record from a company domain or professional profile URL.

Inputs

Required:

• Company domain: The domain of the company to enrich. (Required if Company professional profile URL is not provided.)
• Company professional profile URL: The company professional profile URL of the company to enrich. (Required if Company domain is not provided.)

Optional:

• Include recent jobs, news, and lookalike: Set to true to also return the 5 most recent jobs, the 5 most recent news items, and the top 5 lookalike companies. Defaults to false.

Outputs

• Data: The company record, including:
  • Company name, description, title, and company type.
  • Domain, company URL, logo URL, and social profile URLs.
  • Industry, specialties, categories, verticals, and company keywords.
  • Founded year, employee count, company size, and estimated revenue.
  • Location, country, country code, and company addresses.
  • Publicly traded symbol and exchange, and company ranking.
  • Emails, phones, and contact details on file.

The next three outputs are only populated when Include recent jobs, news, and lookalike is on:

• Jobs: The 5 most recent job postings, with the job title, company, location, posting date, and job URL.
• News: The 5 most recent news items, with the title, summary, source, category, published date, and URL.
• Similar companies: The top 5 lookalike companies, each with a similarity score alongside the same firmographic fields as the main record.

Action Enrich company tech stack

Find the technologies used on a company's website.

Inputs

Required:

• Company domain: The domain of the company to find the tech stack for. (Required if Company professional profile URL is not provided.)
• Company professional profile URL: The company professional profile URL to find the tech stack for. (Required if Company domain is not provided.)

Outputs

• Data: The technologies found, grouped by category:
  • Category ID: Numeric identifier for the technology category.
  • Category name: The name of the technology category.
  • Technologies: Each technology in the category, with its name, icon, logo URL, tag ID, version, provider website, where it was detected, and when it was first and last detected.
• Total technologies: How many technologies were found.
• All technologies: Every technology found, as a single flat list.

Action Find open jobs at company

Find job postings at a company, returning up to 25 matching positions.

Inputs

Required:

• Company domain: The domain of the company to find jobs for, such as microsoft.com. (Required if Company professional profile URL is not provided.)
• Company professional profile URL: The company's professional profile URL. (Required if Company domain is not provided.)

Optional:

• Job title: A comma-separated list of job titles to search for, such as Software Engineer, Product Manager.
• Post keywords: Words to filter the results by, such as Python, React.
• Job locations: The locations where the jobs are based.
• Company headquarters locations: Filter by the company's headquarters location.
• Date job posted after: Only return jobs posted on or after this date. Accepts relative dates like 5 days ago or a date like 2022-07-31.
• Date job posted before: Only return jobs posted on or before this date, in the same formats.

Outputs

• Jobs: Each matching job posting, with its title, company, location, posting date, and job URL.
• Total jobs found: How many jobs matched your filters in Pubrio.
• Total jobs returned: How many jobs came back in this run, up to 25.

Action Enrich company expansion summary

Return a summary of where and how a company is expanding.

Inputs

Required:

• Company domain: The domain of the company to summarize expansion for. (Required if Company professional profile URL is not provided.)
• Company professional profile URL: The company professional profile URL of the company to summarize expansion for. (Required if Company domain is not provided.)

Outputs

• Company search ID: Pubrio's identifier for the company.
• Home market: The company's home market.
• Expansion score: The company's overall expansion score.
• Markets summary: Each market the company is active in, with the stage, confidence score, signal count, distinct signal-type count, first and latest signal dates, last stage transition date, market-level expansion score, and whether the market is new.
• Summary: Roll-up figures across every market, including the number of active, total, and new markets, momentum percentage, total signal count, scaling and pipeline counts, the top and newest markets, the signal volume trend, and the expansion score for the window.
• Firmographics: The company's name, domain, company URL, professional profile URL, logo URL, country, employee count, company size, founded year, industry, and estimated revenue.

Action Enrich company expansion details

Return the detailed expansion record for a company, including its stage, the signals behind it, and how the market presence has changed over time.

Inputs

Required:

• Company domain: The domain of the company to get expansion details for. (Required if Company professional profile URL is not provided.)
• Company professional profile URL: The company professional profile URL of the company to get expansion details for. (Required if Company domain is not provided.)

Optional:

• Market: The target market to report on. Leave blank to auto-pick the company's most active market.
• Include all markets: Set to true to return the company's entire expansion footprint across every market instead of a single market. This overrides Market.
• Signal type: Only return signals of this type.
• Search query: A plain-language description of what you sell, or the buyer profile you're evaluating this company against.
• Explain match: Set to true to return an AI summary of the company's expansion activity, read against your search query and grounded in its real signals. This requires a Search query.
• Expansion transition date from: Only include expansions that changed stage on or after this date. Accepts relative dates like 30 days ago or a date like 2026-08-01.
• Expansion transition date to: Only include expansions that changed stage on or before this date, in the same formats.
• Signal lookback window: Size of the rolling window in days, used only when no transition date range is set. Defaults to 90.

Outputs

• Data: The expansion record for the market, including the country, stage and stage rank, expansion model, local headcount and coverage, and market presence.
• Company: The company's description, company URL, and social profile URLs.
• Signals: Each expansion signal, with its type, strength, polarity, event date and date precision, source type, display label, evidence URL, and metadata.
• Timeline: Each stage transition, with the country, stage, confidence, transition date, transition kind, and the signal that triggered it.
• Markets summary: Each market the company is active in, with its stage, confidence score, signal counts, 30-day and 90-day signal velocity, confidence momentum, and first and current rank.
• Other markets: The remaining markets, with stage, confidence score, signal count, and signal and transition dates.
• Signal type totals: Signal counts by type, with separate totals for the recent window.
• Signal weekly totals: Signal counts by week and type, with sample labels and subtypes.
• Evidence breakdown: Counts of the evidence behind each signal type.
• Market presence: The kind and strength of the company's presence in the market, its address, and how long it has been known.
• Match summary: When Explain match is on, the AI summary text and the citations behind it.

Action Compare company expansion footprints

Compare the expansion footprints of several companies side by side.

Inputs

Required:

• Company domains: The domains of the companies to compare. (Required if Company professional profile URLs is not provided.)
• Company professional profile URLs: The company professional profile URLs of the companies to compare. (Required if Company domains is not provided.)

Optional:

• Expansion transition date from: Only include expansions that changed stage on or after this date. Accepts relative dates like 30 days ago or a date like 2026-08-01.
• Expansion transition date to: Only include expansions that changed stage on or before this date, in the same formats.
• Signal lookback window: Size of the rolling window in days, used only when no transition date range is set. Defaults to 90.

Outputs

• Companies: One entry per company, each with its Pubrio company search ID, home market, expansion score, markets summary, and firmographics.

Action Get market expansion overview

Return a market-level view of expansion activity, rather than a single company's.

Inputs

Required:

• Expanding into: The target market to report on — the country companies are expanding into. Accepts a country name or ISO code, such as Singapore or SG. (Required if Expanding from is not provided.)
• Expanding from: The origin market to report on — the country companies are expanding out of, in the same formats. (Required if Expanding into is not provided.)

Optional:

• Expansion stage, Expansion momentum, Signal freshness, Signal type, Signal strength, Industry, Technology, Employee count, Minimum revenue, and Maximum revenue: The same filters described under Find companies expanding into a market with Pubrio.
• Expansion transition date from: Only include expansions that changed stage on or after this date. Accepts relative dates like 30 days ago or a date like 2026-08-01.
• Expansion transition date to: Only include expansions that changed stage on or before this date, in the same formats.
• Signal lookback window: Size of the rolling window in days, used only when no transition date range is set. Defaults to 90.

Outputs

• Countries: Each country in the report, with the number of companies carrying signals, inbound and outbound counts, a count per expansion stage, new transitions in the last 30 days, pairs ahead of pace, and the freshest transition date.
• Top flows: The largest cross-border flows, each with the home market, target country, company count, and new transitions in the last 30 days.
• Filters: The origin and target markets the report was run against.

Action Enrich company advertisement insights

Return a company's advertising activity, including its active and newly launched ads.

Inputs

Required:

• Company domain: The domain of the company to get advertisement insights for. (Required if Company professional profile URL is not provided.)
• Company professional profile URL: The company professional profile URL of the company to get advertisement insights for. (Required if Company domain is not provided.)

Optional:

• Start date: Only include advertisements from on or after this date. Defaults to the last 90 days, and accepts relative dates like 30 days ago or a date like 2026-08-01.
• End date: Only include advertisements from on or before this date, in the same formats. This has to be on or after the start date.

Outputs

• Totals: The total number of advertisements, how many launched in the window, how many are active, and how many markets and channels they cover.
• Postings: Advertisement counts broken out by market, channel, format, and audience reach tier.
• Placement mix: Advertisement counts by placement.
• Creatives: Sample creatives, each with its headline, body, call to action, image URL, advertisement and destination URLs, advertiser, format, and whether it includes video.
• Weekly advertising trend: Advertisement counts by week.
• Window days: The size of the window the insights cover, in days.

Action Enrich company news insights

Return a company's news coverage and how that coverage has trended.

Inputs

Required:

• Company domain: The domain of the company to get news insights for. (Required if Company professional profile URL is not provided.)
• Company professional profile URL: The company professional profile URL of the company to get news insights for. (Required if Company domain is not provided.)

Optional:

• Start date: Only include news mentions from on or after this date. Defaults to the last 90 days, and accepts relative dates like 30 days ago or a date like 2026-08-01.
• End date: Only include news mentions from on or before this date, in the same formats. This has to be on or after the start date.

Outputs

• Totals: Total mentions, the number of distinct topics and sources, and the top source.
• News signal type breakdown: Mention counts by news signal type.
• Market breakdown: Mention counts by market.
• Weekly news trend: Mention counts by week.
• Window days: The size of the window the insights cover, in days.

Action Find company news

Find news articles about a company, filtered by keyword, news category, language, and published date.

Inputs

Required:

• Company domain: The domain of the company to find news for. (Required if Company professional profile URL is not provided.)
• Company professional profile URL: The company professional profile URL of the company to find news for. (Required if Company domain is not provided.)

Optional:

• Search keywords: Only include articles matching these keywords, such as funding, product launch.
• News categories: Only include articles in these news categories, like acquisitions or launches.
• News languages: Only include articles published in these languages.
• Start date: Only include articles published on or after this date. Accepts relative dates like 30 days ago or a date like 2026-08-01.
• End date: Only include articles published on or before this date, in the same formats. This needs a Start date and has to be on or after it.

Outputs

• News articles: Each article found, with:
  • Its title, summary, URL, source, and image URL.
  • Its published and last modified dates.
  • Its news category, category slug, and language.
  • The locations and country codes it covers.
  • Mentioned companies: Each company the article names, with its name, domain, company URL, professional profile handle, and country code.
  • Its news galleries and Pubrio article ID.
• Total news articles found: How many articles matched your filters in Pubrio.
• News articles returned: How many articles came back in this run, up to 50.

Run settings

• Auto-update: Turn this on to run the enrichment automatically on new rows and whenever a row's inputs change.
• Only run if: The enrichment will only run if conditions are met. (Learn more about conditional formulas here!)

FAQs

What's the difference between the expansion summary and expansion details actions?

Enrich company expansion summary gives you one row per company: the home market, an expansion score, and a compact summary of every market the company is active in. It's the right choice for scoring or sorting a list.

Enrich company expansion details goes deep on a single market instead, returning the individual signals, the stage-transition timeline, signal velocity, and the market presence behind the score. Reach for it once you've picked the accounts you want to understand.

Do I need a Pubrio account to use these actions?

No. Every Pubrio action and both sources run on Clay's own access to Pubrio, so there's no API key to bring and no separate Pubrio subscription to buy.

Do the Pubrio sources refresh on their own?

Not unless you put them on a schedule. Both sources run once when you create them. To re-run one or schedule it, open the source's Run settings and click Run now, or set Run this source to On a schedule. These settings appear on plans that include scheduled sources.

A re-run only adds results that aren't already in the table. To refresh the existing rows with Pubrio's latest data too, turn on Update existing rows before you re-run.