Create Ad-hoc Campaign Reports

You can utilize Campaign Exports in MoEngage to obtain detailed reports on your campaign performance. These reports help you analyze key metrics, including campaign attributes, target audience reach, delivery statistics, conversions, and performance, broken down by locale and variation. You can extract these reports for a specific date range or view data day by day.

You can export two types of campaign reports:

• Basic: This option allows you to generate a default report quickly.
• Advanced: This option allows you to select specific campaigns, customize report attributes, and schedule your exports.

Export a Basic Report

To export a basic report, perform the following steps:

1. On the All campaigns page in the MoEngage UI, click Export in the upper-right side.
   
2. On the Export campaign data dialog box, click Basic and then click Continue.
   
   The Export now pane appears.
   
3. In the Teams list, select a team. This option is visible only if the Teams feature is enabled for your workspace.
4. In the Channels list, select the channel types for which you want to export campaign data.
5. In the Campaign date field, enter the date range for your campaign selection. Only active campaigns within this selected range are included.
   For example, if you select January 1 to January 31, all campaigns with at least one impression during this period are included.
6. In the Created by list, select the required user names to filter campaigns created by specific users. This field is optional.
7. Click Export.

Export an Advanced Report

To export an advanced report, follow these steps:

Option 1

1. On the left navigation menu in the MoEngage UI, go to Reports > Campaigns.
   
2. On the Campaign reports page, click the + New report button in the upper-right corner.
   
   The Export campaigns page appears.

Option 2

1. On the All campaigns page, click Export in the upper-right corner.
   
2. On the Export campaign data dialog box, click Advanced and then click Continue.
   
   The Export campaigns page appears.

The advanced report process consists of three steps:

1. Select Campaigns
2. Report Format and Content
3. Scheduling and Delivery

Step 1: Select Campaigns

You can filter and export specific campaigns to include in your report.

1. In the Report name field, enter a name for your report. The name must be alphanumeric, start with a letter, and be less than 128 characters long.
2. In the Teams list, select a team. This option is visible only if the Teams feature is enabled for your workspace.
3. In the Channels list, select the channel types for which you want to export campaign data.
4. In the Campaign dates field, enter the date range for campaign selection. Campaigns that are active during this period are included, even if they have no impressions. For example, if you select January 1 to January 3, and a campaign (C1) was created on January 1 and had no impressions until January 5, C1 is still included in the report because it was active within the selected date range.
   

   info	Note You can only export data for 90 days at a time. If you need to export for a longer duration, such as 180 days, create multiple reports (for example, Day 0 to Day 90 and Day 90 to Day 180).

5. In the Campaigns section, select campaigns to include in the report. You have two options:
   • Select all campaigns: Includes all campaigns that meet the filter conditions.
   • Select campaigns manually: Choose specific campaigns to include. Use the campaign search and sorting options to find the campaigns you need.
     
6. Click the Filter campaigns icon to apply advanced filters:
   1. Under Has campaign tags, select an option.
      • All of these: This option allows you to filter the campaigns that have all the selected tags.
      • Any of these: This option allows you to filter the campaigns that have any of the selected tags.
   2. In the Select tags list, select the required tags.
   3. In the Created by list, select the user who created the campaign.
   4. In the Approved by list, select the user who approved the campaign.
   5. Select the Include archived campaigns in the report check box to include archived campaigns in your exports.
      
   6. Click Next.

Step 2: Define Report Format and Content

You can select the attributes for all channels you selected in the previous step:

1. Click the channel type.
2. Select the attributes to include in the report. You can use the default selection or choose attributes manually. Each selected attribute appears as a new column in the report.

3. To add custom attributes, configure a mathematical combination of existing campaign statistics attributes.
   For example, if you want to add Click-Through Rate (CTR), set the attribute name as "CTR" and the attribute value as @{campaign-stats.clicks} / @{campaign-stats.impressions}.

4. Choose how to display campaign statistics:
   1. Aggregate: View performance statistics aggregated over the campaign's lifetime.
   2. Day-wise: View a daily performance breakdown for the campaign. For example, if a campaign is active for seven days, the report shows statistics (impressions, conversions) for each of those seven days.

5. Select the Include stats only in the date range check box to pull reports that include data only from your specified date range.

6. Select the level of data granularity. You can export statistics broken down by variations and locales. This means the report will include a new row for each variation or locale.

7. Select your export format.

8. Click Next.

Step 3: Schedule and Deliver Reports

1. Configure the report schedule (Daily, Weekly, Monthly, or other options).

2. Select a Delivery Mode. You can receive reports via email or extract them using APIs. For more information, see Campaign Report API.
   
3. Click Create report.

Manage Exported Reports

You can manage all your exported reports from Reports > Campaigns. 

Understand Report Output Format and Structure

If you choose email as the delivery mode, you will receive a .zip file. The file name combines:

1. The report name (same as entered in the Campaign Report Builder), with spaces replaced by underscores. For example: "Report test" becomes "Report_test".
2. The report generation date in YYYYMMDD format. For example: "20210217" indicates the report generated on February 17, 2021.
3. The compression format, such as .zip.

For example, a final file name might be Report_test_20210217.zip.

File Naming Convention

Channel-Level Reports

If you extract channel-level reports, the .zip file contains a separate file for each channel in the format <Report Name>_<Channel Name>.

Flow Reports

If you extract flow reports, the .zip file contains:

1. A flow file in the format <Report Name>_<FLOWS>.
2. Separate files for each channel in the format <Report Name>_<Channel Name>.

File Format

Row: Each row represents a distinct campaign, including all relevant details specific to that campaign within the row.

Columns: Each column represents a different attribute. These columns correspond to the customized attributes you selected in Step 2 of report creation.

1. Periodic or Flow Campaigns: Periodic or flow campaigns have multiple child instances. Each instance appears in a separate row in the output file. The column for the parent campaign ID is empty for parent campaigns.
2. Day-wise Reports: Day-wise reports include a "Date" column. Each row shows the statistics for that specific date.

3. Variation and Locale-Level Reports: Variation and locale-level reports include "Variation" and "Locale" columns. Each row shows the statistics for a specific variation and locale.

Understand Delivery Statistics