Why create an Company list using SQL? 

  • Account lists allow marketing managers and business analysts to filter reports by a set of company_ids.
  • If you utilize a BI Platform you can use your credentials to directly connect to your BigQuery database.
  • Sales leaders might want the attribution report to show only companies in a certain target list.

Step-by-Step Instructions

Navigate to the lists tab of CaliberMind.Click on the green circle button

    Fill in the Create List Dialog box

    1. Type a name
    2. Select ‘Custom’ from the drop-down list
    3. Click the blue OK button

      The SQL editor will open (Write the desired statements, test your query, and save within this section.)

        Sample query to get you started:

        SELECT company_id 

        FROM `cm.cm_company`

        WHERE industry like ‘Internet’ 

        LIMIT 10

        At the top left of your screen you will see a dark grey bar that says PREVIEW. Click this tab to open the table of results.

          When you are satisfied with the results click the green SAVE button to save the results of your new list.

            Your saved list will show a confirmation. A ‘Saved’ black bar will appear on the bottom left of your screen.

              Your Saved CaliberMind List Will Show a Confirmation