top of page

Sellozo Release Notes, June 2023

With this release, we are excited to introduce an enhanced version of Client Scripts, featuring a fresh user interface (UI). This new UI empowers users to easily create their script rules directly within the user interface itself. Additionally, we will continue to support the existing functionality where users can upload CSV files containing rule-based adjustments for their campaigns, ad groups, keywords, and targets. This ensures flexibility for users who prefer to utilize CSV files for their script rules. We are committed to providing a comprehensive and user-friendly experience for managing and implementing script rules in our platform.


Additionally, we streamlined the Repricer functionality, reduced database contention, and enhanced the availability of this dataset, ultimately improving overall performance.




New features

  1. Introducing a new user interface (UI) for Client Scripts

We are excited to introduce a new approach for users to generate script rules utilizing a new UI that can be applied to campaigns, ad groups, keywords, and targets. With our new user interface, users can now effortlessly create Script rules directly within the platform. This new interface aims to enhance the user experience by providing a seamless and intuitive process for creating script rules. For the user’s convenience, we have attached a comprehensive document at the top of this page, which offers detailed guidance on each field included on the page. Moreover, we have implemented multiple information bubbles for certain fields, ensuring users can easily grasp their functionalities without leaving the current page.


User Interface to create customized Script Rules


Following are the key-points that need to be considered while creating these rules:

  1. File Name can’t be left blank and it has to be more than 3 characters long.

  2. Choose the desired action type from the drop-down menu for which you want to create rules that will be applied to campaigns, ad groups, and keywords/targets.

    1. Action type available for adjusting bids on keywords/targets

      1. INCREASE_BID_BY_VALUE

      2. INCREASE_BID_BY_PERCENT

      3. DECREASE_BID_BY_VALUE

      4. DECREASE_BID_BY_PERCENT

      5. INCREASE_BID_BY_VALUE_RELATIVE_TO_CPC

      6. INCREASE_BID_BY_PERCENT_RELATIVE_TO_CPC

      7. DECREASE_BID_BY_VALUE_RELATIVE_TO_CPC

      8. DECREASE_BID_BY_PERCENT_RELATIVE_TO_CPC

      9. Lock Bid

      10. Unlock Bid

      11. SET_BID

      12. Set Bid to Ideal

    2. For creating and pausing keywords/targets

      1. Create Negative Exact - This will create a Negative Phrase Keyword or a Negative Exact Asin Target for any matching Keywords or Asins.

      2. Create Negative Broad - This will create a Negative Broad Keyword or a Negative Exact Asin Target for any matching Keywords or Asins.

      3. Pause Keyword - This will pause any matching Keywords.

      4. Pause target - This will pause any matching Targets.

      5. Pause Keyword or Target - This will pause any matching Keywords or Targets

    3. Available action types for Ad groups

      1. Pause Ad - This will pause any matching Ads.

      2. Create Ad - This will create a new Ad for the matching Asin. The purpose of this action is to create new Ads automatically for new products. You can filter which new products go into which ad groups by using the sku_regex and product_name_regex columns.

        1. For Example, if you wanted all product with the word "red" in the product name to be automatically created in a specific ad group you would specify:

          1. campaign_id: 123456

          2. ad_group_id: 67890

          3. product_name_regex: .*red.*

          4. action: CREATE_AD

  3. Action Value field can’t be left blank for following fields:

    1. INCREASE_BID_BY_VALUE

    2. INCREASE_BID_BY_PERCENT

    3. DECREASE_BID_BY_VALUE

    4. DECREASE_BID_BY_PERCENT

    5. INCREASE_BID_BY_VALUE_RELATIVE_TO_CPC

    6. INCREASE_BID_BY_PERCENT_RELATIVE_TO_CPC

    7. DECREASE_BID_BY_VALUE_RELATIVE_TO_CPC

    8. DECREASE_BID_BY_PERCENT_RELATIVE_TO_CPC

    9. SET_BID

    10. For other action types this field can be left blank

  4. metric_filter

    1. This field will filter entities by metric values so that you can execute actions on only the entities that have these specifications.

      1. Valid Metrics:

        1. conversions

        2. clicks

        3. spend

        4. sales

        5. acos

        6. has_no_ads

      2. Example metric filters:

        1. spend > 100 and conversions = 0

        2. ((spend > 100 and conversions = 0) or (clicks > 10 and acos > 80))

        3. has_no_ads

  5. You can choose if you want to apply the rule across all of your campaigns, selectively to specific campaigns. You can enter the campaign IDs for the campaigns where you wish to implement these script rules. Additionally, users have the option to search for campaigns based on their names or IDs.

  6. Similar options are also available for the ad groups field, allowing you to apply changes either to all ad groups or selectively to specific ones. Additionally, you have the ability to search for ad groups based on their names or IDs.

  7. Required Fields for Keyword and Target Actions

    1. ONE of the following must be specified for each rule:

  • keyword_id

    • Use this to specify an action to be executed on a specific keyword

  • search_term

    • Use this to specify and action to be execute on any entity with this specific search term

      • Example: hamster wheel

  • search_term_regex

    • Use this to specify a regular expression to match search terms - all matched search terms will have this action executed on them.

