Data automation

Data automation allows you to connect different types of data directly to Marq. You can quickly change information in a project depending on which row you select in the data.

Examples of data automation

• A product spec sheet: the project will auto-populate depending on which product you select
• Real estate property listing flyer: Select the property (or properties) and auto-fill a flyer with that listing’s information
• Employee directory: quickly add an employee’s contact information to a directory

Connect your data

Select a data source to learn more:

• • CSV
  • Google Sheet
  • XML
  • MLS

1. Navigate to the Marq home page. Click the “Data Automation” tab in the left panel. A window will open. You can add different sections of data. The example below shows a section for “Property Listings”, “Employee Directory”, and “Product Spec Sheet”.
2. Click the “Add Dataset” button on the bottom left to add a new set. Once it’s added, you can name the set and decide if you want the data to be shown in the Marq editor. You can also change the icon to make it easier to find when you’re editing a project.
   
3. Click the dropdown to select the source and 'connect' or insert the link to your feed

 

How to change the dataset icon

1. Navigate to the Marq home page. Click the “Data Automation” tab in the left panel. A window will open.
2. Click the icon dropdown below the dataset name to change the icon. 
    

Deleting a dataset

1. Click the three dots next to the dataset 
2.  Confirm the deletion

Reconnecting a dataset

1. Next to the dataset, click the trash icon
   
2. Confirm deletion. This will not remove your smart field connections as long as your column headers remain the same.
3. Reconnect to the dataset
   

Smart fields

Once your data is connected to Marq, you will need to convert the plain text in your templates and projects to smart fields. Smart fields allow information to auto-fill an entire project. If your project already has custom smart fields, you may need to replace them with smart fields from your new data source.

To add a smart field, highlight or place your cursor where you want to insert the smart field. Go to the top menu and click “Insert > Smart Field” and then choose your data source and add the correct column. A placeholder will be added to your project.

To learn more about smart fields, click here.

Smart images

Learn how to configure.

How to access images from your data source

A row from your data source might have images you can quickly access. Admins can upload these photos. To learn how to upload the images to a row, click here.

1. Open your file in Marq

2. If you want to populate a certain text box, select the text box first (the data needs to be applied before you can access the images)
3. Choose the data icon in the left content pane
4. Search for the row you’re looking for
5. Select the row and click, “Apply to Object” or "Apply to project" if you want it to be applied to the entire project.
6. In the left, click the “Images” tab to see any images tied to that row. Drag and drop to add it to your project.

Marq User Restriction

(For Google Sheets, CSV connections:) Allow only certain users to see data items from your data source. Do this by creating a column called "Marq User Restriction" in your dataset and inputting the emails of the users who can access the data separated by a semicolon. Then, go to your data automation manager in Marq and click the three dots next to the data set. Click "Enable data restrictions". Click OK to confirm.

(For XML/MLS connections:) The user restriction is controlled by the license number rather than email. Each user is assigned a license number. You can allow listings to be viewed by multiple users by having multiple license numbers assigned to a listing in the datafeed. 

Apply data to a project

Choose which data row to apply to your project and all smart fields will autofill. Quickly access images related to your data as well!

Apply data to an object

If you have multiple smart fields in a single text box, simply drag and drop a row of data into the object, and the data will auto fill.