Data Missing In Recurring Reports

You may notice there is data missing within a recurring report (conversions or publisher data) even though there is data present in the application.

What Causes The Issue?

There are two potential causes for this issue:

  1. This problem is most commonly caused by running your recurring report before that data has finished processing in the application. That means if you kick off your recurring report too early, you would see that data missing in the report. If you run this same report at a later time, this new report should contain all of the data.
  2. A recurring report that is scheduled to run automatically will be cut off at 100,000 rows. If your report exceeds 100,000 rows, the metrics in the report may be lower than what you see in the platform for the same date range.

How To Fix The Issue

To make sure your reports capture all data, you can set your recurring reports to run after the application has fully processed this data by following these steps:

  1. Click the Activity Log in the upper-right corner of MarinOne, then check when publisher data comes into the application.
  2. Click the Reports module in the bottom-left.
  3. Select the Scheduled tab.
  4. Click the link above the grid that says Edit Marin Search recurring reports here. This will send you to Marin Search to update a setting that is not currently available in MarinOne.
  5. Enable the box Do not run reports until, then select a later time than what you found in step 2.

If your report is cutting off at 100,000 rows, you can run the report manually by following these steps:

  1. Click the Reports link in the upper-right of the screen.
  2. Click into the Reports Templates sub-tab.
  3. Select the radio button to the left of the Report Template name you'd like to run.
  4. Click the Run the Report Now button.
  5. You will be able to access this report from the Completed Reports tab. If your report is set up to be emailed to you, this will also occur.

An alternative to the second process above is to apply filters to your report so that it is less than 100,000 rows; this will enable all of your rows to appear in the automatic report.

Additional Information

For more information on recurring reports and how to adjust the report time, refer to the following Help article: Reporting & Analytics - How to Create Recurring Reports.

Written by Marin Software

Last published at: June 29th, 2023