The Scenario
You took over management of a DPD2 account from a contractor who left the company six weeks ago. There are eight storefronts in the account. You have no idea which ones are active, which currencies they're configured for, what their subscriber counts look like, or whether all of them are actually in use. Someone asked you this morning and you had to say you didn't know. That's not a position you want to be in twice.
The bad version:
- Log into DPD2 and click through each storefront one at a time, copying the name, URL, currency, and type into an Excel workbook by hand — which takes about four minutes per storefront and produces a table you're not sure is complete
- Try to find subscriber counts for each storefront separately, realizing the subscriber list view doesn't show which storefront each subscriber belongs to without clicking into each account
- End up with a workbook that's partially filled, two storefronts you're not sure you found, and subscriber counts you don't trust
This kind of audit shouldn't take most of the morning. It's structured data sitting in a known system — the gap is the extraction, not the analysis.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook and, through its built-in DPD2 integration, can inventory your storefronts and their subscriber data without any manual clicking. You ask once.
Here is the prompt for this task:
List all DPD2 storefronts and write each storefront's name, URL, currency, and type into the 'Storefront Inventory' Excel tab.
What You Get
- A 'Storefront Inventory' worksheet with headers: Name, URL, Currency, Type
- One row per storefront, covering every storefront in the account — not just the ones you happened to find manually
- Type field populated (e.g., standard, custom) so you can see at a glance which storefronts are configured differently
- The worksheet is ready to sort, filter, or share without any additional formatting
What If the Data Is Not Quite Ready
I also need subscriber counts per storefront in the same table
List all DPD2 storefronts and write each storefront's name, URL, currency, type, and subscriber count into the 'Storefront Inventory' worksheet. If subscriber count isn't available for a storefront, write 'N/A' in that column.
I want each storefront's subscribers listed in detail, not just a count
For each DPD2 storefront, list its subscribers and paste storefront name, subscriber email, and subscription status into the 'Subscriber Roster' Excel tab, grouped by storefront with a blank row between each group.
Some storefronts might share subscriber emails — I want to flag those
List all DPD2 storefronts and their subscribers. Write storefront name, subscriber email, and subscription status into the 'Subscriber Roster' worksheet. Then add a column D that flags any email address appearing under more than one storefront as 'Cross-Storefront'.
I need a full account audit in one shot — storefronts, subscribers, and a summary tab
List all DPD2 storefronts and write their name, URL, currency, and type into the 'Storefront Inventory' worksheet. Then list all subscribers per storefront and write storefront name, subscriber email, and status into the 'Subscriber Roster' worksheet grouped by storefront. Finally, in the 'Summary' worksheet, write each storefront name into column A and its subscriber count into column B, sorted by subscriber count descending.
Asking for the inventory and the detail and the summary in one prompt means you hand over a complete picture — not a half-finished table.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook, then ask it to inventory your DPD2 storefronts — or pull the subscriber list for a specific storefront you're trying to understand. For related tasks, see Export a Targeted DPD2 Customer Segment Into an Excel workbook or the hub at How to Connect DPD2 to Excel.