Search Marketing Campaign Data Upload

Service to upload marketing campaign data from various search engine vendors into the Oracle Fusion Marketing schema.

Life Cycle Status: Active

QName: {http://xmlns.oracle.com/oracle/apps/marketing/searchMarketing/model/}SearchMarketingModelService

Service WSDL URL: https://servername/crmService/SearchMarketingModelService?WSDL

Logical Business Objects

  • CRM : Marketing : Search Marketing Campaign

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Handles

Search Marketing Ad Group Result

Handles

Search Marketing Account Result

Handles

Search Marketing Keywords Result

Handles

Search Marketing Keyword Summary

Handles

Search Marketing Ad Result

Handles

Search Marketing Campaign Summary

Handles

Search Marketing Campaign Result

Handles

Search Marketing Ad Summary

Handles

Search Marketing Ad Group Summary

Operations

processCampaignSummaryReport

A web service method that uploads Campaign summary data from Google Adwords.

Life Cycle Status: Active

Request Payload

Element Name Type Description

request

Search Marketing Campaign Summary

A required parameter of the processCampaignSummaryReport web service method. The records matching the set of attribute criteria are transferred.

Response Payload

Element Name Type Description

result

string

The return value of the processCampaignSummaryReport web service method. It includes a set of Campaign ID's with appropriate status.

processAccountPerformanceReport

A web service method that uploads Account performance data from Google Adwords.

Life Cycle Status: Active

Request Payload

Element Name Type Description

request

Search Marketing Account Result

A required parameter of the processAccountPerformanceReport web service method. The records matching the set of attribute criteria are transferred.

Response Payload

Element Name Type Description

result

string

The return value of the processAccountPerformanceReport web service method. It includes a set of Connection ID's with appropriate status.

processCampaignPerformanceReport

A web service method that uploads Campaign performance data from Google Adwords.

Life Cycle Status: Active

Request Payload

Element Name Type Description

request

Search Marketing Campaign Result

A required parameter of the processCampaignPerformanceReport web service method. The records matching the set of attribute criteria are transferred.

Response Payload

Element Name Type Description

result

string

The return value of the processCampaignPerformanceReport web service method. It includes a set of Campaign ID's with appropriate status.

processAdGroupsSummaryReport

A web service method that uploads Ad-group summary data from Google Adwords.

Life Cycle Status: Active

Request Payload

Element Name Type Description

request

Search Marketing Ad Group Summary

A required parameter of the processAdGroupsSummaryReport web service method. The records matching the set of attribute criteria are transferred.

Response Payload

Element Name Type Description

result

string

The parameter is not applicable for the method processAdGroupsSummaryReport.

processAdGroupPerformanceReport

A web service method that uploads Ad-group performance data from Google Adwords.

Life Cycle Status: Active

Request Payload

Element Name Type Description

request

Search Marketing Ad Group Result

A required parameter of the processAdGroupsPerformanceReport web service method. The records matching the set of attribute criteria are transferred.

Response Payload

Element Name Type Description

result

string

The return value of the processAdGroupsPerformanceReport web service method. It includes a set of Ad-group ID's with appropriate status.

processAdsSummaryReport

A web service method that uploads Ads summary data from Google Adwords.

Life Cycle Status: Active

Request Payload

Element Name Type Description

request

Search Marketing Ad Summary

A required parameter of the processAdsSummaryReport web service method. The records matching the set of attribute criteria are transferred.

Response Payload

Element Name Type Description

result

string

The return value of the processAdsSummaryReport web service method. It includes a set of Ad ID's with appropriate status.

processAdPerformanceReport

A web service method that uploads Ads performance data from Google Adwords.

Life Cycle Status: Active

Request Payload

Element Name Type Description

request

Search Marketing Ad Result

A required parameter of the processAdPerformanceReport web service method. The records matching the set of attribute criteria are transferred.

Response Payload

Element Name Type Description

result

string

The return value of the processAdPerformanceReport web service method. It includes a set of Ad ID's with appropriate status.

processKeywordsSummaryReport

A web service method that uploads keywords summary data from Google Adwords.

Life Cycle Status: Active

Request Payload

Element Name Type Description

request

Search Marketing Keyword Summary

A required parameter of the processKeywordsSummaryReport web service method. The records matching the set of attribute criteria are transferred.

Response Payload

Element Name Type Description

result

string

The return value of the processKeywordsSummaryReport web service method. It includes a set of Keyword ID's with appropriate status.

processKeywordPerformanceReport

A web service method that uploads keyword performance data from Google Adwords.

Life Cycle Status: Active

Request Payload

Element Name Type Description

request

Search Marketing Keywords Result

A required parameter of the processKeywordPerformanceReport web service method. The records matching the set of attribute criteria are transferred.

Response Payload

Element Name Type Description

result

string

The return value of the processKeywordPerformanceReport web service method. It includes a set of Keyword ID's with appropriate status.

processWebToLead

A web service method that allows creation of Oracle Fusion Lead Object.

Life Cycle Status: Active

Request Payload

Element Name Type Description

firstName

string

A required parameter of the processWebToLead web service method. The first name captures personal information of the generated lead.

lastName

string

An optional parameter of the processWebToLead web service method. The last name is part of the personal details of the generated lead.

emailAddress

string

An optional parameter of the processWebToLead web service method. The email address captures specific contact information of the generated lead.

phoneNumber

string

A required parameter of the processWebToLead web service method. The phone number captures specific contact information of the generated lead.

address1

string

An optional parameter of the processWebToLead web service method. The street address captures specific location information of the generated lead.

address2

string

An optional parameter of the processWebToLead web service method. The extended address captures specific location information of the generated lead.

city

string

An optional parameter of the processWebToLead Web Service. The city captures specific location information of the generated lead.

state

string

An optional parameter of the processWebToLead web service method. The state captures specific location information of the generated lead.

zip

string

An optional parameter of the processWebToLead web service method. The zip code captures specific location information of the generated lead.

country

string

An optional parameter of the processWebToLead web service method. The country captures specific location information of the generated lead.

fusionPartyId

string

A required parameter of the processWebToLead web service method. The party ID captures party information of the generated lead.

fusionContactId

string

A required parameter of the processWebToLead web service method. The contact ID captures contact information of the generated lead.

fusionRelationshipId

string

A required parameter of the processWebToLead web service method. The relationship ID captures relationship information of the generated lead.

semCampaignId

string

A required parameter of the processWebToLead web service method. The campaign ID defines the relationship between generated lead & campaign.

semAdgroupId

string

An optional parameter of the processWebToLead web service method. The ad group ID defines the relationship between ad group & generated lead.

semKeywords

string

An optional parameter of the processWebToLead web service method. This captures the keywords associated with the campaign.

Response Payload

Element Name Type Description

result

void

The parameter is not applicable for the method processWebToLead.

getDfltObjAttrHints

A web service method to retrieve user interface hints, such as the service data object label and object attribute labels, for the specified service data object and locale. As a prerequisite, invoke the getEntityList operation defined on this service to get the list of possible values for the viewName request payload element.

Life Cycle Status: Active

Request Payload

Element Name Type Description

viewName

string

The service view usage name, an internal name for the service data object. Specify the value of the <name> element from the getEntityList operation response payload.

localeName

string

The locale to use when evaluating locale-based user interface hints. The localeName is in ISO 639-1 format.

Response Payload

Element Name Type Description

result

{http://xmlns.oracle.com/adf/svc/types/}ObjAttrHints

The label and user interface hints for the specified service data object and its attributes in a name-value pair format.

getServiceLastUpdateTime

A web service method that returns the date and time when the schema files referenced in the service definition last changed.

Life Cycle Status: Active

Request Payload

Response Payload

Element Name Type Description

result

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date and time when the service definition last changed in ISO 8601 format.

getEntityList

A web service method to get the list of service data objects defined on this service.

Life Cycle Status: Active

Request Payload

Response Payload

Element Name Type Description

result

{http://xmlns.oracle.com/adf/svc/types/}ServiceViewInfo

A list of service data objects defined on this service. For each service data object, the result includes the QName, internal name, and boolean values indicating whether create, update, merge, and delete operations can be performed on the object.

Security

The following tables list the privileges required to perform the service operations, and the duty roles that each privilege is granted to.

Service Operations to Privileges Mapping

Operation Name Privilege Code Privilege Name Privilege Description

All Operations

MKT_RUN_SEARCH_MARKETING_CAMPAIGN_SCHEDULER_PRIV

Run Search Marketing Campaign Scheduler

Allows scheduling and monitoring the process that schedules marketing search engine campaign execution activities.

All Operations

MKT_CREATE_SEARCH_MARKETING_CAMPAIGN_PRIV

Create Search Marketing Campaign

Allows creating search engine marketing campaigns.

All Operations

MKT_VIEW_SEARCH_MARKETING_CAMPAIGN_PRIV

View Search Marketing Campaign

Allows viewing search engine campaigns and monitoring results.

Privileges to Duty Roles Mapping

Privilege Code Granted to Duty Role Code Granted to Duty Role Name Granted To Duty Role Description

MKT_RUN_SEARCH_MARKETING_CAMPAIGN_SCHEDULER_PRIV

ORA_MKT_MARKETING_MANAGER_JOB

Marketing Manager

Coordinates marketing messaging content, pricing, segmentation, communication channels, and launch activities for marketing campaigns. Contributes to sales lead pipeline process and estimations, product definitions, and return on investment calculations.

MKT_RUN_SEARCH_MARKETING_CAMPAIGN_SCHEDULER_PRIV

ORA_MKT_CORPORATE_MARKETING_MANAGER_JOB

Corporate Marketing Manager

Develops and executes marketing strategies, translating customer needs from varied industries and markets into clear value propositions and actionable marketing programs. Communicates the corporate marketing message, manages the corporate marketing budget for allocation to marketing activities, and follows through the complete marketing life cycle to measure results.

MKT_RUN_SEARCH_MARKETING_CAMPAIGN_SCHEDULER_PRIV

ORA_MKT_MARKETING_OPERATIONS_MANAGER_JOB

Marketing Operations Manager

Manages the operations for marketing and leads. Develops tactical campaigns to carry out marketing strategies and communicate offers to customer segments using multiple marketing channels. Monitors campaign interactions, captures campaign responses, and manages sales leads to fill the sales pipeline. Creates and maintains the setup for marketing campaigns, responses, segments, lists, and treatments.

MKT_CREATE_SEARCH_MARKETING_CAMPAIGN_PRIV

ORA_MKT_MARKETING_MANAGER_JOB

Marketing Manager

Coordinates marketing messaging content, pricing, segmentation, communication channels, and launch activities for marketing campaigns. Contributes to sales lead pipeline process and estimations, product definitions, and return on investment calculations.

MKT_CREATE_SEARCH_MARKETING_CAMPAIGN_PRIV

ORA_MKT_CORPORATE_MARKETING_MANAGER_JOB

Corporate Marketing Manager

Develops and executes marketing strategies, translating customer needs from varied industries and markets into clear value propositions and actionable marketing programs. Communicates the corporate marketing message, manages the corporate marketing budget for allocation to marketing activities, and follows through the complete marketing life cycle to measure results.

MKT_CREATE_SEARCH_MARKETING_CAMPAIGN_PRIV

ORA_MKT_MARKETING_OPERATIONS_MANAGER_JOB

Marketing Operations Manager

Manages the operations for marketing and leads. Develops tactical campaigns to carry out marketing strategies and communicate offers to customer segments using multiple marketing channels. Monitors campaign interactions, captures campaign responses, and manages sales leads to fill the sales pipeline. Creates and maintains the setup for marketing campaigns, responses, segments, lists, and treatments.

MKT_VIEW_SEARCH_MARKETING_CAMPAIGN_PRIV

ORA_MKT_MARKETING_MANAGER_JOB

Marketing Manager

Coordinates marketing messaging content, pricing, segmentation, communication channels, and launch activities for marketing campaigns. Contributes to sales lead pipeline process and estimations, product definitions, and return on investment calculations.

MKT_VIEW_SEARCH_MARKETING_CAMPAIGN_PRIV

ORA_MKT_CORPORATE_MARKETING_MANAGER_JOB

Corporate Marketing Manager

Develops and executes marketing strategies, translating customer needs from varied industries and markets into clear value propositions and actionable marketing programs. Communicates the corporate marketing message, manages the corporate marketing budget for allocation to marketing activities, and follows through the complete marketing life cycle to measure results.

MKT_VIEW_SEARCH_MARKETING_CAMPAIGN_PRIV

ORA_MKT_MARKETING_OPERATIONS_MANAGER_JOB

Marketing Operations Manager

Manages the operations for marketing and leads. Develops tactical campaigns to carry out marketing strategies and communicate offers to customer segments using multiple marketing channels. Monitors campaign interactions, captures campaign responses, and manages sales leads to fill the sales pipeline. Creates and maintains the setup for marketing campaigns, responses, segments, lists, and treatments.

Duty Roles to Duty or Job Roles Mapping

Duty Role Code Granted to Duty or Job Role Code Granted to Duty or Job Role Name Granted To Duty or Job Role Description

ORA_MKT_MARKETING_OPERATIONS_MANAGER_JOB

ORA_ZCA_ACCESS_GROUPS_ENABLEMENT_DUTY

Access Groups Enablement

Enables the Access Groups functionality.

ORA_MKT_MARKETING_MANAGER_JOB

ORA_ZCA_ACCESS_GROUPS_ENABLEMENT_DUTY

Access Groups Enablement

Enables the Access Groups functionality.

ORA_MKT_CORPORATE_MARKETING_MANAGER_JOB

ORA_ZCA_ACCESS_GROUPS_ENABLEMENT_DUTY

Access Groups Enablement

Enables the Access Groups functionality.

ORA_MKT_MARKETING_OPERATIONS_MANAGER_JOB

ORA_MKL_LEAD_REGISTRATION_PROCESSING_DUTY

Lead Registration Processing

Reviews, accepts, and rejects sales lead registrations. Includes the ability to view sales lead details and update internal attributes.

ORA_MKT_MARKETING_MANAGER_JOB

ORA_MKL_LEAD_REGISTRATION_PROCESSING_DUTY

Lead Registration Processing

Reviews, accepts, and rejects sales lead registrations. Includes the ability to view sales lead details and update internal attributes.

ORA_MKT_CORPORATE_MARKETING_MANAGER_JOB

ORA_MKL_LEAD_REGISTRATION_PROCESSING_DUTY

Lead Registration Processing

Reviews, accepts, and rejects sales lead registrations. Includes the ability to view sales lead details and update internal attributes.

ORA_MKT_MARKETING_OPERATIONS_MANAGER_JOB

ORA_MKT_MARKETING_ANALYSIS_DUTY

Marketing Analysis

Analyzes marketing effectiveness across the enterprise by viewing detailed marketing campaign, list, segment, and treatment information from the audience and campaign work areas.

ORA_MKT_CORPORATE_MARKETING_MANAGER_JOB

ORA_MKT_MARKETING_ANALYSIS_DUTY

Marketing Analysis

Analyzes marketing effectiveness across the enterprise by viewing detailed marketing campaign, list, segment, and treatment information from the audience and campaign work areas.

ORA_MKT_MARKETING_OPERATIONS_MANAGER_JOB

ORA_MKT_MARKETING_AUDIENCE_MANAGEMENT_DUTY

Marketing Audience Management

Manages marketing lists from the audience work area. Marketing lists contain contacts and are used by marketing campaigns as the intended recipients of marketing messages.

ORA_MKT_MARKETING_MANAGER_JOB

ORA_MKT_MARKETING_AUDIENCE_MANAGEMENT_DUTY

Marketing Audience Management

Manages marketing lists from the audience work area. Marketing lists contain contacts and are used by marketing campaigns as the intended recipients of marketing messages.

ORA_MKT_MARKETING_OPERATIONS_MANAGER_JOB

ORA_MKT_MARKETING_CAMPAIGN_MANAGEMENT_DUTY

Marketing Campaign Management

Manages secured marketing campaigns from planning to design and execution. Defines and maintains secured marketing treatments, lists, segments, and content.

ORA_MKT_MARKETING_MANAGER_JOB

ORA_MKT_MARKETING_CAMPAIGN_MANAGEMENT_DUTY

Marketing Campaign Management

Manages secured marketing campaigns from planning to design and execution. Defines and maintains secured marketing treatments, lists, segments, and content.

ORA_MKT_CORPORATE_MARKETING_MANAGER_JOB

ORA_MKT_MARKETING_CAMPAIGN_MANAGEMENT_DUTY

Marketing Campaign Management

Manages secured marketing campaigns from planning to design and execution. Defines and maintains secured marketing treatments, lists, segments, and content.

ORA_MKT_MARKETING_OPERATIONS_MANAGER_JOB

ORA_MKT_MARKETING_EXECUTION_MANAGEMENT_DUTY

Marketing Execution Management

Manages the execution of secured marketing campaigns. Manages secured marketing responses including response import and converting responses to sales leads and opportunities. Schedules and monitors processes to record response interactions and create trading community members from suspects.Manages the execution of secured marketing campaigns. Manages secured marketing responses including response import and converting responses to sales leads and opportunities. Schedules and monitors processes to record response interactions and create trading community members from suspects.

ORA_MKT_MARKETING_OPERATIONS_MANAGER_JOB

ORA_MKT_MARKETING_MAINTENANCE_DUTY

Marketing Maintenance

Creates and maintains setup for marketing campaigns, responses, segments, lists, and treatments across the enterprise. Additional duties include file import management for the import of marketing campaign responses.

ORA_MKT_MARKETING_OPERATIONS_MANAGER_JOB

ORA_ZCM_MKTG_SALES_PARTY_MANAGEMENT_DUTY

Marketing Sales Party Management

Manages creation and maintenance of the sales organizations and consumers for internal marketing users. Additional duties include viewing of appointments, interactions, and customer contacts.

ORA_MKT_MARKETING_MANAGER_JOB

ORA_ZCM_MKTG_SALES_PARTY_MANAGEMENT_DUTY

Marketing Sales Party Management

Manages creation and maintenance of the sales organizations and consumers for internal marketing users. Additional duties include viewing of appointments, interactions, and customer contacts.

ORA_MKT_CORPORATE_MARKETING_MANAGER_JOB

ORA_ZCM_MKTG_SALES_PARTY_MANAGEMENT_DUTY

Marketing Sales Party Management

Manages creation and maintenance of the sales organizations and consumers for internal marketing users. Additional duties include viewing of appointments, interactions, and customer contacts.

ORA_MKT_MARKETING_OPERATIONS_MANAGER_JOB

ORA_ZSP_PRODUCT_RECOMMENDATION_ANALYSIS_DUTY

Product Recommendation Analysis

Manages business rules and recommendations about selling the right products to the right customers. Analyzes product recommendations and schedules sales lead generation and predictive model learning.

ORA_MKT_MARKETING_OPERATIONS_MANAGER_JOB

ORA_HZ_RESOURCE_ABSTRACT

Resource

Identifies the person as front office personnel.

ORA_MKT_MARKETING_MANAGER_JOB

ORA_HZ_RESOURCE_ABSTRACT

Resource

Identifies the person as front office personnel.

ORA_MKT_CORPORATE_MARKETING_MANAGER_JOB

ORA_HZ_RESOURCE_ABSTRACT

Resource

Identifies the person as front office personnel.

ORA_MKT_MARKETING_OPERATIONS_MANAGER_JOB

ORA_HZRESOURCE_ADMINISTRATOR_DUTY

Resource Administration

Administers resource information.

ORA_MKT_MARKETING_OPERATIONS_MANAGER_JOB

ORA_HZRESOURCE_ORGANIZATION_ADMINISTRATOR_DUTY

Resource Organization Administration

Administers resource organizations.

ORA_MKT_MARKETING_OPERATIONS_MANAGER_JOB

ORA_HZRESOURCE_TEAM_ADMINISTRATOR_DUTY

Resource Team Administration

Defines resource teams.

ORA_MKT_MARKETING_OPERATIONS_MANAGER_JOB

ORA_MKL_SALES_LEAD_PROCESSING_DUTY

Sales Lead Processing

Processes sales leads including managing, importing, and assigning sales lead activities.

ORA_MKT_MARKETING_MANAGER_JOB

ORA_MKL_SALES_LEAD_PROCESSING_DUTY

Sales Lead Processing

Processes sales leads including managing, importing, and assigning sales lead activities.

ORA_MKT_CORPORATE_MARKETING_MANAGER_JOB

ORA_MKL_SALES_LEAD_PROCESSING_DUTY

Sales Lead Processing

Processes sales leads including managing, importing, and assigning sales lead activities.

ORA_MKT_MARKETING_MANAGER_JOB

ORA_MKL_SALES_LEAD_QUALIFICATION_DUTY

Sales Lead Qualification

Qualifies sales leads to determine the sales readiness of the lead.

ORA_MKT_MARKETING_MANAGER_JOB

ORA_MKL_SALES_LEAD_QUALIFICATION_SUPERVISION_DUTY

Sales Lead Qualification Supervision

Qualifies sales leads to determine the sales readiness of all the leads in your reporting hierarchy.

ORA_MKT_MARKETING_OPERATIONS_MANAGER_JOB

ORA_ZCM_SALES_PARTY_ADMINISTRATION_DUTY

Sales Party Administration

Manages named sales accounts, sales account import scheduler and the flagging of existing accounts. Additional duties include managing sales parties, functional setups, customer center objects, and relationship information inquiries.

ORA_MKT_MARKETING_OPERATIONS_MANAGER_JOB

ORA_ZCM_SALES_PARTY_MANAGEMENT_DUTY

Sales Party Management

Manages creation and maintenance of the sales organizations and consumers for internal sales users. Additional duties include viewing of opportunities and opportunity revenue, reviewing sales leads as well as appointments, interactions, and customer contacts.

ORA_MKT_MARKETING_MANAGER_JOB

ORA_ZCM_SALES_PARTY_MANAGEMENT_DUTY

Sales Party Management

Manages creation and maintenance of the sales organizations and consumers for internal sales users. Additional duties include viewing of opportunities and opportunity revenue, reviewing sales leads as well as appointments, interactions, and customer contacts.

ORA_MKT_CORPORATE_MARKETING_MANAGER_JOB

ORA_ZCM_SALES_PARTY_MANAGEMENT_DUTY

Sales Party Management

Manages creation and maintenance of the sales organizations and consumers for internal sales users. Additional duties include viewing of opportunities and opportunity revenue, reviewing sales leads as well as appointments, interactions, and customer contacts.

ORA_MKT_MARKETING_OPERATIONS_MANAGER_JOB

ORA_MANAGE_TRADING_COMMUNITY_IMPORT_BATCH_DUTY

Trading Community Import Batch Management

Manages trading community data import batches.