8. Optional Fields for Ad Actions

  1. Ad_id

    1. Match a specific Ad

  2. Sku_regex

    1. Match any Ads with a sku that matches this regular expression

  3. Product_name_regex

    1. Match any Ads with a product name that matches this regular expression

9. Optional Fields for All Actions

  1. Date_range

    1. Default Value: ALL

  • This specifies the time period over which we evaluate the filters. The following are valid entries:

    • ALL - This means use all available data

    • N - Any positive numeric integer can be specified. This will tell the system to look at that number of days back. For example, if you specified 30 the system will evaluate the most recent 30 days.

    • N-m - You can specify a range of days by specifying two integer values separated by a dash. For example, if you wanted to use the time period starting 30 days ago through 14 days ago you would specify: 14-30

    1. Days_between_action

      1. Default Value: 1.0.

      2. This specifies the number of days in between when an action may reoccur. For example, if you want to increase a bid every 7 days you could specify: 7.

      3. This field accepts decimal numbers so if you want an action to be eligible to happen every ½ day you could specify the value 0.5.

    2. Min_bid

      1. This field will prevent a bid on a Keyword or Target from going any lower than this number. If this number is not specified, the system will default to the normal Sellozo hierarchy of Minimum Bids in this order:

        • Keyword Min Bid

        • Ad Group Min Bid

        • Campaign Min Bid

        • Seller Profile Min Bid

c. Max_bid

  1. This field will prevent a bid on a Keyword or Target from going any higher than this number. If this number is not specified, the system will default to the normal Sellozo hierarchy of Maximum Bids in this order:

    • Keyword Max Bid

    • Ad Group Max Bid

    • Campaign Max Bid

    • Seller Profile Max Bid

d. Start_bid

  1. This field defines the starting bid for any new Keyword or Target. If this number is not specified, the Sellozo hierarchy of Minimum Bids will be used in this order:

    • Ad Group Min Bid

    • Campaign Min Bid

    • Seller Profile Min Bid

e. Limit

  1. Default Value: 100.

  2. This limits the number of actions that can take place for a single line.

  3. Valid numbers are anywhere from 1 to 100000.

Note: Regular expressions are search criteria that allow you to match text that contains certain elements.


Let's see what will happen once you created script rules on the UI:

  1. Once you have provided all the necessary details for the Script rules on the UI, you can proceed to click on 'Add To File.' This action will add the rule to the table on the page.

  2. To save the changes made, simply click on 'Save' within the table. This will create an inactive CSV file (see the attached screenshot below.)

  3. To ensure there are no errors within the file, users can perform a 'Dry Run.' This process allows for error detection in all available fields. Any identified errors will be reported back to the end-user (see the attached screenshot below.)

    1. You can run only one dry run at a time and it requires users to wait until the current dry run finishes before triggering another.

  4. At this point, users can choose to enable the file, making it 'Active.' Additionally, they have the option to manually initiate the script's execution by selecting 'Run' from the Action drop-down menu.

  5. Alternatively, users may opt to leave the active file to run automatically as scheduled by the system. The script will run between 7 am to 9 am CST.

Add script File to the Table and Save it for the Run



Available action items and log details



2. Make Rule-based adjustments to campaigns/ad groups, and other entities using a CSV upload

Sellers can upload a CSV file containing their advertisement rules adjustments. The CSV file has all the required fields to run and bid an ad, and sellers can fill up the information on their desired rules, then they can upload the CSV file. Here are the steps to follow for creating customized rules using a CSV upload:

  1. Download a template - Sellers can download the sample/template file where they can capture all their rule adjustments.

  2. Upload Rules CSV - Sellers can upload the updated CSV file from the local drive.

    1. Available actions on the uploaded CSV file - On the green action button, the user will have the option to check the log, Dry run, Run, Download template and Delete the file.

      1. View Log - It shows the action history details like when the last files were uploaded, when a particular rule came into effect, and errors encountered during the dry run, etc so that users can refer to that information

      2. Run - Users can initiate the script's execution by selecting 'Run' from the Action drop-down menu right away. They can also choose to leave the active file to run automatically as scheduled by the system between 7 am to 9 am CST.

      3. Dry Run - Sellers can dry run the uploaded CSV file for testing all the rules at once and check all the errors (if there are any).

        1. Errors in the CSV file (for all the fields available in the CSV) will be captured during the “dry run” or at runtime and will be reported back to the end-user

      4. Toggle Active - This will allow users to toggle the file Active/Inactive. Users also have the option to make inline edit on the file statuses.

      5. Download/Delete File - Users can download/delete any earlier uploaded files if they want to.


