Skip to content

Query: Qry Sum Marketing Spend by Campaign

Type: Select
Has Parameters: No
Has Joins: No
Has Subquery: No

Tables Referenced

  • Marketing Sub Campaigns
  • Marketing

Columns Selected

  • [Marketing Sub Campaigns].[Marketing Campaign ID]
  • Sum([Marketing Sub Campaigns].[Marketing Sub Campaign Spend])

SQL

SELECT [Marketing Sub Campaigns].[Marketing Campaign ID], Sum([Marketing Sub Campaigns].[Marketing Sub Campaign Spend]) FROM [Marketing Sub Campaigns]