The Import & Export Tool is used to map human readable names to numeric IDs actively being ingested into the UI from different ad servers. It is designed to accommodate mappings when Salesforce Audience Studio does not have an API integration with an ad server.
This documentation will cover off on how to use the Import & Export Tool in Audience Studio. You can find the tool by clicking Manage → Upload & Export Tool in the UI.
Some attribute value names are updated using an API. For example, DCM has an API that is available to update names for some media attributes (eg. campaign ID). For customers that are using this tool in conjunction with an API it is important to understand that the system always shows the most recent mapping it receives (regardless of if that comes from the UI or the API). For example, if you have a campaign ID (123) with a mapping of "Campaign 6" that came from the API at 8AM, but changed it to "Campaign Six" using the UI at 9AM, the UI would show "Campaign Six" starting at 9AM. However, because the API is queried every single day, the value would return to "Campaign 6" the next day.
It is not recommended to use this UI to update IDs that are being addressed through API integrations.
Workflow & Expected Outcomes
When used correctly, this tool will help you assign a different name for an attribute value for the following attribute types within Segment Builder and in the Campaign Performance report in the Activation menu:
- Page Attributes
- Media Attributes
Please note that this product is NOT intended to allow you to upload NEW attribute values. The general workflow for updating the name that is seen in the UI is as follows:
- Export name mappings for a specific attribute using the Import/Export tool
- Update attribute name mappings in the exported version using Google Sheets
- Upload updated name mappings using the Import/Export tool
1. Export Attributes
It is best to start an update by exporting all the attribute values that exist for an attribute.
Within Audience Studio, navigate to Export → Export Type → Attribute Name. In the Export Type drop down, select the attribute you would like to update.
You may choose to export CSV or Excel format, but we recommend exporting as a CSV as the file must eventually be uploaded in a CSV format. Excel files may be modified and then saved as CSV format prior to uploading modifications
2. Update Attributes
Using Google Sheets to Modify CSV Export
Once you have a downloaded CSV file, import it into Google Sheets. Within Google Sheets, navigate to File→ Import → Select File. You can make all updates to human readable names in Google Sheets, and save the file as a CSV to then import back into the UI.
Scientific Notation Issues
We have experienced cases in which the attribute value IDs are converted to scientific notation which ultimately does not successfully re-import into Audience Studio. To address these issues in Google Sheets you must convert the attribute value number format:
- Highlight Attribute Values → Format → Number→ More Formats → Custom Number Format
- Select 0 as the format and apply.
Using Excel to Modify CSV Export
Please note: There are known issues with using Microsoft Excel's rich formats to make these updates. As such, it is highly recommended that Google Sheets be used to make modifications to your attributes. If using Microsoft Excel to modify a CSV file, the file format must be .csv and numeric values must be plain numbers with no commas or scientific notation. The media attribute name column accepts unicode values and spaces.
If you would like to proceed with Excel, open a new Microsoft Excel spreadsheet. On the Data tab, in the Get External Data group, click From Text.
Browse for the csv file you want to import, select it and click the Import button (or simply double click the .csv file).
The Text Import Wizard will appear and you follow its steps.
- Step 1 Configurations:
- File Type - Delimited
- Start Import at row - 1
- File Origin - 65001 : Unicode (UTF-8)
- My data has headers - Yes
- Step 3 Configurations:
- All columns - Text
- All columns - Text
- Step 2 Configurations:
- Delimiters - Comma
- Treat consecutive delimiters as one - No
- Text qualifier - None
Choose the destination for the imported data, either an existing or a new worksheet, and click OK to finish importing your CSV file to Excel.
Save your file as a CSV and upload it to the Audience Studio UI.
Your Excel Sheet must have three column headers in the following order and format:
Here is what it would look like for Media Attributes:
Column MEDIA_ATTRIBUTE_NAME can be any one of the following values: Brand, Placement, Campaign, Site, Ad, Creative or ConfID. The value is case sensitive; all uppercase or all lowercase values will result in an ingestion status failure. If using a plain text file, column values should be encapsulated with (“ “) quotation marks.
Here is what it would look like for Page Attributes:
Any other order or more columns will result in an ingestion failure. Column headers must be capitalized.Please
Note: If any value in MEDIA_ATTRIBUTE_VALUE_CODE starts with 0 i.e. "0001", please reach out to our customer support team for assistance.
3. Upload Attributes
Save your file as a CSV and upload it to the Audience Studio UI. Go to Manage > Upload & Export tool. Select the “Upload Type” and then select the “Attribute Name”. Once these fields are selected, you may proceed with uploading your file.
4. Manage Status
All files that have been uploaded can be reviewed in the status screen, with all pertinent information about the ingestion. Once you have uploaded the file you should expect to see a status update within 5 minutes of the upload. The following define how to read the status screen:
- Name: This name is the attribute type and attribute being updated.
- Status: The status of the ingestion.
- Uploaded User: The individual who uploaded the file
- Status Last Updated: The date of the last action against the file.
- Upload File: The file that was uploaded to the system.
- Log File: The log of detailed processing results.
The system will always use the most recent information it receives. For example, if you upload mappings for the same IDs twice in the same day, the UI will reflect the most recent upload submitted. Once the process is finished you can expect to see values updated in the Segment Builder immediately, while Campaign Performance reports will update next day.
A file can have one of a few statuses:
- In Progress: The data is being processed and has not yet finished.
- Success: The processing has finished and every single record was successfully updated. Records that were included in the file but have no change to the name will show as successful records. Updates will reflect immediately in Segment Builder and will update next day in Campaign Performance Reports.
- Partial Success: A subset of the records failed to update for some reason.*
- Failure: Unable to start or make updates.*
Upon Partial Success or Failure, the log file will detail the number of records that failed, as well as individual line items not found.
Reasons for Partial Success or Failure:
- Values of Attribute Type are not valid
- IDs in Attribute Code do not exist in Audience Studio
- Data is not being captured for the campaign or campaigns may not be tagged
- Attribute Codes are in scientific notation in modified Excel
- Attribute Name does not exist in Audience Studio
- Header columns are out of order
- More than three columns in file
Downloading the log file will give you more detailed insight into the results of the file processing.
- Number of Records Processed: The total number of records addressed by the job.
- Number of Records Successfully Updated: The total number of records that were updated. If a record had no change it will still be counted as "updated".
- Number of Records Failed to Update: The total number of records that were ignored due to errors.
Additionally, there is detailed information about which records failed and the reasons for failure.
- Attribute Code Note Found: Only attribute values that already exist in the system get updated. If the value is not recognized, it triggers an error.
- Incorrect Attribute Name: Only records that have the correct attribute name will be processed.