Issues while creating audicences | Community
Skip to main content
SaraBurns
New Participant
May 23, 2023 10:21 AM UTC
Solved

Issues while creating audicences

Hello community!

 

I need to create an audicence of people who have orderder something in the last 12 months. The requirements are the following ones:


- Ordered in the last 12 months
- Divided by Country
- Subscription Line: Magento

Firstly, I tried to do it with Country/Region: Hong Kong - the count gives me 0.

Thanks a lot,

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
david--garcia
david--garciaAccepted solution
Level 10
May 23, 2023 1:30 PM UTC

Is better if you start by querying all profiles that exist in orders table such as orderdate is in the last 12 months, then in additional data you need to add the country, subscription line as attributes, then segment in your worklow by country so you can create multiple audiences in the same workflow.

View reply

4 replies

aggabhi
Level 5
Jun 11, 2023 10:46 AM UTC

Hi @saraburns 

You have to simply create a query and filter people who have order date >= current date - 1 year and and Subscription Line: Magento and adding county in additional data field.

Also you have to use groupby collection on country as you have to groupby on country.

Hope it helps.

Regards

Abhishek

Translate
    Sukrity_Wadhwa
    Sukrity_Wadhwa
    Employee
    Jun 7, 2023 9:31 AM UTC

    Hi @saraburns,

    Were you able to resolve this query with the help of the given solutions or do you still need more help here? Do let us know. In case the given solutions were helpful, then kindly choose the one that helped you the most as the 'Correct Reply'.
    Thanks!

    Translate
    Sukrity Wadhwa
    bisswang
    Employee
    May 26, 2023 1:56 PM UTC

    Hi Sara,

     

    you should create the query step by step and check the counts.

    Also you should check if you have access to the HK Organization Unit, as that might be a case you don't see any result

    Translate
      david--garcia
      david--garciaAccepted solution
      Level 10
      May 23, 2023 1:30 PM UTC

      Is better if you start by querying all profiles that exist in orders table such as orderdate is in the last 12 months, then in additional data you need to add the country, subscription line as attributes, then segment in your worklow by country so you can create multiple audiences in the same workflow.

      Translate
        Terms & ConditionsAccessibility statement

        Loading footer...