Issues while creating audicences | Community
Skip to main content
S
SaraBurns
May 23, 2023
Solved

Issues while creating audicences

  • May 23, 2023
  • 4 replies
  • 1529 views

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.
Best answer by david--garcia

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.

4 replies

david--garcia
david--garciaAccepted solution
Level 10
May 23, 2023

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.

    B
    Adobe Employee
    bisswangAdobe Employee
    Adobe Employee
    May 26, 2023

    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

      Sukrity_Wadhwa
      Community Manager
      Sukrity_WadhwaCommunity Manager
      Community Manager
      June 7, 2023

      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!

      Sukrity Wadhwa
      A
      aggabhi
      Level 5
      June 11, 2023

      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

        Terms & ConditionsAccessibility statement

        Loading footer...