Search

Automatically Submit Data

Julia Randall
Julia Randall
  • Updated

You can automatically submit inbound data for a dataset, so that Claravine instantly funnels data that meets your precise data standards into downstream systems without requiring manual review. The automated routing of inbound data accelerates valid data's journey into your datasets and downstream exports, reducing bottlenecks.

Understand Automatic Submissions

For the datasets you select, when data is imported into Claravine, we route all error-free rows into the dataset and export automatically through outbound connectors without requiring manual user interaction. Successfully submitted, error-free data is available for review in dedicated, successful submissions. Any errored data continues to route to a Pending submission, where users can take action to resolve errors without having to search through error-free data to find what needs attention.

Enable Automatic Submissions

Admin users can enable this feature for a template during the Template Configuration process. In the template Settings, select the option to Automatically Submit Inbound Data.

AutomaticallSubmitDataClaravine.png

File-Based Inbound Connector Configuration

When data is automatically submitted for file-based inbound integrations (SFTP, Amazon S3) there is an additional configuration step to identify an identifier field we can reference to understand whether a row of data already exists in your dataset versus a new row. If we can’t identify a row as already existing we’ll add a new row to the dataset. If we can identify an existing row using a unique identifier field we’ll update existing rows when data is updated.

Configuration

When a template is enabled to Automatically Submit Data, you’ll notice a Unique Identifier FIeld in the SFTP or S3 configuration that must be specified. This identifier must be a field included in your inbound file that is unique for each row of inbound data (i.e. a campaign, ad group, ad, creative ID).
Once you’ve specified this field, completed the template configuration, and data begins to import we’ll search this field value in existing rows in the dataset and where the same ID exists in a row in newly imported data we’ll update the row of data in the dataset instead of adding a new row.
image.png

Review Automatically Submitted Data

When imported into The Data Standards Cloud via an inbound connector, data is generally routed to a Pending submission. When a template has this feature enabled, data will route to two submissions each time an inbound sync occurs.

Error-Free Data

A successful submission (with “AUTOSUBMIT” included in the submission title) is created, containing all error-free rows of data. These rows of data are automatically added to the dataset and exported outbound.

Errored Data

A pending submission is created, containing a rollup of all errored rows of data from all syncs that have been completed for the template.

Comments

0 comments

Article is closed for comments.