First steps
Courses
Events and Behaviour Tracking
User Data
- How to Add Anchor Links to an Email
- Building Smart Containers
- How to Create a Synchronized Module
- How to Create a Gmail Promotions Annotation for Emails
- All for adaptivity in email builder
- Editing HTML and CSS
- Adaptive email builder review
- How to Add a Rollover Effect to an Email
- Adding a Video to an Email
- Working with “Images” block
- How to Add Social Media Buttons to an Email
- How to Add a Table to an Email
- How to Add a Background to an Email
- How to Add a Custom Font
- Designing your email
Omnichannel
- Scheduled Mobile Push Message
- How to Create Deep Links and Universal Links
- Setting Up Delivery and Clicks Analytics
- Mobile Push Campaign Report
- Managing mobile SDK access keys
- Creating Mobile Push Messages
- How to Create a Google Project for Mobile Push Notifications
- SDK for Mobile Apps
- Connecting Mobile Apps with Yespo
- Service Worker. Troubleshooting
- How to Send Web Push Notifications from a Website
- How to Create a Web Push Notification
- How to Set Up Web Pushes for Safari
- How to Create a Google Project to Collect Tokens for Web Push Notifications
- Sending user a personalized Push notification depending on his activity on the website
- How to Set Up Subscription Form for Your Website
- Integrating widgets with GA
- How to Set up Informers for Your Site
- Creating Pop-ups via Google Tag Manager or WordPress
- How to Set Modal Window on Your Website
- How to Set Up Floating Box Widget for Your Website
- Creating a Widget Launcher
- How to Set Up Age Gate Widget for Your Website
Automation
- How to Set Up Double Opt-In
- How to Set Up an Automated Birthday Campaign
- Launching a Workflow After a Contact Import
- How to Set Up Notifications for Trigger Control
- How to add scenario to the button
- Workflow Troubleshooting
- How to Automate Customer Reactivation
- How to Launch a Regular Workflow for a Segment
- How to Create a Welcome Email Series
Personalization
Analytics
Multilanguage Campaigns
API
Security and Compliance
Integration
Integration with Google BigQuery
Step-by-step guide how to export data from eSputnik, your CRM, different databases to BigQuery. It allows you to manage and store all data, create multiple additional fields and custom reports, etc. in one place.
Important
Please note that this integration is available only in the Growth and Enterprise plans
eSputnik provides two options for BigQuery integration:
- Exporting data from eSputnik to BigQuery
- Using data from BigQuery for segmentation and substitution of external data in messages.
To configure the BigQuery integration:
- Register at Google Cloud Platform
- Get a project key
- Create tables in Google BigQuery
- Configure two-sided BigQuery - eSputnik data transfer
If you already have a project key and have configured the BigQuery tables, you can go directly to the connector settings.
Creating a Project Key
1. Create a Google Cloud Platform account.
2. Select a project → APIs & Services → Credentials.
3. Click Create credentials → Service account.
4. Enter a service account name and click the Create and continue button.
5. Select BigQuery Admin role, click Continue -> Done.
6. Click the link Manage service accounts on the main page of the Credentials section.
7. Click on the three dots opposite created account and select the option Manage keys.
8. Click on the Add key button and select Create new key option in Keys section.
9. Select JSON key type and click Create.
10. The browser will automatically download the key to the download folder.
Setting up BigQuery Connector
1. Go to your profile > Settings > Connectors > and select Connect BigQuerry.
2. Fill in the Name field and upload the key file. Set unique contact field: select a table column that contains a unique contact key and eSputnik's unique contact key. They should match.
You may click Validate connection to test whether the authorization data is correct. You will see the notification if the connection is successful or not. If the connection fails, check the entered data and contact your system administrator if needed.
3. Click Save.
You will see created connector in Settings > Connectors. Click the tab with its name to edit the connector’s parameters.
Exporting Data to the BigQuery Table
To regularly update information about the audience, orders and campaign results in BigQuery, set up data export to tables. For example, you can export responses to an NPS survey, purchase history, date of the last click in a message, etc.
Available datasets for export:
- contactActivities;
- contacts;
- orderItems;
- orders.
This information will be transferred to BigQuery and will update the data in the tables once a day after setting up.
Important
You don’t need to pre-create BigQuery tables. They will be generated automatically at the first export, and since that all the incoming data will be updated. All the table names will correspond to the data sets (contact activities, contacts, order items, orders)
Setting up BigQuery Connector for Data Export
1. Go to Settings → Connectors and click Add data source.
2. Upload the key file and check the boxes for the data sets you want to upload. Click Save.
The connection will be displayed in Connectors → Export to BigQuery, here you can edit the settings.
Configuring a Data Source
1. Go to your profile > Settings > Data sources, click New data source and select External data source.
2. Select the created connector.
3. Select dataset and table and enter a source name. Click Save.
4. Import contacts to eSputnik and fill the external source with data. Now you can build segments based on the imported contact fields.
Important
Connection to the external database doesn’t presuppose contact import. Segmentation is only available for contacts that exist both in your eSputnik account and in the external database. Synchronize and update contacts before creating campaigns.
Adding data to a message is similar to adding data from PostgreSQL.