Can I get tiktok organic data from my company account into bigquery using airbyte?

Yes, you can use Airbyte to extract data from your TikTok Marketing account and load it into BigQuery. Here are the steps you need to follow: 1. Set up TikTok Marketing as a source in Airbyte: - Create a TikTok For Business account and a developer application. If you want to access the Sandbox environment, create a Sandbox Ad Account as well. You can find the detailed steps [here](https://docs.airbyte.com/integrations/sources/tiktok-marketing#tiktok-marketing). - In Airbyte, add a new source and select TikTok Marketing from the Source type dropdown. Enter the required details and set up the source. The steps differ slightly for Airbyte Cloud and Airbyte Open Source, and you can find them [here](https://docs.airbyte.com/integrations/sources/tiktok-marketing#tiktok-marketing). 2. Set up BigQuery as a destination in Airbyte: - In Airbyte, add a new destination and select BigQuery from the Destination type dropdown. Enter your Google Cloud project ID, the location of your BigQuery dataset, the Dataset ID, and other required details. You can find the detailed steps [here](https://docs.airbyte.com/integrations/destinations/bigquery#step-2-set-up-the-bigquery-connector). 3. Set up a connection between your TikTok Marketing source and BigQuery destination in Airbyte. Please note that the TikTok Marketing source connector supports Full Refresh and Incremental sync modes, and it is restricted by TikTok's requests limitation. It's recommended to use higher values of attribution window (at least 3 days) in Incremental Syncs to ensure that the connector updates metrics in already presented records. You can find more details [here](https://docs.airbyte.com/integrations/sources/tiktok-marketing#supported-sync-modes) and [here](https://docs.airbyte.com/integrations/sources/tiktok-marketing#supported-streams). As for the type of data you can extract, the TikTok Marketing source connector supports various streams, including AdGroupAudienceReportsByPlatformDaily, AdsAudienceReportsDaily, AdsAudienceReportsByCountryDaily, and others. You can find the full list [here](https://docs.airbyte.com/integrations/sources/tiktok-marketing#supported-streams). However, please note that the data you can extract depends on the permissions of your TikTok Ads Business account.

@kapa.ai but does this then shoew me the like views etc from my companies non paid posts?

Yes, Airbyte can help you extract data from your company's non-paid posts on LinkedIn. The LinkedIn Pages source connector requires certain permissions to access various endpoints such as

Organization Lookup API

,

Follower Statistics

,

Share Statistics

,

Total Follower Count

,

Follower Statistics Time Bound

,

Share Statistics Time Bound

. These permissions include

r_organization_social

and

rw_organization_admin

, which allow you to retrieve your organization's posts, comments, reactions, and other engagement data, and manage your organization's pages and retrieve reporting data respectively. The API user account should be assigned the

ADMIN

role for this purpose. Once the data is extracted, you can consolidate it in your data warehouses, lakes, and databases for further analysis and visualization. Please refer to the [LinkedIn Pages source connector documentation](https://docs.airbyte.com/integrations/sources/linkedin-pages#getting-started) for more details.

@kapa.ai not linkedIn we are talking about Tiktok

A message from kapa.ai

I apologize for the confusion. For TikTok, the Airbyte's TikTok Marketing source connector can help you extract various types of data related to your TikTok marketing campaigns. However, the specific data you can extract depends on the endpoints exposed by the TikTok Marketing API and the permissions granted to your application. The connector supports Full Refresh and Incremental sync modes, and it's designed to not run into TikTok Marketing API limitations under normal usage. However, the specific metrics like views, likes, etc., for non-paid posts might not be directly available if they are not provided by the TikTok Marketing API. For setting up the TikTok Marketing source connector, you would need a TikTok Ads Business account with permission to access data from accounts you want to sync. For the Production environment, you would need an Access token, Secret, and App ID. To access the Sandbox environment, you would need an Access token and Advertiser ID. Please refer to the [TikTok Marketing source connector documentation](https://docs.airbyte.com/integrations/sources/tiktok-marketing) for more details.