PlugsightDocs

Did last week's campaign drive store sales?

Line up a campaign's dates with daily store revenue from WooCommerce or Magento, ad spend, GA4 revenue and Mailchimp orders to see if sales moved.

Check whether a campaign, email or promotion actually showed up in your store's sales, by putting the numbers for the same days side by side.

What you'll get

  • Daily store sales (revenue and orders) for the campaign week and the week before.
  • What the campaign spent and brought in on the same days: ad cost and conversions, or the email's clicks, orders and revenue.
  • GA4 sessions and revenue for the campaign, if it was tagged.
  • A comparison of the two weeks, and your AI's view on whether the campaign likely made a difference, with the caveats.

What you need

At least one store and one source of campaign data:

Ask this

Using Plugsight, our "Winter Sale" Google Ads campaign ran from 9 to 15 November. Show WooCommerce revenue and orders per day for those days and the 7 days before, next to the campaign's daily cost and conversions. Did store sales rise during the campaign, and by how much compared with the extra ad spend?

Variations

  • An email campaign: "Our 'Black Friday preview' Mailchimp campaign went out on 12 November. Show its clicks, orders and revenue, and WooCommerce sales per day from 12 to 18 November against the week before."
  • Using GA4: "Add GA4 sessions, purchases and revenue for the winter_sale campaign on the same days."
  • Magento: "Use our Magento store instead of WooCommerce."
  • Products: "Which products sold more during the campaign week than the week before?"

What your AI does behind the scenes

  1. Pulls store sales per day for both weeks (woocommerce_sales_report or magento_sales_report), with the best-selling products.
  2. For ads, pulls the campaign's cost and conversions per day (get_marketing_data with date and campaign as fields, filtered to the campaign).
  3. For GA4, pulls sessions, purchases and revenue for the campaign by day (get_marketing_data with campaign and date).
  4. For Mailchimp, finds the campaign (mailchimp_list_campaigns) and reads its full report (mailchimp_campaign_report), which includes orders and revenue when your store is connected to Mailchimp.
  5. Lines the days up and compares.

This shows whether sales moved at the same time, not proof that the campaign caused it. Other things (seasons, other promotions, stock) can move sales too, and your AI should say so. Magento reports use UTC dates.

Does it change anything?

No. Stores, ad platforms, GA4 and Mailchimp are all read-only in Plugsight.