How to compare conversion by price bracket | Community
Skip to main content
A
AC921
July 3, 2024
Question

How to compare conversion by price bracket

  • July 3, 2024
  • 1 reply
  • 470 views

Hello, 

 

I am comfortable comparing metrics, such as orders and AOV, by price brand using a segment.

For example between £30 and £1000: HIT Revenue is greater than or equal to £30 AND Revenue is less than £1000. 

 

However, this doesn't work for conversion as it shows at 100%+. Does anyone know how to compare conversion rate by price brand?

 

Many thanks

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
July 4, 2024

While I am not sure what sort of conversion you are looking for here, you should be able to do a calculated metric using nested IF statements and Greater Than or Equal To and Less Than or Equal To in order to form your "bucket"

 

Something like:

IF [

    Logical Test [

        Greater Than or Equal [

            Metric X - Revenue

            Metric Y - Static Number 30

        ]

    ]

    Value_if_True [

        IF [

            Logical Test [

                Less Than or Equal [

                     Metric X - Revenue

                     Metric Y - Static Number 1000

                 ]

            ]

            Value_if_True [

                Value That You Need Here (Not sure if this should be a 1 for a purchase in this bucket? Or something that makes more sense to your conversion)

            ]

            Value_if_False [

                 Static Number 0

            ]

        ]

    ]

    Value_if_False [

        Static Number 0

    ]

]

Terms & ConditionsAccessibility statement

Loading footer...