1. Help Center
  2. Creating your design
  3. Automation and other advanced features

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:

Note - currently only those who have reached out to their CSM and have been granted the 'real estate' persona can connect to an MLS or XML feed. The MLS/XML feed is currently only property listing related and must be the first dataset. If you have an existing dataset and want an MLS/XML connection, reach out to support@Marq.com

  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
 

Note: If you add multiple data sources to one datasets, the columns need to be exactly the same. Also, if you would like to make changes to your data sources, you should not delete your entire dataset (or that will remove all your smart fields in your projects).

 

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

IMPORTANT: If you have any existing smart fields using the dataset, the connection will be removed when you delete the dataset.


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 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 input 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.

Note: leave a data row empty to allow all users to access the data. If you put any emails in the data restriction column, only the users who have their email placed in the row will see that data in Marq. 

(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!

Smart field application

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.


FAQ

Why is my data sheet not showing in the left panel when I edit a project?
  1. Double check that your dataset is set to display in the editor.
  2. Navigate to the Marq home page. Click the “Data Automation” tab in the left panel. A window will open. Make sure the option “Show tab in editor” is enabled.
How often will the data sync with Marq?
This depends on what data source you have connected. Google Sheets will sync with Marq at least once or more per day.

MLS and Zillow will vary depending on when they push their data. Marq will attempt to sync once a day, but it depends on their system when the data can be retrieved.
Why is my data source not updating?
If you click the "Update Dataset Button" and get an error, it might mean that the Google Sheet is not shared with you. You must have access to the Google Sheet in order to update it in Marq. You must also be an admin on the Marq account.
Can I add my own custom icon?
This is a great idea! We want to add more icons in the future. Please reach out to support@Marq.com with ideas of icons to add.
Can I add more than one data source to one dataset?
Yes, you can add more than one data source to one dataset. However, all the columns must be the exact same in every data source for it to work. Also, it is important to note that all sources will be combined when you view the data in Marq.

Having more than one data source can be useful. For example, you can have a Google Sheet for each office. They can add additonal data to the Google Sheet, but they don't need to see all the info from the other offices. In Marq, the data would then combine.
Can I delete datasets/sources?
You should be extra careful before deleting datasets. If you delete a dataset, all your smart fields will be disconnected (they won't work anymore). Even if you connect the same Google Sheet or XML feed, the smart fields will not work and you'll need to reconnect them.

You can delete data sources. For example, if you connected the wrong Google Sheet/XML feed, you can remove it without affecting your smart fields (as long as the columns are the exact same as your smart fields).c