adobe campaign database. To prevent any performance issue related to the high number of rows, only keep the necessary records in the database. adobe campaign database

 
 To prevent any performance issue related to the high number of rows, only keep the necessary records in the databaseadobe campaign database  In the Remote fields section, enter the

Once you set up the MySQL user account and define the site, you can connect to your MySQL database in Dreamweaver. Topics: Release Notes. The physical and logical structure of the data carried in the application is described in XML. Add the noDbIndex=“true” attribute in the link definition to prevent Adobe Campaign from creating an index on the values stored in the source table of the link. From Campaign Explorer, click Administration ‘>’ Platform ‘>’ External accounts. You can define Additional data for the targeted population via a dedicated tab. The following example lets you collect a file on the server every day, load its content and update the data in the database depending on the. Managed Services / Hosted. Technical workflows are configured via the Administration. Enter a Namespace and Name for the schema and select the External account which will enable connection to the database. To import data via the CRM in Adobe Campaign, you need to create the following type of workflow: Select an Import from the CRM operation. Campaign workflows. Upgrade to the latest build. Email Rendering: Includes 1,500 Email Renderings per year. 7. Read how to configure access to Hadoop with Adobe Campaign. Delivery Fundamentals: Included for new Campaign Customers only. In order to set up connections with external systems, you can create new external accounts. With Adobe Campaign, you can use rich customer data to create, coordinate, and deliver dynamic campaigns that customers actually want — through email, mobile, offline channels, and more. This service is designed to unlock new levels of scalability, ensuring that your notifications can reach a larger audience with seamless efficiency. Review and update data access permissions to help ensure users of Adobe Campaign can fully leverage only the data needed to run their. In the Mobile application properties section, two URLs are listed: Collect PII Endpoint and Campaign Tracking Endpoint. A Scheduler activity, to execute the workflow every Monday at 6 am. Database Containers. The Adobe Campaign query tool lets you query a database using a dedicated wizard: the generic query editor. For example, when querying the Profiles table, stored on the Cloud database, you will create a Working table on the. We use Package export wizard. Transactional Messaging: Transactional Messaging includes one Dedicated Server and functions with the following Channels: Email,SMS, and Mobile App. Importing data allows you to collect data to feed your Campaign’s database. From the ODBC Data Sources (64-bit) new window, click Add…. In this case, the Reconciliation tab lets you define the link between the data in the Adobe Campaign database and the data in the work table. Read this article here: PostgreSQL Bear in mind this will not work with ACS. The Query activity allows you to filter and extract a population of elements from the Adobe Campaign database. Example: Collecting data and loading it in the database. For performance reasons, the matching must be done in batch mode by a workflow. Only one channel can be used for each event configuration. The x, y and z characters must not be empty and must not include non-authorized characters. With Adobe Campaign, you can use rich customer data to create, coordinate, and deliver dynamic campaigns that customers actually want — through email, mobile, offline channels, and more. Click the Add data… and select the External data options. The PKey is the physical primary key of an Adobe Campaign table. Alternatively to Workflows, Adobe Campaign offers a simplified import function that allows the user to manage certain types of import that were defined by an administrator. Profile transactio. Recommendations. Adobe Campaign relies on a relational database containing tables that are linked together. Help center for the major features, tasks, settings, and other resources required to use Campaign Standard. Importing data allows you to collect data to feed your Campaign’s database. Courses Tutorials Certification Events Instructor-led training View all learning optionsSign In. Use external data in a workflow. These fields offer a button that opens a drop-down list to help you. The following information applies to Adobe Campaign Managed Cloud Services, unless indicated that such information only applies to a specific version; (either version 7 (v7) or version 8 (v8), as applicable). 3 “Instance” means the entirety of the binaries of the software combining to implement a unique Adobe Campaign database. It is accessed via the Tools > Generic query. In Adobe Campaign Standard, this value is not visible to the end user (except in URLs). Last update: 2023-09-07. Adobe Campaign includes a graphical module to define and publish Web applications. Workflow use cases: discover through these use cases. Above the list of jobs, click New import. Staging mechanism in a nutshell: Data schema structure is duplicated into the local staging table. Campaign v8. In the Edit tab, we need to configure the. Overview. Check if SQL Server Native Client v11 is listed in the Create New Data Source window. The operating principle is as follows: an administrator defines and. Adobe Campaign is a cross channel marketing solution that automates email, mobile, social and offline campaigns. Data is encrypted at rest on disk from access via the. Adobe. Add your Server URL and Database. Database Microsoft SQL Server. Products and versions that are not part of this list are not compatible with Adobe Campaign. Read more. Learn more in this section. Export the Adobe Campaign database to the external database and execute the operations only from the external database before re. Documentation. Select the Web form template ( newWebForm by default). If the SQL Server Native. View solution in original post. Experience Platform Integration. Enter the name of the server and provide the authentication parameters. To create a schema on an external database: Click the New button above the list of data schemas and choose Access external data. Select the activity, then open it using the button from the quick actions that. Note that tab contents may no longer be changed once the delivery has been sent. This allows you to target only new elements. Experience Cloud Advocates. com resources 1. The default value may also be one of the values defined in the enumeration. 2 About schema edition Adobe Campaign employs Data Schemas to: • Define how data objects within the application are tied to underlying database tables. Help center for the major features, tasks, settings, and other resources required to use Campaign Standard. The Adobe Campaign database is not designed to store historical data that are not actively used for targeting or personalization purpose - this is an operational database. A schema is an XML document associated with a database table. Learn more about the best practices to follow when importing data into the database. Create an External database external account in your execution instance with the following configuration: Label and Internal name: name your. Get Started with Campaign. The Adobe Campaign Standard integration with Microsoft Dynamics 365 self-service integration application gives you the ability to configure data flows, control whether or not they are running, and in which environment. Learn. Hi I'm having the same problem. Best practices. This data is stored in additional columns and can only be used for the workflow in progress. Drag and drop an incremental query to the workflow. Delivery Fundamentals: Included for new Campaign Customers only. If the SQL Server Native. Adobe Experience Cloud is a comprehensive set of best-in-class, integrated solutions built on a common data platform with a common set of powerful core services. An encrypted global suppression list is now managed in the deliverability instance to avoid being blacklisted due to malicious activity, especially the use of a Spamtrap. Alternatively to Workflows, Adobe Campaign offers a simplified import function that allows the user to manage certain types of import that were defined by an administrator. Method 1: Creating an OpenOffice document. Adobe Campaign carries out mass data updates, which may lead to some. Three namespaces are available out-of-the-box: email. An import is generally configured for reuse and can be scheduled that will occur automatically. To prevent any performance issue related to the high number of rows, only keep the necessary records in the database. In this case, the Reconciliation tab lets you define the link between the data in the Adobe Campaign database and the data in the work table. 6. To achieve this, following some of the best practices below may help. Select the target database engine in the drop-down list. Paid hours required for additional Affiliated brands of. To do this, these fields must be mapped to database fields. The Query activity allows you to filter and extract a population of elements from the Adobe Campaign database. Pass data from Campaign to Adobe Analytics, and use Analytics data directly in Campaign. The Transactions and Products resources used in this example do not exist in the Adobe Campaign database by default. Select External database as your external account’s Type. For more information on database maintenance, refer to. Use the config command of the nlserver executable file with the -setdblogin parameter. Each resources comes with associated filters, allowing you to navigate through the resources. . Adobe Campaign relies on a relational database containing tables that are linked together. Review and update data access permissions to help ensure users of Adobe Campaign can fully leverage only the data needed to run their. Workflows: import data. Campaign Classic. Right-click the newly created plan and select Create a new ‘Program’ folder. Any modification that was carried out directly in the database and not using custom resources will be deleted. They will then be added to the database. to reco. From Campaign Explorer, click Administration ‘>’ Platform ‘>’ External accounts. Description of the main tables. With Adobe Campaign, you can use rich customer data to create, coordinate, and deliver dynamic campaigns that customers actually want — through email, mobile, offline channels, and more. Customer data management. Experience LeagueThe DB platform usually handles the encryption and decryption of the data. The following example shows the configuration of an Update data activity following a Load file activity. It provides robust ETL and data management capabilities to help craft and curate the perfect campaign. The table. The physical and logical structure of the data carried in the application is described in XML. This package file contains a JavaScript entity that generates an Open Office document detailing the database schema of the Adobe Campaign instance. You can define here the characters authorized (‘data policy’) in the email field of the database. To select the recipients of a delivery, follow the steps below: In the delivery editor, select To. 9 - September 2017 release; 17. Adobe Campaign comes with a set of pre-defined external accounts. Last update: 2023-02-09 Topics: Data Model Created for: Experienced Developer To make your modifications to the data model effective and to be able to use them, the database structure needs to be updated. In the Adobe Campaign tree, they are grouped under the Resources > Online > Web Applications node. System updates are also performed through package imports. On instances ran or running on a impacted build, list tables are created in unlogged . Output Fields: Campaign Id, Campaign Label, Delivery Id, Delivery Label, Delivery Log Event Date, Status, Recipient Id, Scv Id. Data is stored in two separate locations: physical files are stored in the Adobe Campaign directories, other data is stored in the database. I needed some way to handle this data dynamically within the template. This user guide contains videos and tutorials on the many features and. Campaign staging capability is enabled by default on some built-in schemas. In the Adobe Campaign database, all email addresses must be created as follows: x@y. Create sub-sets - Use the Split activity to create sub-sets. This means that the underlying database will be frequently updated, leading to a degradation of performance over time. For example, the criteria for matching can be the shopper_id. To access the Adobe Campaign process monitoring page, browse to the Monitoring tab, and click the Overview link. Xml report). 6moAccelerate your Campaign learning with the Adobe Campaign Mentorship Program 2023! Apply Now. New APIs dedicated for data ingestion. Click New. User. In this example, we’re going to select the Breakdown by country report. Select the type of field you want to create: you can choose to add a field. Browse to Profiles and targets to access recipients stored in Adobe Campaign database. Collect the data from the external Adobe Campaign database and execute the operations locally. Duplicate the Email delivery (re-marketing) template or the re-marketing template examples offered. The calculation of the key value depends on a sequence (by default, the XtkNewId SQL function) generating a number that is unique in the entire database. Experience League. In the targeting and workflows tab of your campaign, update the workflow labeled in the welcome email, save and refresh your workflow. The following list contains only the tables most subject to fragmentation. Courses Tutorials Events Instructor-led training View all learning optionsCommunity home Advertising Analytics Audience Manager Campaign Classic v7 & Campaign v8 Campaign Standard Developer Experience Cloud Experience Manager Sites & More Experience Platform Journey Optimizer Target Real-Time Customer Data Platform Workfront Creative Cloud Document Cloud Commerce Marketo EngageCommunity home Advertising Analytics Audience Manager Campaign Classic v7 & Campaign v8 Campaign Standard Developer Experience Cloud Experience Manager Sites & More Experience Platform Journey Optimizer Target Real-Time Customer Data Platform Workfront Creative Cloud Document Cloud Commerce Marketo EngageWith Adobe Campaign, you can use rich customer data to create, coordinate, and deliver dynamic campaigns that customers actually want — through email, mobile, offline channels, and more. Adobe Campaign relies on a Cloud database containing tables that are linked together. Enhanced Push notification service. Review and update data access permissions to help ensure users of Adobe Campaign can fully leverage only the data needed to run their. . Click New. Hover the mouse over the message of your choice. Method 1: Creating an OpenOffice document. . With Adobe Campaign, you can use rich customer data to create, coordinate, and deliver dynamic campaigns that customers actually want — through email, mobile, offline channels, and more. The Database cleanup connects to the database and executes the tasks in the sequence shown below. The database administrator needs to allow write access to the tempdb database. Use data available in Adobe Campaign for the intent it was captured and give your recipients better personalized experiences. Paid hours required for additional Affiliated brands of. Characters not included in the list will be forbidden and. In the Adobe Campaign database, all email addresses must be created as follows: x@y. Up next. This unique entity is characterized by a group of parameter settings defined in a parameter definition table (table xtk_entity). Reconciliation is the process of matching the customer from Adobe Analytics into the Adobe Campaign database. The Adobe Campaign database is not designed to store historical data that are not actively used for targeting or personalization purpose - this is an operational database. 6/7/17 4:11:06 PM How does one track changes in Adobe Campaign's database? We upload batch files to Adobe Campaign's database each day. It checks whether the physical structure of the database. I have a V8 Sandbox, and in that I can see Microsoft SQL Server in the external database, which works with Azure SQL. Update the database structure to create the table which the schema will be linked to. Right-click the newly created plan and select Properties…. Adobe Campaign is a highly transactional system (OLTP database). Exporting reports. To create your Azure Synapse external account follow the steps below: From Campaign Explorer, click Administration ‘>’ Platform ‘>’ External accounts. Control the entire process of creating, executing, and tracking cross-channel campaigns, as well as send messages. Now viewing. Configure the PostgreSQL external account authentication: Server: URL of the PostgreSQL server. Using an existing database: choose this option if an empty database has already been created by your. Campaign workflows. 1 The primary key of most Adobe Campaign tables is a 32-bit long integer auto-generated by the database engine. Adobe Campaign provides the Federated Data Access (FDA) option in order to process information stored in one or more external databases: you can access external data without changing the structure of Adobe Campaign data. Mapping form fields. When you create a database, Adobe Campaign provides two different options: Creating or recycling a database: choose this options if you want to create a new database or re-use an existing one. Using the above settings, here are example settings for the MySQL Connection dialog box in Dreamweaver: Connection Name: Choose a name (such as connEmp) MySQL Server: mysql1. z. Re-extract or copy the contents of the installer. We can also enable it on any custom schema. . This object match with one of the tables created in Adobe Campaign during connector configuration. Solution. Ensure that the imported data is always “normalized” (email, phone number. Enter a Namespace and Name for the schema and select the External account which will enable connection to the database. Meet our community of customer advocates. The data used by Campaign is defined through different resources defined in a pre-defined data model. Try risk-free today. This is the ID of the mobile application configured in Adobe Campaign that will be. Most of the data is in the database. In the General tab, modify the Internal name to avoid duplicates during package exports. This includes functional data, like profiles, subscriptions and delivery content, technical data, like delivery logs and tracking logs, as well as metadata like internal and custom tables, fields and labels. ) by your Campaign Classic instances is limited. To create a Web form, click the Create button above the list of Web applications. "" or "default" points to the Neolane database "nms:extAccount:InternalName" points to a datasource defined in the Neolane external accounts (FDA) "name" (name of the datasource) points to a data source defined in the instance configuration file (config-instance. Scroll through the tree structure to get to the place you would like to create the form in your chosen website. The Reconciliation activity is essentially used for Data Management purposes and implies two different use cases: Adding relations: a Links tab allows you to add links between the inbound data and several other Adobe Campaign database dimensions. About workflows. Use data available in Adobe Campaign for the intent it was captured and give your recipients better personalized experiences. I have a V8 Sandbox, and in that I can see Microsoft SQL Server in the external database, which works with Azure SQL. Add your Server URL and Database. Process info stored in multiple. You can define Additional data for the targeted population via a dedicated tab. For example, the email channel allows you to perform A/B testing in order to test up to 3 versions of an email. You can select an existing list or create it. The operating system of the database server is not important so long as connectivity with the different components of Adobe Campaign is available. The PKey is the physical primary key of an Adobe Campaign table. Adobe Campaign offers a comprehensive graphical environment that allows you to design complex processes including segmentation, campaign execution, file processing, etc. Community home Advertising Analytics Audience Manager Campaign Classic v7 & Campaign v8 Campaign Standard Developer Experience Cloud Experience Manager Sites & More Experience Platform Journey Optimizer Target Real-Time Customer Data Platform Workfront Creative Cloud Document Cloud Commerce Marketo EngageIn Linux, OpenSSL must be installed. You need to be aware of the following limitations: The available channels for transactional messaging are: Email, Mobile (SMS) and Push notification. The data contained in the event itself is used to define the delivery target. Up Next: Creating a Simple Form in Adobe Campaign Classic | Back to Adobe Campaign Learn . Learn more. The marketing instance is a set of on-premise servers running Adobe Campaign services, and a relational database. Customer data management. Depending on the provider, optimizing performance for larger tables may require a specific design. Help center for the major features, tasks, settings, and other resources required to use Campaign Standard. Learn. To build the workflow, follow these steps: Drag and drop a Transfer file activity into your workflow. Keep the New text import template selected by default. The primary key of most Adobe Campaign tables is a 32-bit long integer auto-generated by the database engine. User. Learn key steps and best practices to perform a build upgrade. If one of these tasks fails, the next ones are not executed. In order to improve performance, ingestion APIs are redirected to the local database. With Adobe Campaign, you can use rich customer data to create, coordinate, and deliver dynamic campaigns that customers actually want — through email, mobile, offline channels, and more. The enrichment is performed in the same way as for a standard transactional message. Alternatively to Workflows, Adobe Campaign offers a simplified import function that allows the user to manage certain types of import that were defined by an administrator. Adobe Campaign Standard can also connect to Microsoft Dynamics 365 : this integration enables synchronization of all available Contact data in the CRM system, making all relevant Contact data available for campaign activities. Experience Cloud Advocates. Select External database as your external account’s Type. This identifier is usually unique to a specific Adobe Campaign instance. Learn how to manage privacy requests in Campaign. 0. An Instance may be one of two categories: Production orLearn how to create and execute recurring and periodic campaignsHello , thank you for your comments. This unique entity is characterized by a group of parameter settings defined in a parameter definition table (table xtk_entity ). It may not correspond to any profile from the Adobe Campaign database. 2. As a hosted or hybrid customer, contact Adobe to have a new built-in package deployed. ), the technical data (delivery jobs and logs, tracking logs, etc. Experience LeagueThere are advantages (more powerful to master all the underlying RDBMS possibilities such as specific indexing/primary key/sequences/storage properties), but drawback is the availability of direct RDBMS access (or your database administrator) so probably reserved for On Premise hosting configurations. Select the data to extract. PKey. The data used by Campaign is defined through different resources defined in a pre-defined data model. Then use the data from the temporary table to personalize your delivery. Sign In. It provides robust ETL and data management capabilities to help craft and curate the perfect campaign. Adobe Campaign relies on a relational database containing tables that are linked together. 3 “Instance” means the entirety of the binaries of Adobe Campaign software combined to implement a unique Adobe Campaign database. To change the period of time, use the filters available in the upper-right corner of the graph. Adobe Campaign carries out mass data updates, which may lead to some. This steps also allows you to select the segments to export and specify additional XDM fields to include. Connect your CRM with Campaign. With Adobe Campaign, you can use rich customer data to create, coordinate, and deliver dynamic campaigns that customers actually want — through email, mobile, offline channels, and more. If the SQL Server Native. This enables access to the list of tables available in the external base. Deploy connectors to CRM systems, such as Microsoft Dynamics, to align your internal marketing and sales efforts more closely, and give your entire company access to each prospect’s. The activity uses the query editor tool. Specify the label of the new audience. With Adobe Campaign, you can use rich customer data to create, coordinate, and deliver dynamic campaigns that customers actually want — through email, mobile, offline channels, and more. Schedule the delivery sending. The query editor is a wizard that allows you to filter data contained in the Adobe Campaign database. Each time this activity is executed, the results from the previous. Select the Locally defining the data source option. Ten best practices for Adobe Campaign success for marketers; Maximize email ROI and best practices for subscriber re-engagement; Deliverability best practice guideThe following example shows the configuration of an Incremental query activity which filters the profiles in the Adobe Campaign database that are subscribed to the Running Newsletter service, to send them a welcome email containing a promo code. name (string): internal name of the enumeration. Start by selecting the type of data to add: Select Data linked to the filtering dimension to select the data in the Adobe Campaign database. In Windows: net start nlserver6. Check if SQL Server Native Client v11 is listed in the Create New Data Source window. Use Campaign to: Drive personalization and engagement through a single accessible view. Community home Advertising Analytics Audience Manager Campaign Classic v7 & Campaign v8 Campaign Standard Developer Experience Cloud Experience Manager Sites & More Experience Platform Journey Optimizer Target Real-Time Customer Data Platform Workfront Creative Cloud Document Cloud Commerce Marketo EngageCampaign developer: They are primarily responsible for the general operations of the Adobe Campaign platform, which includes maintaining Adobe Campaign database health, developing email content, and developing new campaigns and workflows. The Outbound schema must exist in the database and be linked to an FDA database. Adobe Campaign provides various CRM connectors for linking your Adobe Campaign platform to your third-party systems. Multiple activities allow you to interact with data from an external database: Use of the FDA option depends on your Adobe. When it leaves the activity, the data is identified. I am trying to truncate the contents of a custom table in the Adobe Campaign database. Numerous screenshots have been updated to reflect interface changes. 10 - October 2017 release; 17. The ‘Test’ activity evaluates JavaScript expressions in order to activate the appropriate transition. Depending on the type of database installed, Adobe Campaign changes the defined type into a value specific to the database installed. Like. This wizard is accessible via Tools > Advanced > Update database structure. To do so: From the advanced menu, via the Adobe Campaign logo, select Administration > Application settings > External accounts then the SMS routing via SMPP external account. 4 “Test Instance ” means an Instance intended to allow only for reasonable configuration testing of out -of-the-boxThe Incremental query activity allows you to filter and extract a population of elements from the Adobe Campaign database. Adobe Campaign integrates with a variety of marketing, analytics, and sales solutions, and lets you connect to external databases through federated data access. Configure URL permissions (on-premise) The default list of URLs that can be called by JavaScript codes (workflows, etc. myDomain. External database (FDA) Use the External database type external account to connect to external an database. Learn how to update the database to see your new schema in Adobe Campaign ClassicLast update: 2021-09-13 Topics: Workflows Created for: Experienced Developer Depending on your business needs, you have several ways to import and export data with Adobe. In this case, the name and possibly the record folder are computed. This workflow aims to enrich the Adobe Campaign database with new profiles or to update existing profiles using the data recovered from the imported file. From the Explorer, go to the Resources > Templates > Delivery templates folder of the Adobe Campaign tree. Once the workflow has been configured and data sent to your storage location, you need. Adobe Campaign Standard On-demand Services provides a platform for designing and executing digital marketing campaigns and provides an environment for visual campaign orchestration. In order to set up connections with external systems, you can create new external accounts. By default, instances are not allowed to connect to outside URLs. Campaign Standard . Test the external account or create a temporary connection between Adobe Campaign and the external database. To configure Microsoft SQL Server on Windows: In Windows, click Control Panel ‘>’ System and Security ‘>’ Administrative Tools ’>’ ODBC Data Sources (64-bit). The list of database systems and compatible versions per hosting model is detailed in Campaign Compatibility matrix. The database file or installer package might be corrupted. Learn how to update the database with an update data activity. Profiles are centralized in the Adobe Campaign database. 7 - July 2017 release; 17. Adobe Campaign Managed Cloud Services provides a platform for designing cross-channel customer experiences and an environment for visual campaign orchestration, real-time interaction management and cross channel execution. To set up access to an external database with FDA, configuration steps are: Install the drivers and set up the external account that correspond to your database on the Adobe Campaign server. The PKey is the physical primary key of an Adobe Campaign table. For each page of the form, you can add a field via the first button in the toolbar. Staging mechanism in a nutshell: Data schema structure is duplicated into the local staging table. The Web form workflow will include the following activities: To do this, follow the steps below: Create a Web form and choose the template Newsletter subscription (subNewsletter). Sign In. Campaign developer: They are primarily responsible for the general operations of the Adobe Campaign platform, which includes maintaining Adobe Campaign database health, developing email content. You can define and manage their mapping through the Form data section on the left palette. Hi Eveline, As explained in the documentation: Adobe Campaign Help | About transactional messaging , this choice is according to your use case. so. This applies to the subsequent modules: web, syslogd, trackinglogd and watchdog (sports from the config-default. The skill set should include strong analytical, JavaScript, CSS, and HTML development. Time zone: Server time zone. create overview-type Web applications to display all the Web applications in your database. Hi Opkar, Thanks for reverting. Importing data with import templates. You can also use an existing reference table as an enumeration in your schemas. Define the column which the new calculated field must refer to. The steps for building a query in Adobe Campaign are as follows: Select the work table. In Adobe Campaign Standard, this value is not visible to the end user (except in URLs). External database version: you need to have an external database that is compatible with the Adobe Campaign FDA module. Common and general issues. ) or user defined fields. Database. Learn. For more on configuring time zones in Adobe Campaign, refer to Campaign Classic v7 Installation Guide. Check if SQL Server Native Client v11 is listed in the Create New Data Source window. However, deleting a transactional message can only be done under certain conditions: Make sure the transactional message has the. The enrichment activity can be used to configure data reconciliation, including once data has been loaded into the database. Courses Tutorials Certification Events Instructor-led training View all learning optionsLearn how to download and install the Adobe Campaign Client Console, create and manage your connections to multiple environments, and to verify access to the Adobe Campaign Client console. The PKey is the physical primary key of an Adobe Campaign table. Context of use. Configure the Google BigQuery external account, you must specify: Type: Google BigQuery. User. Profiles (customers, prospects, newsletter subscribers, etc. The event must contain the three following elements: A registration token, which is the user ID for one mobile application and one device.