snapchat-marketing.md

Snapchat Marketing

This page guides you through the process of setting up the Snapchat Marketing source connector.

Prerequisites (Airbyte Cloud)

• A Snapchat Marketing account with permission to access data from accounts you want to sync

Prerequisites (Airbyte Open Source)

• client_id
• client_secret
• refresh_token
• start_date

Step 1: Set up Snapchat

1. Set up Snapchat Business account

For Airbyte OSS:

2. Activate Access to the Snapchat Marketing API
3. Add the OAuth2 app:
   • Adding the OAuth2 app requires the redirect_url parameter.
     • If you have the API endpoint that will handle next OAuth process - write it to this parameter.
     • If not - just use some valid url. Here's the discussion about it: Snapchat Redirect URL - Clarity in documentation please
   • save Client ID and Client Secret
4. Get refresh token using OAuth2 authentication workflow:
   • Open the authorize link in a browser: https://accounts.snapchat.com/login/oauth2/authorize?response_type=code&client_id={client_id}&redirect_uri={redirect_uri}&scope=snapchat-marketing-api&state=wmKkg0TWgppW8PTBZ20sldUmF7hwvU
   • Login & Authorize via UI
   • Locate "code" query parameter in the redirect
   • Exchange code for access token + refresh token

     curl -X POST \  
     -d "code={one_time_use_code}" \  
     -d "client_id={client_id}" \  
     -d "client_secret={client_secret}"  \  
     -d "grant_type=authorization_code"  \  
     -d "redirect_uri=redirect_uri"  
     https://accounts.snapchat.com/login/oauth2/access_token
     

You will receive the API key and refresh token in response. Use this refresh token in the connector specifications.
The useful link to Authentication process is here

Step 2: Set up the source connector in Airbyte

For Airbyte Cloud:

1. Log into your Airbyte Cloud account.
2. In the left navigation bar, click Sources. In the top-right corner, click + new source.
3. On the source setup page, select Snapchat Marketing from the Source type dropdown and enter a name for this connector.
4. lick Authenticate your account.
5. Log in and Authorize to the Snapchat account
6. Choose required Start date
7. click Set up source.

For Airbyte OSS:

1. Go to local Airbyte page.
2. In the left navigation bar, click Sources. In the top-right corner, click + new source.
3. On the source setup page, select Snapchat Marketing from the Source type dropdown and enter a name for this connector.
4. Add Client ID, Client Secret, Refresh Token
5. Choose required Start date
6. Click Set up source.

Supported streams and sync modes

Stream	Incremental	Key
Adaccounts	Yes	"id"
Ads	Yes	"id"
Adsquads	Yes	"id"
Campaigns	Yes	"id"
Creatives	Yes	"id"
Media	Yes	"id"
Organizations	No	"id"
Segments	Yes	"id"
AdaccountsStatsHourly	Yes	["id", "granularity", "start_time"]
AdaccountsStatsDaily	Yes	["id", "granularity", "start_time"]
AdaccountsStatsLifetime	No	["id", "granularity"]
AdsStatsHourly	Yes	["id", "granularity", "start_time"]
AdsStatsDaily	Yes	["id", "granularity", "start_time"]
AdsStatsLifetime	No	["id", "granularity"]
AdsquadsStatsHourly	Yes	["id", "granularity", "start_time"]
AdsquadsStatsDaily	Yes	["id", "granularity", "start_time"]
AdsquadsStatsLifetime	No	["id", "granularity"]
CampaignsStatsHourly	Yes	["id", "granularity", "start_time"]
CampaignsStatsDaily	Yes	["id", "granularity", "start_time"]
CampaignsStatsLifetime	No	["id", "granularity"]

Performance considerations

Hourly streams can be slowly because they generate a lot of records.

Snapchat Marketing API has limitations to 1000 items per page.

Changelog

Version	Date	Pull Request	Subject
0.1.5	2022-07-13	14577	Added stats streams hourly, daily, lifetime
0.1.4	2021-12-07	8429	Update titles and descriptions
0.1.3	2021-11-10	7811	Add oauth2.0, fix stream_state
0.1.2	2021-11-08	7499	Remove base-python dependencies
0.1.1	2021-07-29	5072	Fix bug with incorrect stream_state value
0.1.0	2021-07-26	4843	Initial release supporting the Snapchat Marketing API