How to get your result data into Mediatool
Adding your campaign results to Mediatool allows you to create powerful reports and gain valuable insights. You can analyze results data independently or in direct comparison to plans.
Results data can be entered into the Results section of Mediatool in two ways:
Automatically, through third-party platform integrations
Manually, through direct input or Excel import
Automatic entry
If you would like to set up an integration or change the configuration of any integration, please refer to one of our step-by-step guides for integrations.
If you would like to associate results data with a specific plan or media entry in your plan, please refer to our article on methods of data tracking/matching. Reach out to your CSM if you have any further questions.
Raw data fetched from integrations will be stored in the Results section, separated into tabs by API source (e.g. Facebook Marketing, Google Campaign Manager, etc). To protect the integrity of your data, these sheets are locked and uneditable.
Manual entry
Manual entry is a common practice for campaign results from traditional media, such as TV and Radio as well as other platforms that we have yet to establish an integration with. Though, an equally common alternative to manual entry, for unsupported third-party platforms, is to establish a Google Sheets integration.
To get started with manual entry, you need to have a Results Media Type. Follow the same process as creating and configuring Planning Media Types, however, ensure that the Media Type is a results one instead of a planning one.
The Results Media Types will appear as separate tabs in the bottom left corner of the Results section.
How to manually add entries line-by-line
Navigate to the Results Section: Start by selecting 'Results' from the left-hand menu.
Access the Correct Tab: Locate and click on the appropriate tab at the bottom of the Results section. Tabs with a padlock icon are linked to integrations and cannot be manually altered.
Data entry: Enter your results data in each row.
How to copy and paste from an external sheet
Navigate to the Results Section: Start by selecting 'Results' from the left-hand menu.
Access the Correct Tab: Locate and click on the appropriate tab at the bottom of the Results section. Tabs with a padlock icon are linked to integrations and cannot be manually altered.
Copy and Paste the Data:
Open your external sheet and select all the rows and columns you intend to add.
Ensure the selected data matches the number of columns and rows in your Mediatool results sheet to maintain accurate placement.
Copy the selected data from your external sheet.
Paste it into the Mediatool results sheet. You can paste multiple columns and rows simultaneously, but remember to verify the alignment to ensure data integrity.
💡 When copying data from external sheets (for example Excel or Google Sheets) please make sure that the number and date formats in the sheet match your settings in Mediatool.
Import an Excel file
You also have the option to import an Excel file. The data will be added to the current tab that you are in when importing. You will find the import option right above your Results sheet view.
Navigate to the Results Section: Start by selecting 'Results' from the left-hand menu.
Access the Correct Tab: Locate and click on the appropriate tab at the bottom of the Results section. Tabs with a padlock icon are linked to integrations and cannot be manually altered.
Initiate the import: Begin by clicking on the 'Import' button.
Upload Your File:
Drag and drop your file into the designated blue area. Please make sure your file is properly formatted according to the guidelines provided below to ensure file compatibility.
Select Sheets for Import:
Choose the specific sheets you want to import from your file. Once selected, click 'Next' to proceed.
Match Columns Accurately:
Verify that all columns from your file correctly correspond to the destination columns. Ensure accurate data mapping to avoid errors.
Complete the Import:
After ensuring all settings are correct, click on the 'Import' button to finalize the process.
Ensure file compatibility
Make sure your file only contains raw data like in the image above
Column headers should be in the first row of the file
Data should be formatted according to their types:
Dates as dates, numbers as numbers, etc.
Dates are not guaranteed to be correct from CSV
The date format in the CSV file must match your date format in Mediatool
💡 Tip! If you need to make adjustments to the structure of the Results sheet, please contact your Mediatool admin(s) who can handle these changes for you.
Making use of the data
To visualize your results and compare them to your plans, head to the Reports section. You can choose from more than 20 chart types to get the insights that are most relevant to you!
Get Support
Have questions or need help? You can reach us directly via messenger on Mediatool.com or the contact support button located in the top right corner of the Mediatool App.
Learn More
Not a Mediatool user but interested in learning more? Book a demo with the Mediatool team today and start being more productive with your marketing.