Setting Up Cost Reports Delivered by Email, Google Docs or s3 Bucket

Follow
Avatar
Dora Kishinevsky
Updated

Learn how to set up Singular to process advertising cost data from media partners (ad networks, media sources, agency partners, etc.) that provide reports by Email, Google Sheet or s3 bucket delivery. For general instructions for setting up Singular to receive advertising cost data, see the Data Connectors FAQ.

 

Some media partners do not have a reporting API for Singular to query data from. Instead, you may be receiving campaign cost data by Email, a Google Sheet document or a file delivered to a s3 bucket. Singular can process cost data from such media partners if you follow these steps.

Email Reports

  1. Add a data connector for the new media partner.
    • Go to Settings > Data Connectors.
    • Click Add a New Connector and enter the partner's name.
    • In the New Connector window, enter "mail" as both your user name and your password.
    • Click Save.
  2. Contact us to let us know you have a partner that only sends email reports. Singular Support will send you a custom email alias for your partner to use when sending these mail reports. In most cases this will be: 
    • clientname-noreply@singular.net
  3. Ask your partner to start sending these daily email reports to your custom email alias and to use the Email subject format when delivering the report: 
    • partner name - client name - daily report

Email Report Format

You can choose a templatized report format from our sample report templates to share with your partner. The fields highlighted in green are required from your partner in order for Singular to process your campaign data. The fields in blue should be included if applicable, but are not necessary.

The email Subject should include the partner name (as it appears in singular), your organization's name, and the report delivery cadence or date.

The to: field should identify the organization.

The sender/subject/body of the email is used to identify the network.

Google Docs Reports

  1. Share the Google Sheet doc with reports@singular.net.
  2. Add the media partner as a new data source.
    • Go to Settings > Data Connectors.
    • Click Add a New Connector and enter the partner's name.
    • In the New Connector window, enter your doc key.
      • Your doc key is the unique identifier found in the sharing URL of your document.
        sharing_url.png
    • Click Submit and wait for the green message telling you the source was configured successfully.
  3. Contact us to let us know if we should be receiving access to your partner's report via Google Sheet document and / or if there are issues with processing the report.
    contact_form.gif

s3 Reports

  1. Add a data connector for the new media partner.
    • Go to Settings > Data Connectors.
    • Click Add a New Connector and enter the partner's name.
    • In the New Connector window, enter s3 bucket Folder Name that your media partner has created within their s3 bucket to deliver your data.
    • Click Save.
    For more information about adding data connectors, see the Data Connectors FAQ.
  2. If the media partner has already delivered a file into that folder, Singular will begin to process the file. 
  3. Ensure your media partner delivers daily reports at the midnight in your timezone. See more here regarding data delivery and freshness.

For Partners

If you do not yet have a global integration set with Singular, mutual advertisers will not be able to search for a Data Connector with your name. You first need to complete the Singular partnership application, be approved as a partner and then provide the details we can use to create a global integration with you. 

General Best Practices

  • Your partner should update the reports daily at midnight in your Singular account reporting timezone and once again at 01:00 US-PST, if possible. Also, see our article on Data Freshness.)

  • The reports should be cumulative per month -- i.e., each report should contain all the days prior to it for a given month.
  • The partner should separate the platforms by iPhone and iPad for mobile device reported data.
  • Campaign names should be as descriptive as possible, including app names, platform, country, etc., when applicable
  • Have reports sent to both Singular and yourself (if using Email or Google Doc delivery) so you can easily tell if Singular is receiving the reports.
  • Make sure that your partner provides the reports with a consistent format/header and file naming conventions (time/date stamps) to avoid any processing issues.