Sync Product Catalogs from your Data Warehouse to Power Facebook Dynamic Ads

When used correctly, Facebook's Dynamic Ads have the potential to make a significant impact on the customer experience. With Dynamic Ads, you're able to create an ad template that automatically pulls from your product catalog, generating hundreds if not thousands of ad variations. This allows you to scale your 1:1 personalization efforts without needing to manually create and monitor thousands of campaigns.

Rather than delivering generic product advertisements, Dynamic Ads ensure that every ad is tailored toward the specific interests and buyer journey of each of your individual customers and users.

In order to power Dynamic Ads, your product catalog needs to constantly stay up to date. Any change that's not synced to Facebook can result in incorrect or incomplete campaigns wasting ad spend and creating poor customer experiences. To avoid this, you're often forced to spend hours downloading and uploading manual CSVs directly to Facebook, only to be met with the realization that the data is already stale by the time you upload it.

This playbook will help you better understand how Hightouch makes managing Dynamic Ads easy by providing a solution that automatically keeps your product catalog in sync with Facebook.

Let’s say you work on the marketing team for an online clothing retailer. A user goes on your website and places some products in their cart, but gets distracted and doesn’t end up buying them. Naturally, you now want to run an ad on Facebook with personalized creative showing off the items they interacted with.

You set up a Dynamic Ads campaign at the beginning of the month with a one-time CSV upload, but your product catalog at the time didn’t account for any of the new fall releases. You are tired of needing to manually query, format, and upload the catalog every time your inventory changes or a new product comes out. You know there has to be a better way…

Using Hightouch, you can automatically sync your product catalog directly from your data warehouse and into Facebook. Doing so keeps your ads updated while avoiding the need for manual CSV uploads.

For this playbook, you'll need a complete list of your products in your data warehouse. Each product will need to be Each product will need specific fields required by Facebook. You'll also need to create a blank product catalog on Facebook and send conversions using Facebook's Conversion API so the platform knows which products to show in your ads.

1. Select from our supported source types and click Continue.

   

2. Enter your source integration details and click Continue.

   

3. Name your source and click Finish.

   

1. Navigate to destinations and click Add destination. Select Facebook Product Catalog and click Continue.

   

2. Connect to Facebook with OAuth which will open up a new window to input your credentials. Once done, click Continue.

   

3. Name your destination and click Finish.

   

1. Navigate to Models in Hightouch and click Add model.

   

2. Select the data source you connected earlier and click Continue.

   

3. Next, you want to define your data model. You can define your data using either a SQL editor, table selector, your existing dbt models, or even your Looks if you use Looker as your BI tool. For this example, we'll be using the SQL Editor.

   

4. Input a query that will select your product catalog data. Each row should be unique based on the product ID.

   SELECT
   *
   FROM
   PUBLIC.PRODUCT_CATALOGUE

1. Click Preview to verify your model output looks good. Then name your model, select your primary key, and click Finish.

   

   

1. With the model created, it's time to create your sync to Facebook. Select Syncs, click Add a sync, select your Facebook Product Catalog destination and click Continue.

   

   

   

2. Select the product catalog you've set up on Facebook and the columns that you want to sync.

   

   

   

3. After you've mapped your columns you can set your sync schedule.

   

4. With your sync configured, simply click Run and your product catalog will update on Facebook automatically.

   

5. With the product catalog now populated in Facebook, you should now be able to leverage it when creating Dynamic Ad campaigns.

Dynamic Ads are a powerful tool for performance marketers. A key piece to running Dynamic Ad campaigns is ensuring that your product catalog is always up to date. Using Hightouch and following the steps above, you can set up an automated sync of your product information from your data warehouse to your Facebook product catalog. Doing so ensures that you are delivering accurate campaigns and saving your team time to focus on optimizing campaigns and messaging.

Want to learn more? Check out our other playbooks or book a demo with our team of experts today!