Model Amplifications

introduction chord's data models have been built from the team's expertise in the world of e commerce currently, all data flows through the same models, delivering consistent outputs across brands however, just like the wide range of e commerce brands that sign on to chord, there is variety in custom data that brands want to feed into and surface from the existing chord data models chord now allows brands to extend their data by adding brand specific mappings and settings via the model amplifications feature on the platform amplifications allow brands to structure some of their unique data inputs for modeling so they can represent metrics fitted to their business needs brands will see data added as additional fields in explores or see fields updated based on the configuration settings in the templates once a specific amplification is enabled, it will process through the data models in the next scheduled run note that some data fields are required fields, and you'll see the following errors in case required fields are not completed please see an example below note our model amplifications feature only accepts files in csv format at this time please make sure the files you upload are csv files you can also use the download template button, open the template in google sheets, and populate the rows you need to then export it as a csv file you can then upload that csv file and all valid rows will be automatically added to the configuration sample use cases brand operators and data analysts could use model amplifications to manage additional dimensions for items in the brand's catalog by adding specific attributes to their products, which will in turn show up in the data models and allow them to customize what they see and analyze on chord reduce the need to create custom fields every time they want to report on the same dimension, like configuring the shopify order app ids to a specific name add sources that are not able to be directly connected through existing data connectors this could include tracking marketing and advertising spend for podcasts and radio ads getting started each amplification available to you can be accessed through the model amplifications page the first time you configure your amplifications, you need to fill in the amplification templates with your custom data mappings once you have filled out each amplification template with your custom data mappings, you can then enable them by requesting activation (templates that do not have any data will not be enabled) it will take about 48 hours for your amplification to be enabled and for your custom data to be surfaced in your existing chord data models once the 48 hour activation period has taken effect, your amplification will be enabled and will be available in your chord data models the activation process happens only once, adding additional data mappings to already enabled amplifications will continue to automatically feed into your chord data models going back to the model amplifications page, you will be able to see which amplifications you have enabled, which are in progess, and which still need to be enabled bulk uploading data data upload limitations users cannot upload files greater than 10mb please ensure that your file upload doesn't exceed 10mb in size this translates to roughly more than 30k rows of data please only upload csv files the chord platform will not be able to read any other file format for model amplifications please do not remove the "key" column provided in the csv template this column is used for internal purposes and should not be altered the chord data platform also supports bulk upload of data, which in turn supports brands that need to upload many rows of data, or need to need to add thousands of new skus to a specific data model at any given time note once you bulk upload data to our amplifications feature, there may be a wait time to view the results on our platform this is governed by the data refresh cadence set for your organization as well as the timing of the last data sync with fivetran to bulk upload data, you can follow the steps below on a given model amplification template, download the template, fill in the desired columns with your data, and click the upload csv button on the template page from here, you can attach a csv file to upload once you attach a valid csv file, the csv upload modal closes and you will see a message saying that the file is being processed during processing, the chord data platform will check the new file and validate all rows in the file to ensure that there are no duplicates (i e check required columns and uniqueness) once validated, the information in the new sheet will be appended to the original file all valid rows of data in the uploaded csv file will be appended to the model amplification invalid rows of data will be provided in a new file that can be downloaded by the user to reconcile once the initial upload processing is complete help & troubleshooting question i need to update a previously uploaded / provided datapoint in an existing amplification will the model amplifications feature find and replace this information when a new sheet is uploaded with current information? answer the model amplifications will simply append the updated data as a new row to the sheet existing rows will neither be removed nor updated based on what’s provided in an uploaded csv in other words, model amplifications will not "find and replace" one datapoint in a pre existing row at this time question what is the best way to update a large number of rows via an upload without changing already uploaded data? answer if there are a large number of rows that would be too time consuming to update manually (i e row by row directly in the amplification ui), these rows can be updated via the upload csv functionality to prevent unnecessary modification, you can download the amplification data in its entirety make the necessary changes directly in the csv clear all of the data in the amplification and then re upload if you have any additional questions or require additional help, please reach out to help\@chord co ! available templates listed in alphabetical order template name fields included notes release date advertising spend required fields source, date, spend this configuration enables you to include advertising spend for sources that are not able to be connected directly to data connectors, such as podcasts, newsletters, etc july 8, 2024 attribution channel mapping at least one channel plus the condition this configuration maps user defined channels and sub channels to page utm and referrer details july 12, 2024 (select tenants) campaign mapping required field campaign name this configuration maps the campaign name to different attributes it allows for only one row per campaign october 25, 2024 order app name order app id only available to chord performance (shopify) brands this configuration maps the order app id from shopify to a user defined name july 8, 2024 order filter at least one condition is required this configuration applies specific conditions to create a flag for orders in the orders, line items, and sales explores this configuration is designed to flag orders you want to filter out july 8, 2024 planned forecasts required fields date and forecast version name this configuration allows chord performance brands to upload their daily planned forecasts of gross and net revenue, along with number of orders and number of customers january 22, 2024 variant attributes required fields sku, product name, variant name, and existing hierarchy fields (product type, product sub type) this configuration maps additional attributes per variant that may not be available in the oms, including hierarchy, size, function, and color please note that this configuration only allows for one row per variant july 8, 2024