Some details on all the options that we have on this page:

  1. Search System log - Users have the ability to search for specific system logs based on their text content. They can utilize two different filters for refining their search:

    1. Include Text - By toggling this option, users can view system logs that contain the specified text. This filter allows them to focus on logs that specifically include the desired text.

    2. Exclude Text - This filter enables users to exclude logs that contain a particular text. By utilizing this option, users can conveniently review system logs while excluding those that contain the specified text.

  2. Date Range filter - The Date Range filter allows users to view logs within a specific period of time. It offers various predefined options for convenience such as; today, yesterday, last 7/30/90 days, the whole month or last month. By utilizing the Date Range filter, users can easily navigate and analyze logs within specific timeframes

  3. Newer - This feature functions similar to pagination on the page. When you choose the "last 30 days" option in the date range filter, the logs will initially display starting from the 30th day. By clicking on "Newer," the system will continuously fetch and show the latest results until reaching the current date.


3. Enhanced Repricer functionality to improve performance

We streamlined the repricer functionality, reduced database contention, and enhanced the availability of this dataset, ultimately improving overall performance.Notably, the repricer bulk functionality has also been improved, ensuring smoother and more efficient operations. In addition, we have made modifications to the ProductVu queries, enabling them to leverage this new functionality. This change has led to a remarkable increase in speed, further improving the user experience and productivity.


4. Implemented Notification message and limited accessibility in the app when SP-API is not authorized

Users will now see a notification message on the top of the page when SP-API is not authorized for that account. This will remind them to authorize SP-API connection so that they can gain access to features such as detailed financial reporting, product inventory and rankings, advanced campaign dayparting, automated product repricing, and more.


Notification message to remind users to authorize SP-API connection


5. Enhanced Profile page to include consolidated User Details and Authorization Status for SP-API Connection

We have made some additions to the 'Connected Marketplaces' section on the Profile page, including the introduction of new fields: 'Seller' and SP-API status toggle. In the 'Seller' column, you will find a list of all seller names and IDs associated with your account. The SP-API status toggle indicates whether the SP-API connection is authorized for each seller.

If the SP-API connection is authorized, the toggle will be enabled. If it is not authorized, clicking on the toggle will redirect users to the SP-API authorization page, which provides step-by-step instructions to authorize the connection.


Updated the ‘Connected Marketplaces’ section on the Profile page



Additional small enhancements and bug fixes:

  1. Add a new filter ‘Dayparting’ under the Action Type filter on the Activity Log page that will allow users to filter their search result to see the Dayparting updates.

  2. Added support in the Front end to display all the new financial event types.

  3. Enhanced Job Processing for a Seamless User Experience, Regardless of Job Size.

  4. Issue with Save Filter and Load filter set has been fixed.

  5. 'PUSH' button for updating bids in bulk on the Manage Targeting window is now functioning correctly.

  6. Issue with SB store spotlight video campaign not displaying targets in Sellozo has been fixed.


Upcoming Features:

  1. Amazon Budget Rules - We will be introducing a new feature within PPC Manager that will enable users to specify budget rules to their campaigns. This feature will provide effective ways to manage and optimize advertising budgets, and enhance the overall user experience. With budget rules, you can automatically increase your budget during specific time frames or when your campaign reaches certain performance targets. By using budget rules, you can keep top-performing campaigns running while preventing budgets from being wasted on underperforming ones. There are two types of budget rules: schedule-based rules and performance-based rules, which allow you to set budgets in advance for special events and increase your campaign budget when it meets a certain performance threshold, respectively.

  2. Walmart Advertising - Walmart Ad Beta will be available for our existing advertisers very soon. We’ve built a brand new tool for Walmart advertising that will let our advertisers launch their campaigns and our optimizer will help you drive sales, increase profitability, and lower your ACoS. Data-driven AI automatically optimizes your Walmart PPC ads to drive growth. Set your ACoS goals for each campaign, and Sellozo will optimize your ads to hit those goals.

  3. SB/SD Campaign Launch in Sellozo - We are thrilled to introduce the highly anticipated Sponsored Brand and Sponsored Display campaign launch flow in Sellozo. This new feature will enable users to launch these campaigns directly from Sellozo, providing greater convenience and efficiency.

Comments


bottom of page