Page tree
Skip to end of metadata
Go to start of metadata
  • Help Content has moved. Help documentation for Marketing Cloud Personalization is now published in Salesforce Help. Starting February 1, 2023, the site will no longer be available.
  • New Name: Interaction Studio (formerly Evergage) is now known as Marketing Cloud Personalization. The new name reflects our mission and vision for innovation in Salesforce Marketing Cloud. We wish we could snap our fingers to update the name everywhere, but you can expect to see the previous name in various places until we replace it.  

This article is designed to help customers deal with common questions related to data import via ETL. If you cannot find the answer to your question in this document, feel free to contact support for additional help.

Questions in this Article

File Processing

How can I tell if my job is running?

On the Feeds Dashboard, select the ETL type you want to review to see an historical list of jobs, sorted descending by date including any in-progress jobs. That means you would see jobs in-progress at the top of the list. If there are no in-progress or completed rows in the table, the ETL has not processed any files.

The Job Progress percentage indicates how far along the job has progressed, with anything above 0% and below 100% still in progress. You can review percent success rates of the Extract and Transform stages as well as the commit counts. While a job is in-progress, you can review execution to view the logs in real-time. 

How will I know when the job is finished?

A job is finished when Job Progress has reached 100% on the Feeds Dashboard screen.

Can run concurrent ETL jobs?

Yes, if the jobs are different types that do not affect shared data types. For example, one dataset can have a User ETL job and a Product ETL job running simultaneously, but neither can run at the same time as a Transaction ETL since Transaction ETL impacts both users and products.

Does an ETL block updates to its corresponding data type from the Web SDK or Event API?

No, data coming from the Web SDK or Event API will still update corresponding data types while an ETL is running.  

What does TBD mean in the Feeds Dashboard?

If there are multiple queued ETLs, you may see TBD in the Start Time column if the processing of the target file has not started.

Alternatively, if you run a test of an ETL which results in an error so file extraction does not complete, such as when there is no target file selected, or the target file is empty, you will see TBD displayed in the Feeds Dashboard for that ETL job.

File Processing Errors

Why aren't my files processing?

Files are automatically processed only when the file names are structured correctly and placed in the correct directory. Refer to the CSV Feed Requirements section for specifications by feed type.

How can I use the Feeds Dashboard to view errors during the transform stage?

Click the Review Execution button while a specific batch is highlighted to review the job logs which include specific error reports.

Is there an error threshold that would cause a job to fail entirely?

The job will fail entirely if the error threshold reaches 10%.

There is an error stating "extract failed most likely due to a column or line delimiter." How should I diagnose?

The file must be a validly parsable CSV to be processed. If there are character mistakes, such as double quotes not closed or extra commas throughout a value, the file may not parse correctly. The log will include the file line number causing the error. 

There is an error stating "Warning: At least one Product is archived. Updates will not be visible in the UI." What does that mean?

This error message might appear when you are performing a product, category, or dimension/catalog object ETL upload. This error message means that at least one of the items in your ETL is currently in an archived state. An item becomes archived by doing one of the following:

  • Click Delete next to the item in the Interaction Studio catalog
  • Send an ETL with a column header of attribute:archived and a value of true

Archived items cannot be returned in any campaign and are not visible in the Interaction Studio catalog. If you want all items in your ETL to appear in the Interaction Studio catalog and be available to return in a campaign response, confirm that the attribute:archived column is in your ETL file and has value of false. This will unarchive any items that might be currently in an archived state.

File Requirements

What are the character limit counts?

Character limit counts are defined in the specification documents for each feed type available in the CSV Feed Requirements section.

What is the file size limit?

While there is no explicit file size limit, plan to limit file size to 5 GB.

Data Management

Can I unset a user attribute?

User ETLs are unique in that often Interaction Studio receives user data from multiple sources that are all canonical. Unlike Item Type ETLs, a blank value in the User ETL will result in no change to the existing attribute value. 

My ETL appears to have run, but items are not listed in the catalog. I only see 100 items on the item list page, but my file had many thousands of items. Is everything working correctly?

Once a catalog has more than 10,000 of an item, only items with item actions, such as a view or a purchase, will appear on the catalog list screen. You can still visit catalog edit pages directly by editing the item ID query string of a item edit page. Items that have no views or actions attached will be hidden from the catalog. 

Can I clear all commits related to a recent ETL load?

Due to data retention policies, Interaction Studio cannot clear commits related to a recent load. You may unset values and attributes as allowed by the ETL type, but Interaction Studio can't "clean up" incorrect or incorrectly loaded data.

The ETL file completed successfully, but I don't see the updates applied to changed products. Is there anything I should check?

Product updates through ETL or the Web SDK or Event API will not be applied if the product is locked which occurs when you manually edit the product's information and save changes. The assumption is that a manual edit is intentional and should take precedence over any inbound data source. When you edit a product page, the page will appear to be locked in the top right hand corner, but will only remain locked if you save an edit. 

To see if a product is locked, navigate to the product catalog (Catalog > Products), find the item on the overview screen, and look for the lock icon that appears next to the product name in the right-hand column (right under the delete button). If the product is locked, double click to edit the product, select Unlocked from the drop-down in the top right, and click Save. Unlocking the product will allow manual changes (and other unchanged attributes) to be updated by ETL, Web SDK, or the Event API.

ETL Customization

Can ETLs be customized?

No, ETLs can’t be customized by Interaction Studio support, partners, or customers.

How do I know what ETLs are available?

Available ETLs are all documented and available for review in the CSV Requirements section of this knowledge base.

Can I configure the error threshold for a specific ETL?

The error threshold is a constant value that cannot be configured.

SFTP Management

Can I move a file from testing to inbound in the Feeds Dashboard?

Files can only be placed in the inbound directory by accessing the SFTP.