Creating a Content Collection

A great feature Sendlio has to offer is the ability to create dynamnic content collections. When you create an content collection, Sendlio connects directly to your data using a Data Source and compiled the content for each recipient at send time, meaning your content is dynamic always up to date.

To create a new content collection:

  1. Go to "Content" in Sendlio from the main navigation
  2. Click the "Add Content" button at the top of the screen
  3. Enter a name for your content collection
  4. Choose the data source where the content data is stored

Next, you have two options on how to build your content collection. You can either use the visual query builder or you can write a raw SQL query yourself.

Visual Query Builder

The visual query builder lets you create content collections without coding. The SQL used for the query is generated behind the scenes by Sendlio. This is the ideal method if your content query is fairly basic or if you don't have experience with writing SQL queries.

To create a content collection with the query builder:

  1. Select the database table you'd like to use (your list will be different and based on your database's structure)

screenshot

  1. Click the '+' icon to add a clause

screenshot

When setting up your clauses, you can select a column fromm the database table, an operator, and a value. In the example above, we are pulling all articles from our blog created in the past 7 days. Since we are referencing a time, we check off the "Time" checkbox to tell Sendlio to convert that value into a timestamp.

Examples of Valid Time Values

  • now
  • 10 September 2000
  • +1 day
  • +1 week
  • +1 week 2 days 4 hours 2 seconds
  • next Thursday
  • last Monday
  • first day of next month

If you are not using a time value, you can just enter a value in the box and it will be interpreted as a string.

  1. You can choose to sort or limit your results using the "Sort By" and "Limit" dropdowns.

Preview Your Results

When you create a content query in Sendlio, you can preview the number of results returned and a sample data set for that content on the left of the screen.

screenshot

Updating Content Collections

Once you're satisfied with your content collection, that's all you need to do. The collection will update as content data changes so you shouldn't need to change anything going forward unless you wanted to add or remove clauses to expand or reduce the content results size.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us