Step-by-step Guide

1. Understand the Purpose:

• Before you start creating the Trivium Analytics Template, it's essential to understand its purpose, which is to set parameters and bit adjustments for optimizing bids on advertising campaigns.

2. Create a New Template:

• Open your preferred spreadsheet software (e.g., Microsoft Excel, Google Sheets).
• Start a new spreadsheet and label it "Trivium Analytics Template."

3. Define Click Thresholds:

• In your spreadsheet, create a section for Click Thresholds. These are the criteria based on the number of clicks before making bid adjustments.
• Label the columns as follows:
  • Click Range (e.g., 1-3, 4-7, 8+)
  • Bid Adjustment Percentage (e.g., -5%, -7%, -10%)
  • Threshold (usually set to 3 but can vary)
• Fill in the details according to the instructions provided in the transcript.

4. Define ACOS Ranges:

• Create a separate section for ACOS Ranges. These are used to adjust bids based on the Advertising Cost of Sale (ACOS).
• Label the columns as follows:
  • ACOS Range (e.g., 41-55%, 56-80%, 81-100%, 101-150%)
  • Bid Adjustment Percentage (e.g., -1%, -2%, -3%, -5%)
• Fill in the details based on the provided instructions.

5. Define Profitable ACOS Ranges:

• Create another section for Profitable ACOS Ranges. These are used to increase bids for keywords or product targets with good track records.
• Label the columns as follows:
  • ACOS Range (e.g., 31-33%, 26-30%, 21-25%, 16-20%)
  • Bid Adjustment Percentage (e.g., +1%, +2%, +2%, +3%)
• Fill in the details as per the transcript.