Gears Blog
Informal, Informative, Deeply Technical, Implemented Solutions Written by Consultants

The Gears Blog is intended to be a place where our consultants can communicate the real-world solutions they are building. It has to be informal or no one would ever post. It has to be real life, day-to-day solutions where we explain the logic and rationale for what we did. Don’t judge, it might not be the best or the only solution, but it should be the kind of information you can use to take the solution to the next level. We hope that as the content evolves over time it becomes an accumulation of knowledge and a valuable resource for all.

 

  • Opportunities and Threats of Social Media Automation

    Social Media Automation
    The Advent of Messenger and Bots present both Opportunities and Threats This blog discusses the opportunities and threats of Social Media Automation. Automation of digital marketing efforts is not necessarily a new concept. For years, brands have been deploying email, web ads, and even direct mail distribution based on a customer’s status, place within a sales ...

    READ MORE >

  • The Past, Present and Future of Social Media in Business

    Social Media Automation
    Evolution of Social Media We’ll examine the past, present and future of Social Media in Business within this post. About 10 years ago, social media was evolving from an online fad to a daily part of our lives. Facebook was approaching 50 million active monthly users and would double that number by August 2008. Twitter was ...

    READ MORE >

  • IBM Marketing Operations can help you control Marketing. Best of all “it ain’t Rocket Science”

    Decentralized Operations are a necessity in today’s Marketing time compressed Web environment. Management of these operations can be a challenge. IBM Marketing Operations provides the power to enable a distributive work model while providing a system of record with flexibility to give not only visibility to, but when needed overall centralized control of, key components. Recently ...

    READ MORE >

  • High CPU usage after IBM Interact upgrade on AIX

    AIX IBM Interact 9.1.0 to 9.1.2 Upgrade issues: The client upgraded the IBM interact environment design and runtime from 9.1.0 to 9.1.2. Right after the upgrade the interact Runtime JVM started using the server cpu at 75% – 90% DispatcherCleanupInSecs and Slibclean: First you need to check the “dispatcherCleanupInSecs” value: Select numeric_value from USM_CONFIGURATION_VALUES where CONFIGURATION_ID = (SELECT max(ID) ...

    READ MORE >

  • IBM Campaign SQLONConnect Datasource Property Use Case with Oracle Database

    SQLONConnect Datasource Property date incompatibility issue End users are experiencing a SQLONConnect Datasource Property date compatibility issue when using an Oracle Database. They are seeing a different date format than what is stored in the database when profiling date fields in campaign flowcharts. The business logic used to build campaign flowcharts relies heavily on date computation. This ...

    READ MORE >

  • Decoupling IBM Interact configuration from Interact API

    Decoupling IBM Interact API code and configuration allows for more robust design and accomodates configuration changes without changing code.   The IBM Interact API requires Interact configuration for getting offers and posting events.Tight coupling between the Interact API and configuration requires code changes whenever configuration changes. Decoupling the IBM Interact API code and configuration allows for more robust design ...

    READ MORE >

  • Super-User Tip: IBM Campaign Query Comments

    Question: How Do I Write IBM Campaign Query Comments? Have you experienced this? You are writing a query expression in an IBM Campaign Select Process, or a derived field, and you want to add a comment to your code. It seems like you should be able to, but you don’t know how! Answer:  IBM Campaign Query Comments Begin ...

    READ MORE >

  • Updating an IBM Marketing Operations Grid with a Large number of Rows

    IBM Marketing Operations (IMO) allows users to maintain marketing information like opportunity generation details in Grids. Using IBM Marketing Operations Grids and database functionality you can empower users to update hundreds of thousands of rows quickly and easily without IT support. Over time the number of rows in a Grid can make routine maintenance challenging. ...

    READ MORE >

  • Track your Customer Interactions across all Touchpoints with Universal Behavior Exchange

    Track your customer interactions across all touchpoints in order to build a complete picture of your Customer’s Journey. Leverage client data systems that provide for a more holistic view of the customer. Then retarget with personalized and meaningful offers specific to the individual. RiverPoint empowers clients to increase conversion rates, drive brand loyalty and turn ...

    READ MORE >

  • Interact External Callout – Class Loading

    Interact External Callout – In my eyes, one of the most difficult parts of Interact is the External Callout. I’ve run into many issues with it, as it is very particular. There’s nothing wrong with that, but it can be a major pain for anyone trying to write Java code to communicate with another system or ...

    READ MORE >