How to Export Competitor Ads from Google Ads Transparency Center to CSV or Excel

Google Ads Transparency Center is public. You can type a brand or a domain and see the ads that advertiser has run on Search, YouTube, Display, Shopping and other Google surfaces — often with first-shown and last-shown dates, formats, regions and impression ranges.

What you cannot do is export any of it. There is no "Download CSV" button, no official public API, and the useful dates and regions often sit one click deeper, on each ad's own page. If you are doing a competitive review, a quarterly creative audit, or a simple swipe file, you end up copy-pasting.

This guide walks through the manual method, a browser extension that turns a domain into a spreadsheet, and a cloud scraper if you want the same export on a schedule. I built the extension (aska Ads) and the Apify actor, so I will mark those clearly.

aska Ads exporter: type a domain, pick CSV or Excel, and export ads from Google Ads Transparency Center

What the Transparency Center actually gives you

On an advertiser page and on each ad's detail page you will typically see:

Field Where it appears
Advertiser name, verified ID (starts with AR) and advertiser country Advertiser header
Ad format: text, image or video Filters and each ad card
First shown and last shown dates Ad detail page
Regions and impression ranges, when Google reports them Ad detail page and the region filter
The creative (image, text preview or video) Ad card
A stable link to that ad The ad's own URL

The data is public advertising disclosure, not an account login. You do not need a Google Ads account to look it up. You also do not get everything a Google Ads manager would see: no CPC, no exact impression counts (only ranges, when present), no keywords, no budget.

Option 1: collect ads by hand

This is the right starting point, because you should know the source before you automate it.

  1. Open adstransparency.google.com.
  2. Search for a domain (nike.com), an advertiser name, or an AR… advertiser ID.
  3. Set the region and format filters if you only care about one country or one ad type.
  4. Scroll the grid until new ads stop appearing. The page loads a few at a time.
  5. Open each ad to read first/last shown dates, regions and impression ranges, and paste them into a sheet. Save the ad URL in its own column.

This works for a dozen ads. For a brand with hundreds of creatives it takes hours, and it is easy to miss a card that loaded late or a date that only exists on the detail page.

Two search habits worth keeping, even if you later automate the export:

  • Search by domain to catch ads run by agencies or regional entities for the same site.
  • Use the AR ID when you want one exact advertiser account and nothing else.

Option 2: export with aska Ads (in the browser)

aska Ads is a browser extension for exactly this job. It runs locally, does not need a Google account, and only talks to adstransparency.google.com (plus Gumroad if you later enter a license key).

Listings are currently in review on Chrome, Edge, Firefox and Opera, so install from ads.aska.uz once your store is live, or load the published package from the site when the store links appear.

  1. Install aska Ads and click its icon. The exporter opens in a tab.
  2. Type a domain such as nike.com, an advertiser name, an AR… ID, or paste an advertiser link from the Transparency Center.
  3. Optionally set region, format and (on Pro) a date range.
  4. Choose CSV or Excel. On Pro you can also tick Creatives ZIP.
  5. Press Export.

On any advertiser page in the Transparency Center you can also press Export with aska Ads and skip typing the name.

Export with aska Ads button on a Google Ads Transparency Center advertiser page

Each row in the spreadsheet is one ad, with advertiser, domain, creative ID, format, first and last shown, days running, impression ranges, regions, image link and size, and a link back to the ad.

On 16 November 2026 I ran a stability check against nike.com: two back-to-back exports both returned 600 ads out of 600, in a few seconds. That is one advertiser on one day, not a promise that every brand will look the same.

Pricing, as of this writing:

  • Free: up to 100 ads per export, CSV
  • Pro: $15 one-time — no per-export cap, Excel, creatives ZIP, filters, impressions and regions
  • Agency: $29 one-time — everything in Pro, plus a list of up to 50 advertisers in one run (one Excel sheet each) and custom columns

There is a 14-day money-back guarantee on the paid plans.

A limitation worth knowing up front: some formats (video, Shopping and other interactive ads) are drawn by Google on the fly and have no static image file. Those ads still appear in the spreadsheet with a link to the Transparency Center page, but they will not be in the creatives ZIP.

Option 3: run the same export in the cloud (Apify)

If you want a weekly job, a Python script, or a run that does not depend on your laptop staying open, use the Google Ads Transparency Scraper on Apify. It searches by domain, advertiser name, ID or URL, and can include impression ranges, countries, and image or preview links.

The Apify Free plan is enough to try a small run. From Python, after pip install apify-client:

from apify_client import ApifyClient client = ApifyClient("YOUR_APIFY_TOKEN") # from Apify Console > Integrations; do not commit this run = client.actor("veenkes/veenkes-google-ads-transparency").call(run_input={ "queries": ["nike.com"], "includeImpressions": True, }) for item in client.dataset(run["defaultDatasetId"]).iterate_items(): print(item["advertiserName"], item["format"], item["firstShown"], item.get("adUrl")) 

Replace the token with one from your own account. Pricing for the actor is usage-based (from $0.60 per 1,000 ads at the time of writing — check the Store page for the current rate). Failed targets are not charged.

Use the extension when you want a file on your machine in one click. Use the actor when you want a scheduled pipeline or to fan the same job out to many domains.

How to make the spreadsheet useful

  • Sort by days running. Creatives that have been on for months are usually the ones a brand is willing to keep paying for.
  • Export the same advertiser once a month and compare creative IDs to see what is new, what stopped, and what was refreshed.
  • Prefer a domain search for a brand overview, then drill into a single AR ID if one legal entity is the actual competitor.
  • Keep the ad URL column. Screenshot archives go stale; the Transparency Center link is the source.

Links

Google and Google Ads are trademarks of Google LLC. aska Ads is an independent product by veenkes and is not affiliated with or endorsed by Google.