Campaign Reports

Campaign exports provides you with detailed reports of the campaigns in order to analyse the campaign performance. These reports include campaign attributes, target audience, delivery stats, conversions, performance breakdown by locales and variations. These can be extracted for a specific date range or split day wise.

 

Steps to export campaigns

1. Navigate to All Campaigns Page. 

2. Click on the Export in the navigation bar. 

Screenshot_2021-02-10_at_9.10.52_AM.png

3. You have two options here -

Screenshot_2021-02-10_at_9.13.04_AM.png

a) Basic Report: You can quickly get a default export for the campaigns. 

b) Advanced Report:  You can select campaigns, customise attributes and schedule your exports.

 

Basic Report 

For the basic report, follow these steps -

Screenshot_2021-02-10_at_9.14.52_AM.png

1. Select Team name (this option is only visible if you are using teams)

2. In the Select Channels drop-down, select the channel types for which you can to export your campaigns. 

3. In the Select campaign dates, enter the date range for campaign selection. The campaigns that were active in the selected date range will be only included.

For example - If you select the date range as 1st Jan to 31st Jan, all the campaigns that had even single impression during this period will be selected. 

4. Select created by, if you can to filter out campaigns that were created by any specific user/s. This is an optional field.  

5. Click Export

Note-

The report will be sent to the email address of the logged-in user. The report will be sent to you within 6 hours.

 

Advanced Report 

The advanced report is further split into 3 steps - Select campaigns, Report format and content, Scheduling and delivery.  

Screenshot_2021-02-10_at_9.28.12_AM.png

 

A. Select campaigns 

You can filter out the campaigns, which needs to be included in your report -

Screenshot_2021-02-10_at_9.30.21_AM.png

1. Report Name - You can provide a report name. The report name should be alphanumeric, start with an alphabet and less than 128 characters long. 

2. In the Select Team name drop-down, enter your team name. This option is only visible if you are using teams. 

2. In the Select Channels drop-down, select the channel types for which you can to export your campaigns. 

3. In the Select campaign dates, enter the date range for campaign selection. The campaigns that were running (irrespective of the impressions) in the selected date range will be only included.

For example - Let's say, there was a campaign C1 that was created on 1st Jan and did not see any impressions till 5rd Jan. Now if you select the date range as 1st Jan to 3nd Jan, the campaign C1 will be included in the report. This is because C1 was still active during the selected date range. 

Note- You can only export data for 90 days at a time. If you want to export for longer duration say 180 days, please create multiple reports - D0 to D-90 and  D-90 to D-180. 

4. Filters - You can use advanced filters such as created by, approved by and also include archived campaigns in your exports.

Screenshot_2021-02-10_at_9.30.30_AM.png

5. Select Campaigns - There are two options here:

5.1. Select all campaigns: This would include all the campaigns that satisfy the filter conditions 

5.2. Select campaigns manually: You can select the specific campaigns that need to be included in the report. You can use campaign search and sort options to search for any campaign. 

Screenshot_2021-02-10_at_9.43.19_AM.png

6. Click Next. 

 

B. Report format and content 

You can select the attributes for all the channels that you have selected in the previous step -

Screenshot_2021-02-10_at_9.46.21_AM.png

1. Click on the channel type

2. Select the attributes that you want to include in the report - You can either use the default selection or can choose your attributes manually. All these attributes will appear as a new column in the report.

Screenshot_2021-02-10_at_9.48.13_AM.png

3. Add custom attributes - You can configure your own attribute as a mathematical combination of any of the campaign stats attributes.
For example : If you want to add CTR, set attribute name as CTR & attribute value as @{campaign-stats.clicks} #{/} @{campaign-stats.impressions}. Screenshot_2021-02-10_at_9.50.23_AM.png

4. Show Campaign Stats - You can select one of these two options -

   4.1. Aggregate - This is to get aggregate performance stats over the lifetime of the campaign. 

   4.2. Day-wise- This is to get a day-wise performance breakdown on the campaign. For example - If the campaign is active for 7 days, this is show stats(impressions, conversions) for each of these 7 days. 

Screenshot_2021-02-10_at_9.58.16_AM.png

5. Include stats only in the date range -This pulls reports including data from a specific date range.

Screenshot_2021-02-10_at_9.52.19_AM.png

6. Select level of data granularity - You can export stats breakdown by variations and locales. This means that there will be a new row in the report for every variation/locale. 

Screenshot_2021-02-10_at_9.59.36_AM.png

7. Select your export format. Screenshot_2021-02-10_at_10.02.18_AM.png

8. Click Next 

 

C. Scheduling and delivery 

1. Configure and schedule the report - Daily, weekly, monthly, etc. Screenshot_2021-02-10_at_10.06.00_AM.png

2. Delivery Mode - You can get your reports via email or you can extract it via APIs. Read more about APIs here. Screenshot_2021-02-10_at_10.08.49_AM.png

 

Manage Report 

You can manage all your reports on the Reports >> Campaigns. 

Screenshot_2021-02-10_at_10.16.11_AM.png

 

Output report format & structure 

If you selected email as the mode of delivery, you will receive a zip file. The file name is a combination of:

1. Report name is the same as the report name created in the Campaign Report Builder with space replaced by underscores. For example, the file name on the dashboard is *Report test*, then the file name for the API is *Report_test*.
2. Report generation date in YYYYMMDD format. For example, 20210217 in the name contains the report generated on 17/02/2021.
3. Compression format such as *.zip*

So, the final file name in this example will be  Report_test_20210217.zip 

File Naming convention 

Channel level reports:

If you have extracted channel level reports, the zip file will contain separate files for every channel with the format <Report Name>_<Channel Name>

Screenshot_2021-09-17_at_2.15.39_PM.png

Flow reports:

If you have extracted flow reports, the zip file will contain
1. A flow file with the format <Report Name>_<FLOWS>
2. Separate files for every channel with the format <Report Name>_<Channel Name>

Note- If you have used only a few channels in your report, you can only refer to the reports for those selected channels. Please ignore the other channel reports.

Screenshot_2021-09-17_at_2.40.09_PM.png 


File format 

Row: Each row corresponds to a different campaign. All details related to a campaign will be present in the same row.  

Columns:  Every column corresponds to a different attribute. These columns will be customised attributes that you would have selected on step 2 of report creation.  

Note-

1. Periodic or flow campaigns:

In the case of periodic or flow campaigns, it will have multiple child instances. All these instances will be present in a different row in the output file. There column corresponding to parent campaign id will be empty in case of parent campaigns. 

2. Day wise reports:

In the case of "Day wise reports", you will see a column called date. Each row will now correspond to the stat details for that particular date. Screenshot_2021-09-17_at_2.31.09_PM.png

3. Variation and locale level reports:

In the case of "Locale/Variation level reports", you will see two more columns - Variation and locale. Each row will now correspond to the stat details for that particular variation and locale. 
Screenshot_2021-09-17_at_2.34.25_PM.png

 

Understanding delivery stats

#  Column Name in report    Calculation 
 1.   Delivery rate   Delivered/Sent
 2.   Open rate
  Unique opens/Delivered
 3.   Click-through rate (CTR)
  Unique clicks/Delivered
 4.   Conversion rate
  Converted events/Delivered
 5.   Hard bounce rate   Hard bounces/Sent
 6.   Unsubscribe rate   Unsubscribes/Sent

 

Was this article helpful?
1 out of 2 found this helpful