Snapchat Marketing
This page guides you through the process of setting up the Snapchat Marketing source connector.
Prerequisites
For Airbyte Cloud:
- A Snapchat Marketing account with permission to access data from accounts you want to sync
For Airbyte Open Source:
- client_id
- client_secret
- refresh_token
- start_date
- end_date
- action_report_time (Optional, Default value is conversion) It specifies the principle for conversion reporting.
- swipe_up_attribution_window (Optional, Default value is 1_DAY) This is the attribution window for swipe up.
- view_attribution_window (Optional, Default value is 28_DAY) This is the attribution window for views.
Setup guide
Step 1: Set up Snapchat
For Airbyte Open Source:
- Activate Access to the Snapchat Marketing API
- 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
- Adding the OAuth2 app requires the
- 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
text 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:
- Log into your Airbyte Cloud account.
- In the left navigation bar, click Sources. In the top-right corner, click + new source.
- On the source setup page, select Snapchat Marketing from the Source type dropdown and enter a name for this connector.
- lick
Authenticate your account
. - Log in and Authorize to the Snapchat account
- Choose required Start date
- click
Set up source
.
For Airbyte Open Source:
- Go to local Airbyte page.
- In the left navigation bar, click Sources. In the top-right corner, click + new source.
- On the source setup page, select Snapchat Marketing from the Source type dropdown and enter a name for this connector.
- Add Client ID, Client Secret, Refresh Token
- Choose required Start date
- 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.
Reference
Config fields reference
Field
Type
Property name
string
client_id
string
client_secret
string
refresh_token
string
start_date
string
end_date
string
action_report_time
string
swipe_up_attribution_window
string
view_attribution_window
Changelog
Expand to review
Version | Date | Pull Request | Subject |
---|---|---|---|
0.6.2 | 2024-15-22 | 38574 | Update authenticator package |
0.6.1 | 2024-04-24 | 36662 | Schema descriptions |
0.6.0 | 2024-04-10 | 30586 | Add attribution_windows ,action_report_time as optional configurable params |
0.5.0 | 2024-03-19 | 36267 | Pin airbyte-cdk version to ^0 |
0.4.0 | 2024-02-27 | 35660 | Add new fields to streams ads , adsquads , creatives , and media |
0.3.2 | 2024-02-12 | 35171 | Manage dependencies with Poetry. |
0.3.0 | 2023-05-22 | 26358 | Remove deprecated authSpecification in favour of advancedAuth |
0.2.0 | 2023-05-10 | 25948 | Introduce new field in the Campaigns stream schema |
0.1.16 | 2023-04-20 | 20897 | Add missing fields to Basic Stats schema |
0.1.15 | 2023-03-02 | 22869 | Specified date formatting in specification |
0.1.14 | 2023-02-10 | 22808 | Enable default AvailabilityStrategy |
0.1.13 | 2023-01-27 | 22023 | Set AvailabilityStrategy for streams explicitly to None |
0.1.12 | 2023-01-11 | 21267 | Fix parse empty error response |
0.1.11 | 2022-12-23 | 20865 | Handle 403 permission error |
0.1.10 | 2022-12-15 | 20537 | Run on CDK 0.15.0 |
0.1.9 | 2022-12-14 | 20498 | Fix output state when no records are read |
0.1.8 | 2022-10-05 | 17596 | Retry 429 and 5xx errors when refreshing access token |
0.1.6 | 2022-07-21 | 14924 | Remove additionalProperties field from specs |
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 |