Getting Started with Friendbuy
Getting Started with Referral
Plan Your Referral Program Implementation Team
How to Join Your Team on Friendbuy
Best Practices
Referral Program Placements
Friendbuy Referral Emails
Driving Referral Program Awareness
Referral Offer Strategies
Limited-Time Offer Promotions in Referral
Referral Contests, Sweepstakes and Giveaways
A/B Testing Best Practices
Account Management
How can I invite my team to the Friendbuy platform?
Managing Your Account Settings
How to Set Up and Change Your Email Sender
Referral Campaign Management
Widgets
How to Create a New Theme
How to Make Changes to a Theme
How to Apply Theme Changes to a Widget
How to update a Widget or Theme to the latest version
How to Set Up a Ribbon
How to Set Up an Advocate Landing Page
How to Set Up a Friend Landing Page
How to Set Up a Post-Purchase Overlay
How to Set Up an Account Page Widget
How to configure your Terms & Conditions
How to Test a Widget
How to Set up a Self-Referral Overlay
How to Personalize Your Widgets with the Advocate name
Campaign Settings
How to Create a New Referral Campaign
How to set up Referral Code Personalization for PURLs
Setting Up an Advocate Reward
Setting Up a Friend Incentive
Setting Up Shopify Coupon Code Integration
How to Run an A/B Test
How to Change Your Referral Offer
Setting Up Max Clicks for Referral Links
How to Generate Personalized URLs (PURLs) through Our API
How to Generate Personalized URLs (PURLs) for Advocates
How to Configure Tiered Rewards
How to Archive a Referral Campaign
How to Duplicate Your Campaign
How to Set Up a Redirect for Limited Time Campaigns
How to set up Code Based Sharing
Code Banks
How to Create a New Code Bank
How to Generate Coupons in Bulk for Shopify
Setting Up Low Code Bank Notifications
How to Add Codes to an Existing Code Bank
Emails
Loyalty Program Management
Uploading Data From a Legacy Loyalty Program
How to Set Up Purchase Based Member Tiers Program
How to Set Up a Points-Based Member Tier Program
How to Set Up Points Redemption Options
How to Set Up Shopify Coupon Code Integration in a Loyalty Earning Event
How to Set Up a Loyalty Opt-in CTA
Understanding the Loyalty Analytics
How to Configure an Earning Event in your Loyalty Program
How to set up expiration for Points or Account Credit
How to Create, Edit, and Manage Loyalty Emails
Integrations
Recharge Integration
Ethyca Integration
Klaviyo Integration
How to send Referral Links Post Product Review (Yotpo + Klaviyo)
How to Prompt a Referral After a Positive Review with Friendbuy and Trustpilot (via Klaviyo)
How to send one time emails with referral links through Klaviyo
How to Send Referral Links Post Positive Product Review (Okendo + Klaviyo)
How to Send Referral Links Post Purchase through Klaviyo
How to Enable the Klaviyo Integration
How to Send a Customer their Loyalty Points Balance Through Klaviyo
How to Email Coupon Codes Through Klaviyo to Advocates and Friends After They Are Distributed by Friendbuy
How to Reward Customers for Providing a Review Through Yotpo via Klaviyo Through Your Loyalty Program
Upgrading to Klaviyo OAuth with your Friendbuy Integration
How to Reward Customers for Providing a Review Through Okendo via Klaviyo Through Your Loyalty Program
How to Send Coupon Codes through Klaviyo SMS to Advocates and Friends After They are Distributed by Friendbuy
How to Reward Customers For Subscribing to Klaviyo Emails and Texts Through Your Loyalty Program
How to Segment Customers Based on Tier Status in Klaviyo
How to Reward Customers for Providing a Review Through Stamped via Klaviyo Through Your Loyalty Program
Braze Integration
DataGrail Integration
Tango Card Integration
Cordial Integration
Segment Integration
How to Integrate Friendbuy as a Segment Source
How to set up the Segment Web-Mode (Destination Actions) Integration
Shopify Integration
How to Enable the Shopify Integration
Shopify Checkout Extensibility
Shopify Pixel Tracking
Shopify Theme App Embed
Ordergroove Integration
Kustomer integration
Tremendous Integration
Iterable Integration
Trigger a Direct Mail Campaign to Drive Referral Program Awareness (Friendbuy x Iterable x Poplar)
How to Enable the Iterable Integration
How to Automatically Text Referred Friends their Coupon Code with Iterable Journeys
Increase Referral Program Awareness with a Dedicated Email Blast through Iterable Journeys
Attentive Integration
Send a Triggered Text to Prompt a Referral After a Positive Review with Attentive and Okendo
Automatically Prompt a Referral Post Purchase in Attentive
Send Referral Program Text Messages Through Attentive
How to Text Coupon Codes to Advocates using Attentive Journeys
Make it Easy for Advocates to Refer by Sending Their PURL Through SMS using Attentive Journeys
How to Send Advocates a Reminder Text to Redeem Their Coupon Codes through Attentive Journeys
How to Send Referred Friends a Reminder Text to Redeem Their Coupon Codes through Attentive Journeys
How to reward Loyalty Members for signing up for Attentive text messages and emails
How to Include a Customer's Loyalty Points Balance in an Attentive Text
How to Send a Coupon Code to a Referred Friend using Attentive Journeys
How To Enable the Attentive Integration
Fivetran Integration
Fraud Prevention
How to Block a Referral Code
How to Block an Email Address
Fraud Settings and Business Rules
Configuring a Global Reward Allowance
Configuring a Referral Link Fallback URL
How the Similar Email Address Fraud Check Works
Customer Service Portal
How do I check the status of a referral?
How to Manually Add or Remove Credit / Points to a Customer's Account
Why was my customers reward rejected?
The Referred Friend put in their email address but didn’t get their coupon code. How do I find this?
Resend Reward Email
Override a Rejected or Pending reward
How to Search for a Customer Profile
How to create a Manual Referral
Why didn't the Advocate receive a Reward for a successful referral?
Reasons for Rejected Advocate Rewards and Friend Incentives
Analytics & Reports
Performance Overview
Reports
Mark purchases as "Test" to maintain clean reporting
Top Advocates Report
Account Credit or Points Statement Export
Exporting Reports from Friendbuy
Email & SMS Report
Advocate Rewards Report
Purchases Report
Friend Incentives Report
Understanding the Codes Report
Dashboards
Common FAQs
What does Fraud Protection do?
How to Access my Billing Information
What is a typical referral flow?
How to Apply Theme Changes to a Widget
Difficulty downloading reports after you receive an export email?
What are Fraud Checks, Tier Checks, and Rules Checks in the Rewards Report?
How do I change my password?
What is a self-referral redirect URL?
What do the Reward Statuses and Definitions mean?
How to Create a New Theme
What is a Friend Widget?
How are Conversions Tracked in Friendbuy?
A Glossary of Terms
How long is the Referred Friend attribution window
What are some common scenarios, and how do I troubleshoot them?
Developer Documents
- All Categories
- Integrations
- Fivetran Integration
- How to Leverage Friendbuy's Fivetran Integration
How to Leverage Friendbuy's Fivetran Integration
With Friendbuy and Fivetran together, you can seamlessly extract, transform and load referral and loyalty program data into your data warehouse.
The Fivetran platform manages the world’s largest workloads with numerous database replication methods (including change data capture) to power your real-time, low-impact data movement.
How to Set up the Friendbuy and Fivetran Integration
Prerequisites
To connect Friendbuy to Fivetran, you need a Fivetran account.
Setup instructions
- Log in to your Friendbuy account.
- In the Developer Center section, go to the API Keys tab and make a note of the API Key. You will need it to configure Fivetran.
- Go to the Friendbuy Code tab and make a note of the Secret Key. You will also need it to configure Fivetran.
- In Fivetran's connector setup form, enter your chosen Destination schema name.
- Enter the API Key and API Secret you found in Steps 1 and 2.
- Click Save & Test. Fivetran will take it from here and sync your Friendbuy data.
Features
FEATURE NAME | SUPPORTED | NOTES |
Yes | All tables | |
Custom data | ||
Yes | Column level | |
Yes | ||
Yes | Connector level | |
History | ||
Yes | ||
Priority-first sync | ||
Fivetran data models | ||
Private networking |
Sync Overview
To capture new records, Fivetran will incrementally sync the following tables:
CLICKDISTRIBUTED_ADVOCATE_REWARDDISTRIBUTED_FRIEND_INCENTIVEEMAIL_CAPTUREPURCHASESHARESIGNUPWIDGET_VIEW
Schema information
Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
DISTRIBUTED_FRIEND_INCENTIVE ⇱ | friend_email 🔑 campaign_id ▶ WIDGET_VIEW referral_code ▶ SHARE advocate_name campaign_name coupon_code friend_name incentive_amount incentive_type trigger |
DISTRIBUTED_ADVOCATE_REWARD ⇱ | fivetran_id 🔑 campaign_id ▶ WIDGET_VIEW referral_code ▶ SHARE advocate_customer_id advocate_name friend_customer_id reward_amount reward_type trigger |
CLICK ⇱ | destination_url 🔑 campaign_id ▶ WIDGET_VIEW referral_code ▶ SHARE advocate_name |
PURCHASE ⇱ | order_id 🔑 campaign_id ▶ WIDGET_VIEW referral_code ▶ SHARE advocate_email advocate_name amount customer_id coupon_code name new_customer |
PURCHASE_PRODUCT ⇱ | index 🔑 order_id ▶ PURCHASE name price quantity sku |
EMAIL_CAPTURE ⇱ | fivetran_id 🔑 campaign_id ▶ WIDGET_VIEW campaign_name created_on email_capture_type ip_address name newsletter_opt_in |
WIDGET_VIEW ⇱ | campaign_id 🔑 created_on 🔑 customer_id ▶ SIGNUP campaign_name ip_address user_agent widget_name widget_type |
SHARE ⇱ | created_on 🔑 referral_code 🔑 campaign_id ▶ WIDGET_VIEW advocate_email channel |
LEDGER_HEAD ⇱ | currency 🔑 customer_id 🔑 ▶ SIGNUP current_balance |
SIGNUP ⇱ | created_on 🔑 customer_id 🔑 campaign_id ▶ WIDGET_VIEW referral_code ▶ SHARE advocate_customer_id advocate_email advocate_name campaign_name channel name new_customer user_agent |
