The Scenario
The account is changing hands. Your agency is handing off a long-running Google Ads account to an in-house team next Friday, and the client's new marketing ops analyst has asked for a full inventory of every customer match and remarketing list in the account — names, membership counts, eligibility status, and when each list was last updated.
You've never actually seen a full list of what's in there. The account has been running for four years and has accumulated lists from at least three different contractors.
The bad version:
- Open Google Ads, navigate to Audience Manager, and start scrolling through the list view. It's paginated. You count 47 audiences across multiple pages.
- Export to CSV using the Google Ads UI's built-in export — which gives you name and status but not membership count, because that column isn't available in the standard export.
- Try the Google Ads API directly to get membership counts — realize you need to write a GAQL query against the user_list resource, look up the resource schema, discover that "member_count" is only available for Customer Match lists and returns null for all other types.
The handover doc is due Monday. It is now Thursday.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the account structure, queries the Google Ads API for your audience inventory, and writes a complete list into the workbook — including the fields that don't surface in the standard UI export.
Pull all remarketing and customer match lists from my Google Ads account using GAQL and populate my Excel sheet with list ID, name, size, eligibility status, and last updated date
What You Get
- One row per audience list across all types in the account.
- Columns: List Name | Type (Customer Match / Remarketing) | Membership Count | Status | Eligibility Status.
- Customer Match lists include actual membership counts where the API exposes them.
- Lists below the minimum membership threshold are flagged in the Eligibility Status column rather than left as a generic "inactive."
What If the Data Is Not Quite Ready
You only want the customer match lists, not remarketing lists
Pull all customer match lists from my Google Ads account using GAQL and write their names, membership counts, list sizes, and eligibility status into my Excel workbook — exclude remarketing and in-market lists
You need the last-updated date for each list
Pull all remarketing and customer match lists from my Google Ads account using GAQL and populate my Excel workbook with list ID, name, size, eligibility status, and last updated date — one row per list
The workbook is a handover template with specific columns already set up
Query all audiences in my Google Ads account and write the results into my Excel workbook matching the existing column headers: "Audience Name" in column A, "Type" in column B, "Member Count" in column C, "Status" in column D, "Last Modified" in column E — leave the header row intact
The full account audit prompt — inventory, flag, and summarize in one shot
Pull all customer match and remarketing lists from my Google Ads account — write name, type, member count, eligibility status, and last updated date into my Excel workbook — highlight any list in red where membership count is below 1000 or eligibility status is "Customer list policy violation" — then write a summary at the bottom showing total lists, total eligible lists, and total ineligible lists
One prompt generates the complete inventory, flags the problem lists, and gives the in-house team a usable document on day one.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook, then ask it to pull a full inventory of your Google Ads audiences with member counts and eligibility status. Also see: Upload a Customer Match Audience to add new lists to your account, or back to the Google Ads overview.