Query: Get the report summary for each campaign

Description

Gain insights into the performance of each marketing campaign by examining key metrics such as open rates, click rates, and ecommerce revenue. This allows you to evaluate the effectiveness of each campaign and make data-driven decisions for future marketing strategies.

Query

Tables used in this query:

• mailchimp_campaign

SQL