ePrivacy and GPDR Cookie Consent by Cookie Consent Skip to main content

Loader Microsoft Advertising

Microsoft Advertising Audience Loader allows businesses to connect with targeted audiences on Microsoft Advertising. By leveraging customer data, businesses can create, update, or replace audience lists, ensuring that ad campaigns reach the right users at the right time.

This loader simplifies the process by extracting customer emails from a CSV file, hashing them if needed, and securely uploading them to Microsoft Advertising. This ensures that businesses can optimize their advertising efforts by continuously refining and updating their audience segments.

Business value in CDP

Integrating Meiro’s Customer Data Platform (CDP) with Microsoft Advertising enhances audience targeting and improves ad campaign performance. By leveraging customer data, businesses can:

✅ Segment and analyze customer data based on behaviors, preferences, and interactions.
✅ Build highly targeted audience lists that match their ideal customer profiles.
✅ Upload refined audience lists for precise ad targeting on Microsoft Advertising.
✅ Enhance ad personalization by delivering relevant ads to users based on past interactions.

For example, businesses can target users who have previously engaged with specific products or services, ensuring ads are more relevant and impactful. This leads to better engagement, higher conversion rates, and a more effective advertising strategy.


Steps for setting up Microsoft Advertising Loader

Follow this step-by-step guide to configure the component:

  1. Set up the loader within Meiro Integration by following the instructions in this article.

  2. Add the loader as a destination in CDP. Read more here

  3. Export your segmented customer profiles. Refer to this article.


Setting up the loader in Meiro Integration

To send audience data to Microsoft Advertising, use the Microsoft Advertising Audience Loader component in Meiro Integration.

Component Process:
  • Extracts email addresses from the input file (emails.csv).

  • Reads the configuration file to extract credentials and audience parameters.

  • Hashes email addresses if required.

  • Loads email addresses to Microsoft Advertising using the Bulk API.

  • Supports creating, updating, or replacing an audience.

Data In/Data Out

Data In 

The loader requires an input file named emails.csv located in /data/in/tables/.

 

The file must contain a single column named email, following these rules:
✅ Emails must be lowercased
✅ Remove extra spaces before, after, or within email addresses
✅ Use SHA256 hashing if not already hashed

 

Example (input file):
email 
vincenoir@mail.com 
howardmoon@mail.com 

Data Out

N/A

Learn more: about folder structure in configuration here.

Important Reminders:
Minimum Audience Size: A customer match list must contain at least 300 email addresses to be eligible for ad targeting.
Processing Time: Customer match lists take up to 48 hours to become available for campaign use after upload.
Bulk API Limitations: The loader can process up to 4 million email addresses or 100MB per file. Larger datasets must be split into multiple files.
Customer Match Terms Acceptance: Before uploading data, you must manually accept the Customer Match Terms in Microsoft Advertising UI.

Parameters

Parameter

Required

Description

account_id

The identifier of the account that owns the entities in the request.

customer_id

The identifier of the customer that contains and owns the account.

developer_token

The developer token used to access the Microsoft Advertising API.

hash_email

Set to true if input emails need to be hashed, false otherwise.

membership_duration

Defines how long users remain in a segment.

customer_list_operation

Required when updating or replacing an existing audience. Set to "add" or "replace".

customer_list_id

Required when updating an existing audience. Identifies the audience to be modified.

customer_list_name

Required when creating a new audience. Defines the name of the audience.


Method Parameters

Below are the methods available for interacting with the Microsoft Advertising API:

  • Create_customer_list: Creates a new customer list and adds records from the input file.

  • Update_customer_list: Modifies an existing customer list by adding new records.

  • Replace_customer_list: Replaces all records in an existing customer list with new data.

If customer_list_id is provided, customer_list_operation must be set (add or replace).
If customer_list_id is not provided, customer_list_name must be specified to create a new audience.