Facebook Upload Customer List for Audience

Copied from: https://www.facebook.com/business/help/170456843145568?id=2469097953376494

Since FB keeps changing the layout – these links take you directly to the page you need to be….

Before you begin

Prepare your customer list in advance

To make a Custom Audience from a customer list, you provide us with information about your existing customers and we match this information with Facebook profiles. The information on a customer list is known as an “identifier” (such as email, phone number, address) and we use it to help you find the audiences you want your ads to reach.

Your customer list can either be a CSV or TXT file that includes these identifiers. To get the best match rates, use as many identifiers as possible while following our formatting guidelines. You can hover over the identifiers to display the formatting rules and the correct column header. For example, first name would appear as fn as a column header in your list.

Alternatively, we have a file template you can download to help our system map to your identifiers more easily. (You can upload from Mailchimp as well.)

Next steps

  1. Add your customer list: You can create your Custom Audience in Ads Manager. Once in your account, go directly to Audiences, then go to Create Audience > Custom Audience > Customer list
  2. Prepare your customer list: Select the identifiers to include, then add the customer list you want to use for your new Custom Audience and give it a name.
  3. Review your customer list: Confirm that you mapped your identifiers correctly or check to see that all errors are resolved. You’ll get one of the following notifications:
    • The green checkmark symbol means your identifiers were mapped correctly and are ready to be hashed, then used for the matching process.
    • The yellow exclamation symbol  means either that you chose not to include certain identifiers or that some identifiers need to be manually updated. You have higher chances of getting a better match rate to build your audience if you make the corrections before uploading your file.
  4. Upload your customer list: Once your list has been added and is ready for use, select Upload and Create.

Learn more

How to Edit a Custom Audience from a Customer ListHow to Share Custom Audience ListsBest Practices for Preparing Customer Information

This video helps then to create a look a like audience and then add it to your existing ad

Excel Delete Duplicates Between Tables

Table 1 – Original
Table 2 – Bounce List from VoilaNorbert

In Table 2 note the cell range ie.A2 to A998
Highlight emails in Table 1 (click on first, hold Ctrl, and click on last)
Conditional Formatting –> New Rule –> Use a formula to determine which cells to format

=countif(‘Table 2’!$A$2:$A$998,A2)>0
Format –> Fill –>choose a color –> ok –> ok

Note:
Replace above table names with whatever you have named your tables
May need to go in and fix rule is not showing properly
On Table 1 click Conditional Formatting –> Manage Rules
Make sure the formula is typed in correctly

Next, Sort so the highlighted or clear cells are on top
Sort & Filter –> Custom Sort –> Sort By A or Email Addresses (let excel expand the filter so all rows are moved together) –> Cell Color –> No Color or Choose a color to be on top
This way you can delete all the duplicates easily once they are grouped together.

Captcha

Register Domain at Google. https://contactform7.com/recaptcha/

Using Contact 7 form on WordPress, goto integration and enter the site key & secret key you created above.

Done!

Responsive Tables

<style type=”text/css”>
table {
border: 1px solid #ccc;
border-collapse: collapse;
margin: 0;
padding: 0;
table-layout: fixed;
width: 100%;
}

table tr {
background-color: #f8f8f8;
border: 1px solid #ddd;
padding: .35em;
}

table th,
table td {
padding: .625em;
text-align: center;
}


@media screen and (max-width: 800px) {
table thead {
border: none;
clip: rect(0 0 0 0);
height: 1px;
margin: -1px;
overflow: hidden;
padding: 0;
position: absolute;
width: 1px;
}

table tr {
border-bottom: 3px solid #ddd;
display: block;
}

table td {
border-bottom: 1px solid #ddd;
display: block;
text-align: right;
}

table td::before {
content: attr(data-label);
float: left;
}
}
</style>

Next the table (you only have to add percentages if you want and only to the thead – it will carry through)

<caption>
Enter Caption
</caption>
<thead>
<tr>
<th scope=”col” width=”10%”> </th>
<th scope=”col” width=”10%”>Price</th>
<th scope=”col” width=”17%”>Bed/Bath</th>
<th scope=”col” width=”17%”>SqFt</th>
<th scope=”col” width=”29%”>Address</th>
<th scope=”col” width=”17%”>MLS</th>
</tr>
</thead>

And you can add labels if you wish:

<td data-label=””>

Moving an Old Contact Database to MailChimp or ConstantContacts?

Uploading your contacts from your computer or company database can be problematic. Depending on how long you have been adding contacts to your database there is a good chance a high percentage of your emails are no long valid. This will cause a high bounce rate and could get your suspended from the bulk email giants.

It’s a good idea to have a 3rd party clean your list before uploading it for use. The company I choose, with great reviews, was Voilanorbert.com Their pricing was very reasonable and found that 35% of my list had invalid email addresses 39% were risky and only 25% were clean, usable email addresses. Mind you, this list went back over 15 years. For checking ~1400 email addresses the cost was $4. Very reasonable. I could have paid an additional $50 and they would have filled in my list with missing names, titles, companies, addresses & phone number.

Create and Use HTML Template in Outlook

Create New Message

Click New Message Button
Format Text > as HTML
Create your message using fonts & inserting graphics

File > Save as > type > Outlook Template

Use Created Template

Click New Item
More Items > Choose Form > Look in Use Template in File System
Choose .oft that you created above