Level 3

Question

Analytics Classification data into CJA

Forum|Forum|10 months ago
March 22, 2025
3 replies
874 views

Hi Everyone,

Goal is don't use Adobe analytics source connector.

In Analytics, classification for campaign (v1).

Campain id (v1) - abc123
Delivery tool - ABC
Delivery Name - PLM

Need to impliment the classification in cja just like adobe analytics classification.

Here's my proposed approach. Please tell me if I'm missing any steps, making a mistake, or if there's a better way to achieve this.

Proposed Steps:

XDM Schema Creation:
○ Class: XDM Experience Event
○ Field Group: Adobe Analytics ExperienceEvent
○ Mapping: Map eVar1 to Campaign ID (v1) within the Adobe Analytics ExperienceEvent field group.

○ Question 1: I need to include "Delivery Tool" and "Delivery Name" in my XDM schema. Should I create a custom XDM field group for these classifications, or is there an existing field group I can leverage? If custom, what data type is recommended for each of these?

2. Dataset Creation: Create a dataset in AEP using the XDM schema defined in step 1.
3. Data Stream Configuration: Configure a data stream to send data from the dataset to CJA.
4. Lookup Creation (Mapping): In CJA, I would then create a lookup table to map the Campaign

○ Question 2: Lookup Mapping Details: Could you provide details on how to properly map the classification values (Campaign Id(v1), Delivery Tool, Delivery Name) using the lookup table in CJA? What fields do I need to map from the dataset to the lookup table and then to CJA dimensions?

• Question 3: By following the above steps, when user interactions with campaigns automatically flow into CJA and allow me to report on "Campaign Id(v1)", "Delivery Tool" and "Delivery Name" dimensions?

• Question 4: Ingesting Sample Data (Without Source Connector): If I want to insert example campaign interaction data directly into the AEP dataset (i.e., not using the Adobe Analytics Source Connector), what's the best method? (e.g., using the API, using a CSV upload, etc.) Are there any recommended tools or code examples for this?

Please clarify these points. Any help would be greatly appreciated!

Ankit_Chaudhary

Community Advisor

Hi @reddy_y-11

1. You don't need to add new field group for "Delivery Tool" and "Delivery Name" instead create a lookup schema.

create 2(Event and lookup) datasets based on the schemas.

You don't need DataStream to send data from AEP to CJA they are used to send data from source to Adobe services like AEP, AA, Target

2. Lookup Mapping Details: Create a relationship at schema level using the field evar1 with the lookup schema

check these for reference
Define a one-to-one relationship between two schemas

CJA lookups for lookup and profile data

3. Yes you can then leverage fields from both schemas and report on campaign data.

4. you can use CSV file to upload data in lookup dataset and API to add data in event dataset.

V

V_Raj_Reddy

Thanks for the reply.

Bit confusing here.

In the document link, created two XDM schema and adding relationship.

But you mentioned not required to create two XDM schema. Can you please explain bit more please.

Ankit_Chaudhary

Community Advisor

I've mentioned you don't need field groups in the same schema.
you need two schema an event schema and a lookup schema

John_Man

Community Advisor

Hi @reddy_y-11

Why would you use the AA field group and eVars etc if you are implementing CJA? Based on my experience the AA field group is for 1) Send data to AA using Web SDK and 2) send data from AA report suite to CJA using Adobe Source Connector with custom schema. Or this is an existing Web SDK to AA implementation and migrating to CJA?

Anyway, back to your lookup questions, below are the high level steps,

1) Create a custom schema class say call it Lookup, which is based on Record class. In my case, there is only 1 field called "Identifier" (can skip this step if Adobe have something out of the box now)

2) Create a new lookup schema based on step 1), and add extra attributes e.g. Name etc)

3) Create the lookup dataset based on 2)

4) Add the lookup dataset to the CJA Connection. The UI will ask for the type of data set to be added, for lookup data set, the UI will let you choose the ID field in the Event dataset, and also the matching key in the lookup dataset (which should be the Identifier), and also the lookup field to be returned e.g Name.

5) Add the field e.g. Name in Data View.

6) Upload sample/testing data to the lookup dataset, by using the Local Upload source connector with a CSV file

If you need to perform another lookup based on the same lookup dataset, you can use Derived Field and the Lookup function (as the same dataset can only be added to a Connection once).

Lookup on array field and return an array of Names is also supported which is very powerful.

Schema relationship seems has nothing to do with CJA (not 100% sure though).

Hope it helps.

John

gautham_madala

Level 5

You can do 2 approaches as per Ankit.
1) Setup relationships between schemas ( AA data, Lookup data( classification data) ) in the UI

2) Create 2 schemas, 1 for adobe another for classifications dataset and link these two in connections in CJA.

R

reddy_y-11Author

Level 3

Hi @ankit_chaudhary and @john_man

Please go through the below step by step guide. and correct me if I am missing any steps.

Step-by-Step Guide

Step 1: Create Lookup Schema (Classification)

1. Navigate to Schemas in AEP UI.

2. Click Create Schema.

3. Choose Custom Schema.

4. Assign a new or existing custom class (e.g., Campaign Classification class).

5. Add custom field group (e.g., Classification Campaign fields).

6. Add fields:

CampaignID (String)

DeliveryName (String)

DeliveryTool (String)

7. Mark CampaignID as the Primary Identity and assign a custom Identity Namespace (e.g., CampaignID).

8. Save schema as Campaign Classification Lookup.

Step 2: Create Experience Event Schema (Interaction)

1. Click Create Schema again.

2. Select Class: XDM ExperienceEvent.

3. Add Field Group: Campaign Delivery Logs.

4. Review fields such as:

campaignID

broadlogID

campaignName

channel

5. Go to campaignID field > enable Relationship.

6. Reference the lookup schema created in Step 1.

7. Save schema as Campaign Classification Interactions.

Step 3: Create Datasets

1. Lookup Dataset:

Go to Datasets > Create Dataset from Schema.

Choose Campaign Classification Lookup schema.

Name it Campaign Classification Lookup Dataset.

Ingest classification data (CSV provided).

2. Event Dataset:

Create another dataset from Campaign Classification Interactions schema.

Name it Campaign Interaction Events Dataset.

Ingest event-level data with campaignID matching the lookup.

Step 4: Ingest CSV Files

Prepare two separate CSV files:

1. Classification (for lookup dataset)

CampaignID,DeliveryName,DeliveryTool

CMP001,Summer Blast,Email

CMP002,Winter Promo,SMS

CMP003,Holiday Deal,Push

2. Interaction (for event dataset)

campaignID,broadlogID,campaignName,channel,controlGroupMember

CMP001,B001,Summer Campaign,Email,false

CMP002,B002,Winter Campaign,SMS,true

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded