Part of the ODAP Use Case Framework is p360-export exporter. It can be used to export your segments to SFMC, Google Ads, Facebook…

Get the exporter

Exporter file which is needed can be found here:

odap-framework-demo/p360_export.py at master · DataSentics/odap-framework-demo

Needed configuration

Key vault

If you have this exporter in exporters folder, you can configure it in config.yaml

parameters:
	p360_export:
	    config:
	      dbutils_secrets_scope: "unit-kv"

• dbutils_secrets_scope - tells us the name of dbutils secrets scope, which is needed to access secrets, stored in key vault.

Destination

You need to configure the desired destination in config.yaml, for SFMC it will look like this:

sfmc_export:
        type: "p360_export" # This tells us to use the p360_export file we copied
        p360_destination: "sfmc" # This is p360_export specific variable
        mapping:
          subscriber_key: "customer_email"
        credentials:
          client_id: "<client_id>"
          client_secret_key: "<client_secret>"
          ftp_username: "<ftp_username>"
          ftp_password_key: "<ftp_password_key>"
          tenant_url: "<tenant_url>"
          account_id: "<account_id>"
          file_location: "<file_location>"
        attributes:
          customer:
            - "customer_email"
          account:
            - currency

• p360_destination - Tells us where we want to export our segment with p360_export library.
  • sfmc - export to sfmc
  • google_analytics_4 - export to google analytics 4
  • google_ads - export to google ads
  • facebook - export to facebook
• mapping - Mapping is destination specific. They tell us which attribute from your data you want to map on the attribute needed by destination. Which mapping you need for given destination can be found here:
• credentials - Credentials are destination specific. Which credentials you need for given destination and how to get them, can be found in the same document as mapping.