Ads columns: is this company advertising?
Three columns check whether a company runs ads, and how many: Google Ads, Facebook Ads and LinkedIn Ads. A company that pays for ads has a marketing budget, which headcount alone does not tell you. They need no key and no login, and they work in the desktop app. Each row is one action.
Which column to use
| Column | Give it | Rows at once |
|---|---|---|
| Google Ads: “Is this company advertising, and how much.” | A column of company websites or domains (Domain column) | 1 to 12, default 6 |
| Facebook Ads: “Ad activity, count, longevity, platforms.” | A Facebook page address, a page handle or a page id (Advertiser column) | 1 to 6, default 3 |
| LinkedIn Ads: “The strongest ‘has real marketing budget’ signal.” | A LinkedIn company address, or a website (Domain / company column) | 1 to 6, default 3 |
Add a column
- On Home, under Add data to a table, choose Google Ads, Facebook Ads or LinkedIn Ads. You can also click Enrichment in a table and pick it there. The editor opens already set up; nothing runs until you click run.
- Pick the column that holds the input shown above.
- Try the first 10 rows, then run the rest. See Control what a run costs.
What you get
| Column | Fields |
|---|---|
| Google Ads | Active, Ad count, Earliest start, Longevity (days), Last seen, Advertiser, Formats, Domain, Sample ad, Ad Library. Also two numeric columns, Google ad count and Google longevity (days), which you can filter and sort. |
| Facebook Ads | Active, Ad count, Earliest start, Longevity (days), Format, Platforms, Page ID, Ad Library. Also FB ad count and FB longevity (days). |
| LinkedIn Ads | Active, Ad count, Query, Sample ad, Ad Library. Also LinkedIn ad count. A count of “24+” means it hit the cap of about 24 per search. |
The cell shows a short summary, for example “active · 12 ads · 340d · Advertiser name”, or “none · 0 ads” when nothing was found in that library. Ad Library links to the public library page, so you can check the result yourself.
Read the result with care
- “None” means none found in that library. It does not prove the company does not advertise anywhere. For Facebook, a missing result is weaker evidence than a found one.
- Google: a company that buys ads through an agency can appear under the agency’s name. Longevity is worked out by Google.
- LinkedIn: the count is a floor, it covers active ads only, and it does not show spend. A website is matched to a company by a fuzzy guess from the domain name, so a LinkedIn company address is more reliable.
- Combine the three: a company advertising on several networks for months is a stronger signal than one with a single recent ad.
How they run
The Google Ads column makes one web request per domain and uses no browser, so it is fast. Facebook Ads and LinkedIn Ads load a real page in a background browser for each row, so they are slower. All three need the desktop app.
Messages you may see
| Message | What it means |
|---|---|
| “Could not parse a domain from …” | The Google Ads input is not a website or domain. |
| “Could not find a Facebook page_id for …” | The handle is wrong, the page is private, or it is not a page. |
| “Could not derive an advertiser keyword from …” | LinkedIn Ads could not work out which company you meant. Use its LinkedIn company address. |
| “LinkedIn served an auth wall (blocked)” | LinkedIn refused the request. Try again later, and use a lower Rows at once. |
| “No data” | The library returned nothing for that row. |