Title
About This eBook
Description
WEBINAR Series
Your social media accounts and your CRM give you lots of useful information all day long - and sometimes it’s hard to know what to do with all that data or how it fits in the big picture of your business. Learn how to process, organize and understand your Facebook Ads and Salesforce data today.
Thanks for joining us for our 'Meet the New Salesforce and Facebook Ads Integrations' webinar. Above you can watch a recording of the webinar or review some of the frequently asked questions that we received during our live Q&A.
If you have any more questions, please feel free to contact one of our support experts or to get in touch through the Xplenty live chat.
Q: Why did Xplenty build the Facebook Ads and Salesforce integrations?
A: Let’s look first at the Facebook Ads integration. Today, social media data is extremely important, with over 56% of adults using one or more social media platforms on a regular basis. For this reason, it’s one of the most effective ways for companies to reach their consumers and get their message heard.
That said, many companies can’t accurately measure how effective their social media campaigns are because their social media data is often isolated from other business-critical sources and it doesn’t add context to the overall business.
By integrating this data with other relevant data - such as website traffic, web signup and marketing - businesses can have a better understanding of how their social media campaigns are performing. That’s why we built the Facebook Ads integration.
The same concept is true for the Salesforce integration as well. CRM’s are very powerful tools, but they are only as good as the data they contain and there’s a lot of data that needs to be accessed and shared between departments for businesses to make full use of it. This integration makes sure that that happens so every department is on the same page and working effectively.
Q: What kind of API do you use to write to Salesforce?
A: The Salesforce API that we are using to write into Salesforce is using the bulk API.
Q: The demonstration shows Facebook to Salesforce- could you pull data from other sources and write to Salesforce?
A: Yes, absolutely. In the example that I showed, we are reading from Facebook and Salesforce and loading into Salesforce. However, the way that Xplenty works, you can actually build packages that are pulling from any of your sources, including:
The possibilities really are endless as far as how you decide to mix and match your sources, your destinations and what kinds of transformations you build in between.
We also have a REST API component, which means that we can connect to any service that has a RESTful API or even a SOAP API. Then, once you have data from those sources loaded into a package, you have the whole playground of Xplenty to use to transform your data and load it into Salesforce or any of the other destinations that we support.
I encourage you to schedule time to discuss your specific use cases and map out what the pipeline would look like.
Q: The dimension fields for Facebook Ad campaigns are somewhat limited. Do you have plans on adding all attributes associated with these dimensions?
A: Definitely. As is, there are over 1200 fields here, so we believe that we have done a pretty extensive job of trying to collect every single metric that’s available. That said, it might be the case that we somehow missed a couple of them. If you have specific fields that you find are not available that you’d like to have, reach out to identify what those are and we’ll definitely add them into this list.
Q: How do we find out more about which fields are available from Facebook?
A: There are a couple of methods here that we’ll run through.
Q: Are there Facebook API throttling limits? Do they throttle the requests that we are making? Are we going to hit rate limits when we request the data?
A: This was a big issue that many of our users struggled with before we released this integration because Facebook tends to rate limit very quickly. However, with the new integration this is no longer an issue.
The way that we built this source component is against a different flavor of Facebook’s API - called the asynchronous API - which essentially means is that rate limiting is no longer a problem.
That being said, a lot of times you will get better performance if you set it to a max of 1 month at a time simply because Facebook’s API does get bogged down. However, you don’t have to worry about the same data limiting that you had before, not even close.
Q: Can Xplenty take Facebook or Adwords campaign performance data and put it back to BigQuery or a Google Sheet?
A: Absolutely. Let’s look first at Facebook Ads and Google Adwords. Each one has a native source component, so in either case, you simply set up those source components, build up whatever transformations you want in between - maybe you join the datasets together, maybe you have to do some conversions to dates so they align with each other, etc - and choose your destination.
BigQuery, in particular, is a native destination that we have built into Xplenty so you can just choose BigQuery, configure your table to make sure that the fields you are interested in are set up how you’d like, and then you run the job.
In the case of Google Sheets, we don’t have a native destination setup. This does not mean that the process is any more difficult or that you have to write code - it simply means you would have to use the REST API of Google Sheets to write data into the destination.
Q: How about MailChimp or Emarsys or DoubleClick to BigQuery?
A: In each case - MailChimp, Emarsys and DoubleClick - you can use that REST API source component. We have customers doing it today so we are very familiar with each of those integrations. And to the destination of either BigQuery or Google Sheets it’s the same answer as before - BigQuery you just set up as that native destination and Google Sheets you write a REST API destination.
Q: Do you support the generation of API code for Google Sheets?
A: Yes, we will help you set this up and make sure that you’re successful and that the data actually shows up the way you want it to. We understand that, as a customer, you want your data delivered, you want it to show up where you want it and you don’t really want to struggle with the ETL part - that’s why you’re coming to us for help. So we will always help you get your system set up and working properly.
We do encourage the non-customers on this webinar to schedule one-on-one sessions with our experts to discuss your specific use case. We can use this session to take your data and build out a production pipeline so you that you can see your data get formatted and delivered on the fly.
hello@xplenty.com
+1-888-884-6405