Easily track your Facebook campaigns using DataBlade

Allen Chen
DataBlade Blog
Published in
3 min readJul 27, 2016

Facebook’s advertising platform allows you to target users with incredible specificity, enabling businesses to reach highly qualified potential customers. However, creating successful campaigns still requires quite a bit of trial and error, and keeping track of your campaign spend and effectiveness as you iterate can be quite a challenge, especially as the size of your marketing team grows and the number of campaigns you run increases.

Let’s see how we can use DataBlade for Analysts to automate campaign reporting for your entire team quickly and easily.

Connect with Facebook

The first step is to connect your DataBlade account with Facebook using our simple data integrations. Select Facebook from the dropdown in the Data Integrations page and follow the simple login flow.

Connect your Facebook account with DataBlade in just a few clicks

Create Your First Facebook Report

After creating a new report, select Facebook Campaign Insights from the Add Data Source dropdown. A form will appear that will help guide you through constructing a query that will pull the information you require about your campaigns.

Once you’ve defined all the fields for your query, click Run Query and the data should appear in the right side of your screen. Congratulations, you’ve just built your first Facebook campaign report!

Sharing and Automation

At this point, you may have colleagues that will need access to this report. One way to do this is to use the sharing features in DataBlade. Once shared, this project will be available to all other users in your organization to run and edit.

Another way to distribute this information is to schedule the project as an automated email report. At the specified time, all the recipients will receive an email with your report attached as an Excel workbook.

Extra Credit: Unlocking the Power of SQL

Most 3rd part data sources like Facebook do not allow you to use SQL to query data. For more advanced analysts, this may feel limiting. With DataBlade, we allow our users to use SQL with any data source, including Facebook!

For example, if you wanted to modify the report we just created to only include campaigns that were optimized for link clicks, you could use SQL to quickly filter the query results.

Creating successful Facebook campaigns can be difficult, but keeping tabs on your spend and performance shouldn’t have to be. If you’d like to start tracking your campaigns with DataBlade, sign up for a free trial at http://datablade.io.

Got questions? Let us know at info@datablade.io.

--

--

Allen Chen
DataBlade Blog

Cofounder & CEO of @databladeio. Formerly of @newscorp, @CloudPressInc, @amazon. Consistent coffee drinker, occasional cyclist, photographer, and guitarist