Tableau. Campaign parameters. Let media buyers switch accounts without republishing.

What this means for your store

A parameter is a user-controlled value that drives filters, calculated fields, and dynamic dimension swaps. Agencies serving multiple Shopify brands often clone workbooks per account; parameters let one template switch Brand, Ads Account, or Attribution Window from a dropdown. Combined with parameter actions, clicking a campaign bar can set the filter on a SKU margin detail sheet below.

Scenario on a real storefront

Tinuiti maintains one workbook template for three US DTC clients. Analysts pick the account at load and compare last-28-day ROAS without republishing:

// Parameter: Brand (String)
Values: All | Brand A | Brand B | Brand C

// Calculated filter
[Brand] = [Brand Parameter] OR [Brand Parameter] = 'All'

// Parameter: Compare window
Values: Last 7 | Last 28 | YoY same week

// Dynamic measure (secondary axis)
CASE [Metric Parameter]
  WHEN 'ROAS' THEN SUM([Revenue]) / SUM([Ad Cost])
  WHEN 'MER'  THEN SUM([Revenue]) / SUM([Total Marketing Cost])
  WHEN 'CPA'  THEN SUM([Ad Cost]) / SUM([Orders])
END

// Show parameter controls on dashboard tab - hide sheet-level brand filters

What to do next

• Parameters are not row-level security - users can type arbitrary values; use RLS instead.
• Default parameters to last 28 days so first load does not scan all history.
• Prefix parameter names (p_Brand) so they sort apart from warehouse fields in the data pane.

Bottom line

Parameters turn one ecommerce workbook into a reusable template for campaigns and brands. Use them for exploration and convenience, not tenant isolation.