Back to Blog
Product

How to Activate Data from BigQuery to TikTok Ads

Learn how to activate customer data from BigQuery to TikTok Ads in the time it takes to brew a cup of coffee.

Katharine Toll

Katharine Toll

Divider

Retargeting efforts used to rely on email campaigns and cookies, but as these decline so does the power of many retargeting strategies. 

The answer is to leverage first-party data to target the proper ad audiences on platforms like TikTok. 

Considering that TikTok ads reach up to 50.3% of adults in the U.S., especially young adults, the platform can be a powerful tool for targeting younger audiences. Using your first-party data, you can create audiences for targeting, lookalike, and exclusion. 

It all starts by activating the data from your data warehouse to TikTok ads. 

Here’s what you need to know about activating your data from BigQuery to TikTok Ads. 

Manually Import Data to TikTok Ads

One option is to import your data to TikTok via CSV. Here are the steps for creating custom audiences on TikTok Ads Manager:

  1. Create a CSV file from a BigQuery table. 
  2. You’ll then need to format the CSV file to have the correct headers using Google Sheets or Microsoft Excel. 
  3. Within TikTok ad manager, select “Create a Custom Audience.”
  4. Select the source for your customer audience. “Customer File” describes those already in your database. 
  5. Choose the format of customer IDs.
  6. Upload your CSV file. 
  7. Name your audience. 
  8. Click “Confirm” to finalize. 

BigQuery to TikTok Ads via Flywheel Software

While you can manually import your first-party data to TikTok, there’s a better solution. Using Flywheel Software, you can activate your customer segments from BigQuery to TikTok ads within 5 minutes. After doing it once, your data warehouse syncs to TikTok and will continue to update automatically. 

  1. Connect your BigQuery data cloud to Flywheel Software as the source by entering your data credentials. 
  2. Set your TikTok ads account as the destination. 
  3. Using Flywheel’s audience builder, craft your custom audience. You could also use one already in your account. 
  4. Choose the percentage of treatment and control experimentation that you want. 
  5. Export to TikTok ads. The audience name in TikTok will sync with the name you set in Flywheel. 

Opt for a one-time sync of your audience or enable ongoing sync between BigQuery and TikTok ads. Automatic sync will add any new users as they fit the audience criteria. 

Overall, the process is quite similar to activating Snowflake to Facebook Ads or Snowflake to Instagram Ads. However, the benefits of each platform differ, and for many marketing teams connecting to several social media channels is beneficial for different campaigns.  

Flywheel Streamlines Data Activation 

To make the most of your first-party data, you need to connect it with your marketing platforms. Flywheel Software is here to streamline your data-driven marketing strategies by accelerating data activation. Export your raw data sets to over 30 destinations, including TikTok Ads, within minutes. 

Want to learn more? Book your free demo with our software specialists

Share on social media: 
Divider

More from the Blog

Introducing Flywheel Recipes

Introducing Flywheel Recipes

Flywheel Recipes suggests intelligent audience segments based on industry best practices, automatically builds them and enables sharing recipes among teammates.

Read Story
How to Send Data from Snowflake to YouTube Ads

How to Send Data from Snowflake to YouTube Ads

Step-by-step instructions on how to send data from your Snowflake Data Cloud into YouTube ads and create audiences for advertising campaigns.

Read Story
Am I Ready to Activate Data from my Data Warehouse?

Am I Ready to Activate Data from my Data Warehouse?

It is time to accept that your data will never be perfect and waiting to activate it is wasteful. Learn how to avoid analysis paralysis, take a practical approach and start driving value from your data cloud today.

Read Story

Looking for guidance on your Data Warehouse?

Supercharge your favorite marketing and sales tools with intelligent customer audiences built in BigQuery, Snowflake, or Redshift.

Get Demo