Setting Up Mail Reports and Google Docs Reports

Learn how to set up Singular to process data from sources (ad networks) that provide reports by mail or Google Docs. For general instructions for setting up Singular to receive data, see the Data Connectors FAQ.

 

Some ad network partners do not have a reporting dashboard or API for Singular to query data from. Instead, you may be receiving campaign data by email or in a Google Docs document. Singular can process data from such sources if you follow these steps.

Setting Up Sources with Email Reports

  1. Add a data connector for the new 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.
    For more information about adding data connectors, see the Data Connectors FAQ.
  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.
  3. Ask your partner to start sending these daily email reports to your custom email alias.

Email Report Format

You can share this email report template 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) and your organization's name.

The to: field should identify the organization.

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

Best Practices

  • Email reports are more error-prone compared to app-based dashboards or API data due to the higher level of human intervention. Talk with your partner about providing API access to the data instead.
  • Your partner should update the reports daily, before 07:00 AM UTC if possible.
  • The partner should separate the platforms by iPhone and iPad.
  • Campaign names should be as descriptive as possible, including app names, platform, country, etc., when applicable.
  • The reports should be cumulative per month -- i.e., each report should contain all the days prior to it for a given month.
  • Have reports sent to both Singular and yourself 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.

Setting Up Sources with Google Docs Reports

  1. Share the google doc with reports@singular.net.
  2. Add the 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 Docs.
    contact_form.gif