Jim precisa criar um conjunto de filtros de dados com base em países, cidades e estados.
No Campaign, as tabelas de cliente já foram mapeadas e os níveis de audiência foram definidos.
![]()
nome da classe do driver JDBC – com.microsoft.sqlserver.jdbc.SQLServerDriver
![]()
caminho do driver JDBC – C:\tools\Java\MsJdbc\sqljdbc.jar
Um conjunto finito de estados distintos (ou regiões nomeadas de outra forma, dependendo do país)
![]()
O hh_id field corresponde à audiência familiar.
![]()
O campo indiv_id na tabela Geographic corresponde à audiência individual.Jim agora está pronto para criar o XML.
<!-- Create the data configuration that groups related Data Filters -->
<ExecuteBatch>
<name>DataFilters</name>
<operations>
<AddDataConfiguration>
<dataConfiguration>
<id>1</id>
<name>
Geographic</name>
</dataConfiguration>
</AddDataConfiguration>
</operations>
</ExecuteBatch><!-- Add logical fields used to define data filters -->
<AddLogicalFields>
<logicalFields>
<LogicalField>
<id>1</id>
<name>
Country</name>
<type>
java.lang.String</type>
</LogicalField>
<LogicalField>
<id>2</id>
<name>
City</name>
<type>
java.lang.String</type>
</LogicalField>
<LogicalField>
<id>3</id>
<name>
State</name>
<type>
java.lang.String</type>
</LogicalField>
<LogicalField>
<id>4</id>
<name>
HouseholdID</name>
<type>
java.lang.Long</type>
</LogicalField>
<LogicalField>
<id>5</id>
<name>
IndividualID</name>
<type>
java.lang.Long</type>
</LogicalField>
</logicalFields>
</AddLogicalFields><!-- Provide information needed to generate data filters -->
<GenerateDataFilters>
<!-- Specify the table to be scanned for unique combinations of values from which data filters will be defined. -->
<tableName>
Geographic</tableName>
<!-- Identify the data configuration with which generated data filters will be associated. -->
<configurationName>
Geographic</configurationName>
<!-- Specify the data source connection information. -->
<jdbcUrl>
jdbc:sqlserver://localhost:1433;databaseName=Customers</jdbcUrl>
<jdbcUser>
sa</jdbcUser>
<jdbcPassword>
myPassword</jdbcPassword>
<jdbcDriverClass>
com.microsoft.sqlserver.jdbc.SQLServerDriver</jdbcDriverClass>
<jdbcDriverClassPath>
<string>
C:\tools\Java\MsJdbc\sqljdbc.jar</string>
</jdbcDriverClassPath><!-- Specify the fixed fields. -->
<fixedFields>
<FixedField>
<expression>
USA</expression>
<logicalFieldName>
Country</logicalFieldName>
<physicalFieldName>
country</physicalFieldName>
</FixedField>
</fixedFields>
<fixedFields>
<FixedField>
<expression>
France</expression>
<logicalFieldName>
Country</logicalFieldName>
<physicalFieldName>
country</physicalFieldName>
</FixedField>
</fixedFields>
<fixedFields>
<FixedField>
<expression>
Britain</expression>
<logicalFieldName>
Country</logicalFieldName>
<physicalFieldName>
country</physicalFieldName>
</FixedField>
</fixedFields><!-- Specify the profile fields. -->
<profileFields>
<ProfileField>
<logicalFieldName>
State</logicalFieldName>
<physicalFieldName>
state</physicalFieldName>
</ProfileField>
<ProfileField>
<logicalFieldName>
City</logicalFieldName>
<physicalFieldName>
city</physicalFieldName>
</ProfileField>
</profileFields>
</GenerateDataFilters><!-- Map physical to logical fields -->
<ExecuteBatch>
<name>addTables</name>
<operations>
<AddDataTable>
<dataTable>
<id>1</id>
<name>
Geographic</name>
<fields>
<TableField>
<name>
country</name>
<logicalFieldId>1</logicalFieldId>
</TableField>
<TableField>
<name>
city</name>
<logicalFieldId>2</logicalFieldId>
</TableField>
<TableField>
<name>
state</name>
<logicalFieldId>3</logicalFieldId>
</TableField>
<TableField>
<name>
hh_id</name>
<logicalFieldId>4</logicalFieldId>
</TableField>
<TableField>
<name>
indiv_id</name>
<logicalFieldId>5</logicalFieldId>
</TableField>
</fields>
</dataTable>
</AddDataTable>
</operations>
</ExecuteBatch><!--Add Audiences-->
<ExecuteBatch>
<name>addAudiences</name>
<operations>
<AddAudience>
<audience>
<id>1</id>
<name>
household</name>
<fields>
<AudienceField>
<logicalFieldId>4</logicalFieldId>
<fieldOrder>0</fieldOrder>
</AudienceField>
</fields>
</audience>
</AddAudience>
<AddAudience>
<audience>
<id>2</id>
<name>
individual</name>
<fields>
<AudienceField>
<logicalFieldId>5</logicalFieldId>
<fieldOrder>0</fieldOrder>
</AudienceField>
</fields>
</audience>
</AddAudience>
</operations>
</ExecuteBatch>Jim nomeou seu arquivo XML de filtro de dados como geographicDataFilters.xml e o salvou no diretório tools/bin na sua instalação do Marketing Platform. Ele abre uma janela de comando e usa o utilitário datafilteringScriptTool para popular as tabelas de sistema de filtro de dados.
Ele sabe que grupos já foram definidos no Marketing Platform com usuários atribuídos por cidade.
Ele continua a executar pesquisas por filtro de dados e grupos até concluir todas as atribuições.
IBM Unica Marketing Platform
8.5.0
|
Copyright IBM Corporation 2011. All Rights Reserved.
|
For more information, see our support and community site: Customer Central
|
|