Revelator's integration with the Merlin Wizard enables our customers to automatically import revenue reports. 

Please follow the steps below to set up this connection:

  • In the new dashboard, go to your Account Settings > Integrations > Reporting > Merlin
  • Select the Direct Deal card (even though you are indeed using a Merlin deal)
  • Host/Server address: ftp.merlinnetwork.org — do not include anything else like ftpes://
  • Port: 21
  • And then enter the username and password that Merlin has given you for your FTP access (note that this is not the same login that you have been given to access the Merlin Wizard dashboard)


Note, there are times Merlin reports aren't uploaded for a variety of reasons:

  • The report may not yet have been provided by the Merlin. 
    • Each DSP reports on the previous month at different dates the following month (usually between the 15th and 25th of the following month). It may simply be that the DSP has not yet provided the report, or that it is late in providing it this particular month.
  • Revelator Pro only scans for reports 4 months back, and it may be that your report is older.
  • Revelator Pro is currently transitioning some reports from the old ingestion engine to our new ingestion. Report ingestion via our older engine is less comprehensive and may miss a report if it was provided later than usual.



Reconciling Merlin Reports:

  1. First step is to identify if the payment was deposited into your Bank Account from Merlin.
  2. Next, determine the type of currency the payment is in:

    • For instance, is it a Euro, GBP, or USD payment?

  3. Go to your Merlin Dashboard and click on Invoices. 

  4. Use the advanced filter in your Merlin Dashboard to:

    • Filter for the currency you are want to reconcile.  

      • You will see a list of invoices from DSPs with that currency

    • Filter for the payment number associated with one of the latest invoices on the list 

      • You will now have a full list of all the invoices that were included in that deposit to your bank

    • The total at the top of the list should now match the deposit to your bank

    • The first column “number” is the invoice number

  5. Next on your Merlin dashboard go to the Reporting tab

  6. Click on Royalty and Other revenue to search for the invoice numbers one by one to have the details of the report. You are looking for the reported month and amount.

  7. Use the advanced filter and filter for each DSP invoice number on that list of DSP invoices from step #3 (first column).

    • If you don’t find the invoice number you must also check in Other Revenue section found under the Reporting tab.

  8. Once you have found the invoice, select the stated reporting month in Revelator Pro and match the report on your Revelator Pro dashboard to the amount in Merlin.

  9. If the report is missing from Revelator Pro,  you must manually upload the report by retrieving it from the Merlin dashboard.

  10. There are reports that are called unidentified income.

    • Merlin doesn’t have a download for those reports on the Merlin dashboard.

    • Although you have been paid you must decide how to allocate those funds to your payees.

      • One option is to reupload an existing report from the same period as the period of the unidentified income and add an adjustment to the report so that the total matches the unidentified income amount to be allocated across the identified sales from that period.