Google Shopping reports in Slack: the daily pulse most merchants check weekly and regret
For half the merchants on Shopify, Google Shopping is the biggest single source of paid traffic. The Google Ads dashboard is fine; nobody opens it. Push the right three charts into Slack and let the dashboard rest.
Google Shopping reports in Slack: the daily pulse most merchants check weekly and regret
For a meaningful slice of ecommerce, Google Shopping is the biggest tap. It's also the one people check the least often, because checking it means logging into Google Ads, drilling into Shopping or Performance Max, picking a date range, applying a filter, and remembering what "normal" looked like.
Nobody does that daily. They do it on Friday afternoon, get a small surprise, and promise to check more often next week.
The fix is the same one as every other "we should look at this more": stop relying on remembering, push the chart.
Three Shopping views that earn channel space
Spend, revenue, ROAS — daily
Three numbers, one chart. Spend on one axis, revenue on the other, ROAS as a thin line on top. Last 14 days, with the prior period as a ghost trace for comparison.
This is the single chart that answers "is Shopping working today" without requiring a human to log in. Daily, before standup, into #ecommerce or #paid-ads. Done.
Top-converting product groups — weekly
Shopping campaigns slice by product group. A bar chart of conversions (or revenue) by product group, weekly, tells you which corners of the catalog are doing the heavy lifting.
Useful for two things at once: budget allocation ("more to the winners") and merchandising ("our hero SKU isn't in the top five — why aren't people seeing it?").
Impression share trend — weekly
The one people forget. Shopping success is partly about your ads and partly about who else is bidding against you. A line of impression share over 30 days surfaces competitive pressure long before it shows up in your spend or your ROAS.
If impression share is dropping and ROAS is stable, you have a leading indicator of trouble. If it's rising and ROAS is dropping, you're winning more auctions at worse prices — also useful to know.
Pair it with the Shopify side
Shopping is only half the ecommerce picture. The other half is Shopify itself: revenue, AOV, orders, customer mix. Charts on one without the other is missing the point.
A sensible daily/weekly rhythm in a single #ecommerce channel:
- Daily 8am — Google Shopping spend / revenue / ROAS.
- Daily 9am — Shopify revenue, last 14 days.
- Weekly Monday — top product groups + Shopify AOV + new vs returning customer mix.
Three to four charts per week. Reading time per week: under a minute. We covered the Shopify side in Shopify revenue to Slack, Shopify weekly ecommerce review, and the combined picture in Klaviyo + Shopify + Google Ads cross analysis.
A Performance Max footnote
PMax bundles Shopping into a soup with display, search, and YouTube placements. Channel-level breakdown is limited (by design, thanks Google), so if you genuinely need Shopping-specific signal — top product groups, impression share — you may want a Standard Shopping campaign running alongside PMax for the SKUs you most care about. We won't pretend this isn't annoying.
Setting it up
- Add Google Ads as a source in Chartcastr.
- Pick the report (ROAS, product groups, impression share).
- Pick the channel and the cadence.
- Optional AI commentary so each post arrives with a one-line read on what changed.
