If you have a Merlin deal or a Direct deal with a DSP, you'll need to set up your reporting connection in Revelator to start seeing analytics data. This article walks you through how to connect both daily trends and monthly reporting.

Note Once your credentials are set up, daily trends data typically appears in your Revelator account within 24–48 hours.

Daily trends reporting

Please follow the instructions below to connect your daily trends reports to your Revelator account.

Deezer

1. Go to Account Settings → Integrations → Reporting → Deezer
2. Select the Direct Deal card (even if you are on a Merlin deal)
3. Enter the credentials:

For Merlin deals:

• Host/Server address: ftp.merlinnetwork.org (do not include any prefix like ftpes://)
• Port: 21
• Username and password: provided by Merlin for your FTP access (this is not your Merlin Wizard login)

For Direct deals:

• Host/Server address, port, username, and password: provided directly by Deezer

SoundCloud

1. Go to Account Settings → Integrations → Reporting → SoundCloud
2. Select the Direct Deal card (even if you are on a Merlin deal)
3. Enter the credentials:

For Merlin deals:

• Host/Server address: ftp.merlinnetwork.org (do not include any prefix like ftpes://)
• Port: 21
• Username and password: provided by Merlin for your FTP access (this is not your Merlin Wizard login)

For Direct deals:

• Host/Server address, port, username, and password: provided directly by SoundCloud

Apple

1. Go to Account Settings → Integrations → Reporting → Apple
2. Select the Direct Deal card (even if you are on a Merlin deal)
3. Enter the credentials:

For Merlin deals:

• Host/Server address: ftp.merlinnetwork.org (do not include any prefix like ftpes://)
• Port: 21
• Username and password: provided by Merlin for your FTP access (this is not your Merlin Wizard login)

For Direct deals:

You'll need the following from Apple:

1. iTunes Username — Revelator may already have this if we deliver to Apple for you. If Revelator does not deliver for you, we recommend creating a new app-specific user rather than using an existing user's credentials. Instructions here.
2. iTunes Password — Same as above. Create an app-specific password if Revelator is not delivering for you.
3. iTunes Vendor ID— To find this:
   • Log into iTunes Connect and click Sales and Trends
   • Click Sales and Trends Reports in the bottom left column
   • Click your company name (in blue) in the central report area — your Vendor ID is the number next to it
4. iTunes Access Tokenand its expiration date — To generate:
   • Log into iTunes Connect and click Sales and Trends
   • Click Sales and Trends Reports in the left-hand side
   • In the upper-right corner, click the tooltip next to About Reports
   • Click Generate Reporter Token
5. iTunes Account Number — If you don't know this, email Support with items 3 and 4 above and we'll retrieve it for you.
6. Apple Music Analytics API key and Issuer ID— To set up:
   • Follow the instructions provided here
   • Your API key will be a file ending in .p8
   • Your Issuer ID will be in this format: E0E3EF8C-7594-324F-BAFD-282D09BAA38F

Once you have all the items above, enter them in Account Settings → Integrations → Reporting → Apple and email Support so we can confirm everything is set up correctly.

Spotify

Spotify requires Enhanced Bulk API credentials.

If you already have Spotify Enhanced Bulk API credentials:

1. Go to the Spotify Developer dashboard
2. Retrieve your Client ID and Client Secret
   
   
3. In Revelator, go to Account Settings → Integrations → Reporting → Spotify
4. Select the Direct Deal card (even if you are on a Merlin deal)
5. Fill out the following in the Daily Trendssection:
   • Analytics Licensor Name: your Spotify licensor name
   • Analytics API username: your Spotify Client ID
   • Analytics API secret/password: your Spotify Client Secret

If you don't have Spotify Enhanced Bulk API credentials yet:

1. Email Spotify at analytics-api@spotify.comwith the following:

   Subject: Spotify Provider API Access Request – [Your Company Name]

   Body: Include the following 3 lines (you only need to enter your information for #1 & #2):

   • Spotify account: one of the email addresses associated with your account
   • Company name: your company name
   • Provider API: Enhanced Bulk API
2. Once Spotify issues your credentials, follow the steps above.

Amazon 

1. Go to Account Settings → Integrations → Reporting → Amazon
2. Select the Direct Deal card (even if you are on a Merlin deal)
3. Enter the credentials:

For Merlin and Direct deals:

• Host/Server address: prod.reporting.amazonmusiccatalog.com
• Port: 22
• Username and password: provided by Amazon

TikTok

For TikTok daily trends setup, please contact Revelator Support. We'll provide you with the specific instructions to share with your TikTok representative.

YouTube Content ID

YouTube Content ID data is available in Revelator Pro for:

1. Revelator Deal customers — where Revelator delivers your content to YouTube under our Content Owner agreement
2. Revelator MCN customers — where your YouTube channels are joined to Revelator's MCN. To opt in, go to Account Settings → Integrations → Reporting → YouTube MCN and contact support to complete the connection.

Meta, Vevo, AWA

Reports from Meta, Vevo and AWA are also available for Merlin members — automatically ingested once your Merlin FTP credentials are connected for any DSP above.

Monthly reporting

For Merlin members

Revelator's integration with the Merlin Wizard automatically imports your revenue reports. (For more on how reports are processed, see: Reconciling Merlin Reports.)

To set up monthly reporting:

1. Go to Account Settings → Integrations → Reporting → Merlin
2. Select the Direct Deal card (even if you are on a Merlin deal)
3. Enter:
   • Host/Server address: ftp.merlinnetwork.org
   • Port: 21
   • Username and password: your Merlin FTP credentials
     
     

For Direct Deal customers

Monthly reporting is set up per DSP using the credentials provided by each DSP.

1. Go to Account Settings → Integrations → Reporting
2. Select the DSP you want to connect
3. Select the Direct Deal card
4. Enter the credentials provided by the DSP