google

The Audience Hub allows you to create Google Customer Match Audiences. 

Google Customer Match Audiences are supported on the following ad types:

• Search
• Shopping
• YouTube
• Gmail

Google does not currently support Customer Match Audiences on:

• Display

Using Google Customer Match Audiences, you can:

• Create custom segments
• Re-market to existing customers
• Cross-sell or Upsell
• Expand acquisition efforts
• Target Broad match keywords or general keywords related to your business

Facebook

The Audience Hub allows you to create Facebook Custom Audiences. There are ten different types of Facebook Custom Audiences that can be managed in Marin Social. 

To learn more about Facebook Custom Audiences, check out our dedicated article. 

File Name Requirements

The file name must be in the following format:

• <FileName>.CSV

<FileName> can be replaced with whatever name you'd like for the file that is being uploaded. It should not contain spaces or special characters. The only language currently supported is English, though we do plan to support additional languages in the future. 

Using the file format of <FileName>.CSV, if a marketer wanted to use the filename "Top100customers," the format would become either Top100customers.CSV or Top100customers.csv. 

File Format

When uploading your file, keep the following in mind:

• The file should be in .CSV format only.
• It should be uploaded via FTP in Hashed format only. We'll go into more details on what this means in the next section. 
• Different user records must be separated by either a line break or the standard unix character \n
• Data is case insensitive
• Data must be entered in English only. We plan to support additional languages in the future. 

Operation

From the Hashing tool, use the drop-down to select the operation you'd like to use for your upload. This will perform the following operations:

• Add is used to add new users
• Remove is used to remove existing users
• Replace is used to replace an existing set of users

Only one of the above operations -- Add, Remove, Replace -- can be performed in a given upload. 

If no operation value is provided, the default operation will be Add. The operation selected will be appended to the file name once the file has been downloaded from the hashing tool. So, the file name of Top100customers.CSV will become Add_Top100customers.CSV. We'll learn more about other details that will be appended to your file name in the Hashing section of this article. 

audience metadata

The first few rows of your file will contain the Audience Metadata. This can include:

• Audience name (required) - This supports only A - Z, a - z, 0 - 9, underscore, and spaces in English only. Special characters are not supported.  
• Description (optional) - This field cannot be split across different cells. 
• Membership duration (Google only) (optional) - This controls how long your customers will be kept in a CRM audience, displayed in days. Once membership duration expires, users will be dropped from the audience. Values 1 - 540 are supported.
  
  Note: Though this field is technically optional, if left blank, Google will assign the default value of 10,000 days.  
• Audience type (required) - Please follow this exact format: CRM_Based

At the end of your Audience Metadata, you will need to include an <END> tag to let Marin know when it has finished processing the metadata and can start processing customer data. 

Your Audience Metadata might look something like this:

The row with your column headers should come immediately after the <END> tag, without a blank row in between.

Note: Your Audience Metadata will remain unhashed, even after the rest of the file has gone through the hashing process.

Customer information

Marin currently supports the following customer information:

• Email
• Phone
• First Name
• Last Name
• Country 
• Zip Code

The first row of customer information will be made up of your column headers and will remain unhashed, even after the remainder of the file has gone through the hashing process. 

The following column combinations are accepted in a file:

• Email only - Up to three Email columns (see accepted column headers in the matrix below), External Account ID, and Publisher. No other columns are required. 
• Email, First Name, Last Name, Country, and Zip - If First Name and Last Name are used, then Country and Zip should also be included. 
• Email, Phone, First Name, Last Name, Country, and Zip - As with the above, if First Name and Last Name are used, then Country and Zip should also be included. 

You can learn more all of the accepted columns and their requirements in the table below. To learn more about the various combinations with which these columns can be used, check out the Valid Column Combinations section of this article. 

Please note that after the file has gone through the hashing process, all columns will be displayed. Please leave these added columns in place when uploading your hashed file. 

Note: The publishers (Google or Facebook) will not find a match for all customer data that is uploaded. As a result, the number of records you upload may not equal the List Size provided by the publisher. List Size is the number of records successfully matched by the publisher. That said, the more information provided in the file (email, phone, etc.), the higher the likelihood that the publisher will find a match for your customer data. 

Sample File

If you're ready to begin creating your Audience Hub file, you can download a sample file at the link below.

• Audience Hub Sample File (.csv)

Valid column combinations

Use the matrix below to determine the best column combinations for your data. If a column has an X present, this represents that the data is present in your file. 

A Note about excel

You might find that your your CSV file, when opened in Excel, is displaying numbers in an unusual fashion. You can see an example of this in the screenshot below. 

If this is happening, you can simply convert the applicable cells to be displayed in number format.

You may also need to remove excess decimal places. 

Your cell values should then display correctly. 

An important note about data privacy & Security

Marin takes your data privacy seriously. Marin's Hashing Tool is an html file that you will download locally, which means your secure client data will never leave the comfort of your own computer. It will never pass through Marin's servers, which means we will never store your hashed or unhashed customer data. 

To learn more about Data Privacy at Marin, check out the Data Privacy page on our company website. 

