Here's How to Get Data from 3rd Party E-Newsletter Performance Reports into Bionic for Agencies.
Performance results for E-Newsletters are often provided by 3rd parties. Bionic provides a template specific for E-Newsletters that enables you to load these results into Bionic.
Refer to Learn About Integrating Your Performance Data for the complete list of steps to complete your integration set up.
For all integrations, you will first need to Define Your Integration.
In this help article, we'll cover the steps on how to configure your E-Newsletter integration:
Define Placements to Include in Integration
After you have added the integration to your campaign, you will need to define which placements should use this integration. This will tell the template to include those placements automatically when you download it.
- In the media plan, go to the integration column that represents the E-Newsletter integration.
- Hover over the corresponding field for the placement you want to include.
- Press the Include button.
- Repeat for each placement you want to include.
TIP: Use the Filtering capability to limit the placements that display to make it easier to find them.
Export Template
Once you have defined which placements should be used with this integration, you can download a pre-populated template.
- Click on the Settings tab of the campaign.
- Go to the Integrations section.
- Next to the E-Newsletter integration, press the Download button.
- An Excel template will download for you to then update results.
Convert Results to Template
How you convert the results to this template is up to you. You may enter or paste from results from a file you received. The upload process will use the Headers to identify what the data is. As long as the Headers are present and the data is valid to the field, Bionic will load the data.
Only fill in results for days you want to report on. For example, if you only have monthly results, filter the spreadsheet to pull the last day of each month and insert the results against those days to represent the month.
| Template Header | Definition |
| Date - Bionic | The results date. The template will provide a row for each date the placement is scheduled to run. |
| Bionic Placement ID | The placement ID the results will load to. |
| Bionic Placement Name | The name of the placement the results will load to. This helps you to easily identify between placements when there are more than 1. |
| Source ID | Source ID for the placement as defined by the ad platform. This would only be necessary if you receiving data that needs to be mapped. |
| Source Group ID | Source Group ID for the placement as defined by the ad platform. This would only be necessary if you receiving data that needs to be mapped. |
| Opens | |
| Clicks | |
| Conversions | |
| Sends | |
| Deliveries |
Import Results
Once you have results ready, you can upload the template.
- In the Integrations settings, press the Upload button next to the E-Newsletter integration.
NOTE: If your vendor can provide this report (same headers), with the corresponding IDs for mapping, in a csv, Bionic Customer Support can set up an email address for them to email it to enable automation of the upload process.