Skip to main content
All CollectionsChannels & MMPs integrationChannel Integration
Custom Data Import
Custom Data Import

Connect your data from channels that are not currently supported by Luna's API

Luna avatar
Written by Luna
Updated over a year ago

Custom Data Import is a powerful tool that lets you quickly integrate any data source to the Luna platform using a data file, giving you a more comprehensive view of your activity across all of your channels. Now, you can generate data from any channel, even Ad Networks not listed in Luna’s supported partners.

External data (BI) vs. Custom Data Import

Before diving in, let’s clarify the difference between Custom Data Import and External BI data.

External BI data allows you to update existing entities (Campaigns, Ad-sets, etc.) for the following Channels: Facebook, Google, Apple, and Snapchat.

Custom Data Import allows you to add new entities and update them for Channels that are not currently supported by Luna’s API (See list here).

How to send the data:

Step 1: Requesting a new integration

Send a request to your Luna account manager with the following information:

  1. Data mailing list - The email address(es) that will be sending the .csv file
    ​

  2. Validation mailing list - The email address(es) where you want to receive updates on the file status, such as whether integration succeeded or failed. It is crucial to regularly check these messages as any failure will require action to resolve the issue. We recommend using a generic email address associated with your company, such as [email protected]
    ​

  3. A .csv file with the data you want to integrate into Luna’s platform. See below how to create a file. Other file formats will not be read by the system.

    Important: Failure notifications will come from [email protected]. Please mark this address as "not spam" to stay informed.

  4. If you'll be sending the files, contact your IT administrator and make sure your company uses SPF. If someone else handles these emails, guide them through these instructions.

    What's SPF?
    ​
    Luna's committed to the highest email security standards to make sure your data's safe. SPF is a configuration used to authenticate that the data coming from the files is indeed sent by you. If you want to learn more about it, see Woodpecker's article on the topic.

Step 2: Once your CSM approves the integration

  1. Set the email subject line with the following format:
    ​ DI|<client_name>|<channel_name>
    ​
    ​    For example: DI|ArcadeGames|SocialTube (Make sure there are no spaces between the separators and the words)
    ​
    ​

  2. Send your .csv file to [email protected]

How to create a file:

Custom Data Import supports the following levels of granularity:

  • Campaigns

  • Ad-sets

  • Ads

  • Creatives
    ​

Custom Data Import does not support:

  • Keywords

  • CPPs
    ​

You can choose to include all levels or only specific ones to your .csv file, depending on your needs.

Column names are adjustable and will be mapped according to the relevant hierarchy in the CM. For example, if you choose to send Creative-sets data, it will be mapped to the Ads level.

If you choose not to include certain levels, Luna will automatically generate a mock entity for the missing level, which will inherit the data from the upper or lower hierarchy level.

Mandatory fields:

  • Date for each row. Preferred date format: mm/dd/yyyy

  • At least one Campaign/Ad-set/Ad/Creative ID. Please keep in mind that each Campaign/Ad Set/Ad must have a unique ID, as sharing the same ID between two entities is not allowed.

  • Activity data. Must be at least one of the following metrics:

    • Spend

    • Impressions

    • Clicks

    • (More coming up)

IMPORTANT: The entity's ID seen on the platform must match the one seen on your MMP. Mismatches between IDs may cause unwanted results like entity duplication.

Optional fields:

  • Campaign/Ad-set/Ad/Creative Name

  • Creative file - If a creative file is provided, additional data will be automatically extracted from the file like dimensions, video length, etc.

Entity names will be automatically updated according to the file as long as the entity's ID remains the same.

Entity IDs can't be updated, as changing an entity's ID will result in duplication of entities. In addition, entity IDs can't be assigned the value of '0'.

File guidelines:

  • File size: up to 1 MB

  • Maximum number of rows: 100,000

  • File format: .csv only

  • Optional creative types: mp4, mov, gif, jpg, png, bmp, m4v, avi, mpg, zip, json, html, mpeg

  • Values guidelines:

    • Names can include spaces, except at the end

    • All metric values must appear in Numbers format

    • The following is unsupported:

      • 'K' abbreviations for numbers, like '100K' for 100,000

      • Currency characters, like '$'

      • Spaces within file names
        ​

Custom Data Import should occur within 2 hours of the email being sent.

My .csv file failed. What should I do?

If Custom Data Import fails, review the errors described in the failure email and take action based on the information provided. Once you've sorted out the errors that were identified, make sure to stay alert for any further messages that Luna might send your way. If you’re still not sure what to do - reach out to your CSM or open a ticket to Luna’s Support team.

Did this answer your question?