Tables

What a table is#

Open Tables to see every table with its rows, columns, who fills it and its status (Working while a batch runs, Done once filled). A table’s toolbar has Search {n} rows, Filter (all rows, rows with a failed cell, rows still filling) and Hide columns, with what the table has spent so far.

Create a table#

Select New table, give it a Name and choose Start from:

Import a CSV#

1. 1

   Choose file

   Any size, as UTF-8 text; the first line names the columns. A file that isn’t UTF-8 is refused before anything is sent.

2. 2

   Match columns

   For each header, choose the column it fills, New column: {header}, or Don’t import. While the table is empty, Merge rows with the same (the email column by default) joins duplicates.

3. 3

   Check and import

   Check the first five rows, then select Import {n} rows. A large file goes in parts, in order.

File imported shows the lines read, rows added and merged, and every line left out with its reason, such as “Line 4, Work email: Not an email address”. If a part fails, importing again goes on from it.

Columns that do work#

Select Add column, give it a Name and Type (fixed once made), and choose Who fills it:

Run a column#

1. 1

   Choose Fill column

   From the column’s menu. A new column can also fill all rows straight after adding.

2. 2

   Choose the rows

   Only rows without a value (the default), or All rows, which replaces values already filled.

3. 3

   Set the budget and pace

   Stop at caps what the batch may spend, in credits while they pay for your work, otherwise in US dollars. Calls at once (1, 2, 5, 10 or 20) sets its pace.

4. 4

   Start it

   Select Run on {n} rows. The batch bar shows “{employee} is filling {column}”, the rows done, spend so far and about how long is left.

Use the batch bar to Pause, Resume, Raise budget (a budget only goes up) or Stop. Batches run on Royak, so closing the page doesn’t stop them.

A cell shows its value, or Queued, Working, Failed, Outcome unknown or Not found. Select it to see How it was filled: why, the source, when, the model, any decision and the cost.

Sending to rows#

A Sends column sends one message or action per row, through a connection the employee may write to. Set its Contact address (an email column), Sends a day, and optionally Send only when a column has one of its Ready values.

1. 1

   Choose Send rows

   From the column’s menu. The sheet shows how many rows will be sent, today’s sends against the daily limit, and the rows left out (already sent, not to contact, not ready, missing a value).

2. 2

   Check the exact rows

   The first 50 are listed with the address and every value they will be sent with.

3. 3

   Approve

   Set the Budget and select Approve and send {n} rows.

For a column you send from often, Give a standing approval for this column lets its batches run within caps you set; its first sample waits for you. See Standing approvals.

Do not contact (in the table’s More actions) holds addresses and domains no send column ever sends to, each with why. Export CSV downloads the table at any time.

Questions#