Skip to main content

Customizing table columns in dashboards

Choose which columns to show or hide in dashboard tables and save your preferences.

Updated today

Customizing Table Columns

Many dashboards in Datadrew feature detailed data tables with a wide range of metrics. The Column Visibility feature lets you choose exactly which columns to display, so you can focus on the metrics that matter most to your workflow.

Where Column Customization is Available

Column customization is currently available on the Product Performance dashboard. This dashboard can display 20+ columns depending on which integrations you have connected (Shopify, Meta Ads, Google Ads), and the column visibility control lets you manage this complexity.

How to Customize Columns

  1. Navigate to Product Performance under Product in the sidebar.

  2. Look for the "Columns" control above the data table, next to the Search and Export buttons.

  3. Click on the column selector to see a list of all available columns with checkboxes.

  4. Check or uncheck columns to show or hide them in the table.

  5. Your preferences are saved automatically — they persist across page reloads and sessions.

Available Columns

The columns available depend on which integrations you have connected:

Always Available (Shopify)

  • Product Title / Product Type / Vendor (depending on breakdown)

  • Blended Catalog ROAS

  • Orders

  • Customers

  • Units Sold

  • Net Revenue

  • Average Selling Price

When Meta Ads is Connected

  • Meta Ads Spend

  • Meta Ads CPC

  • Meta Ads CPM

  • Meta Ads CTR

  • Meta Ads Clicks

  • Meta Ads Impressions

When Google Ads is Connected

  • Google Ads Spend

  • Google Ads CPC

  • Google Ads CPM

  • Google Ads CTR

  • Google Ads Clicks

  • Google Ads Impressions

  • Google Ads Conversions

  • Google Ads Conversion Value

When Both Meta and Google Ads Are Connected

  • Blended Catalog Spend (combined Meta + Google spend)

How Preferences Are Saved

Your column visibility choices are saved per shop. This means:

  • Preferences persist — When you return to the Product Performance dashboard, your column selections are remembered.

  • Per-shop settings — If you manage multiple shops, each shop can have its own column configuration.

  • New columns appear automatically — If you connect a new integration (e.g., Google Ads) after setting your preferences, the new columns will appear as visible by default without overwriting your existing preferences.

  • Exports respect visibility — When you export data, only the visible columns are included in the export file.

Column Filters

In addition to showing or hiding columns, you can apply column-level filters to narrow down the rows displayed in the table:

  1. Hover over any numeric column header to see a small filter icon appear.

  2. Click the filter icon to open the filter options.

  3. Set a condition — Choose an operator (greater than, less than, equals, not equals, range) and enter a value.

  4. Multiple filters — You can apply filters on multiple columns simultaneously. Active filters are shown in a bar above the table.

  5. Clear filters — Click the "x" on any filter pill to remove it, or use "Clear All Filters" to reset everything.

Tips

  • Start by hiding columns you rarely use to reduce visual clutter.

  • When comparing Meta vs. Google Ads performance, keep both platforms' columns visible side by side.

  • Use column filters to quickly find products that meet specific criteria (e.g., ROAS greater than 5x, or spend greater than $100).

  • The Blended Catalog ROAS column is always visible and cannot be hidden — it is the most important cross-platform metric.

Need help? Contact us at support@datadrew.io or use the in-app chat.

Related articles


Need help?

If you have questions or run into issues, reach out to us at support@datadrew.io or use the in-app chat. We're happy to help.

Did this answer your question?