For concerns on how Google handles customer match data, please visit the Google Ads Help site here (external link). Or for concerns on how Facebook handles customer data, please visit the Facebook Ads Help Center here (external link).

Hashed vs. unhashed data

For comparison purposes, let's take a look at both hashed and unhashed data. 

Below you can see an example of unhashed data. It has identifiable client names, email addresses, zip codes, and more. 

Note: This screenshot uses the External Account ID column header, but for your upload, you will need to use either the headers Google Account ID or Facebook Account ID. 

Once hashed, this data might look like the below screenshot. The identifiable client data has been turned into a randomized string of characters in order to ensure the data remains secure. As we saw in the previous section, a few of your columns, such as Google Account ID, Facebook Account ID, and Publisher, will remain unhashed. 

Columns in Hashed Files

When Marin's Hashing tool hashes the file, it will add all supported columns, even if a column is not needed for your upload. Please don't delete these columns prior to uploading your audiences. These columns are required for the file to process, even if all of the cells within that column are left blank. Once a file is hashed, it's ready for upload without any additional changes. 

Marin's Hashing Tool

To access Marin's Hashing Tool, follow the instructions below. 

1. First, click the link below to download the html file for Marin's Hashing Tool. Clicking the link will automatically initiate the download. 
   
     Marin Hashing Tool (.html)
    
2. Once your file has finished downloading, you can click on the download to open it directly from your browser or open the file on your folder that contains this file. 
    

   

   
    
3. You will need to open this in a browser window, such as Google Chrome, Safari, Firefox, Internet Explorer or Microsoft Edge. 
   
    
4. Once the file has been opened, you will see a new tab in your browser for Marin's Hashing Tool. We'll learn more about how to use this tool in the next section. 
   
    

   

how to hash your file

Hashing your file is both simple and secure. You can get started simply by following the instructions below. 

1. First, go ahead and download Marin's Hashing Utility Tool following the instructions listed in the previous section. You can then open the tool in a new browser tab. 
    

   

   
    
2. Next, take the file that you created in the How to Create Customer Match Audiences section of this article and upload it into the Marin Hashing Tool. 
   
   You can either upload the entire .CSV file by choosing + Select a file... or you can paste the contents of your file into the available text box. 
    

   

   
   
   Note: Make certain that the file name and customer information are in the correct format, based on the information outlined earlier in this article.
    
3. Then, click the > Hash button.
    
4. The output window (at right) will only show the first 10,000 rows of your file. To see all of your hashed data, click Download. 
    

   

   
    
5. Above the right-hand output window, you can adjust the Operation as needed. Select Add, Remove, or Replace. You can learn more about the available options in the Operations section of this article.
   
    

   

   
    
6. The Hashing Tool will add <bulkaudiences> and a unique <unix_date> to your file name along with the Operation (Add, Remove, or Replace). For example, a file name of Top100Customers.CSV before hashing will become Add_Top100Customers_bulkaudiences_1552346736 after hashing, if the Add operation was selected. 
   
   In order to upload your file correctly in the next section, please leave these appended to the file name. 
   
   Note: Once your file has been hashed, it will still need to be uploaded to the FTP. Check out the next section for instructions. 

How to Connect via FTP

Once you have an FTP program, open it up and enter the following credentials:

Server: integration.marinsoftware.com
Username: Your Platform username
Password: Your Platform password

Transferring a File

Once you have successfully connected to the FTP client, each Marin Client Account you have access to will be listed as a separate folder represented by its Tracker ID. Files should be transferred to the top level folder (not any of the sub-folders within each client folder) and will begin processing in the Activity Log.

To identify your Tracker ID in MarinOne, follow the instructions below.

1. In the left-hand navigation, click on Admin ('gear' icon). 
    
2. Click on the Clients & Users tab. 
    
3. Click on the Clients sub-tab. 
    
4. You will see your Tracker ID listed in the Tracker ID column. You may want to copy this value to your clipboard or paste it somewhere hand so you can easily locate the correct folder in the FTP.

Note: Your Tracker ID can be located in the Admin section of MarinOne.

important notes

When uploading to the FTP, keep the following in mind:

1. Make sure to upload the hashed file, NOT the unhashed file. 
    
2. Make sure the file is in the required format, has been named correctly, and the column headers are in the required format. For more information, check out the Creating Your Customer List File section of this article. 

If there were any errors in the file processing, you will see an error status file added to the FTP. If the file was processed successfully, you will see it appear in the MarinOne Activity Log shortly after it has been uploaded. 

If the file is successfully parsed, MarinOne will create the Audience object and push this along with any associated user data to the publisher.

Note: For Google Customer Match Audiences, Google requires a match rate of at least 1,000 users in order to build an audience. Marin doesn’t currently alert users when that threshold hasn’t been met, nor does it showcase the total match rate when syncing is complete. We will be introducing these capabilities in a later release.

Similar Audiences (Google)

Similar audiences enable advertisers to target users searching for the same kinds of things as your designated customer match list, for which Google analyzes browsing interests, search queries, and videos watched, on Gmail and YouTube. These will automatically be created if your Customer Match audiences meet the minimum eligibility criteria.