Step-by-step guide on how to set up a recurring stream in Data Streams, migrating data from Facebook Ads into MySQL
In this tutorial, you will learn how to set up a recurring data stream. We’ll use data from Facebook Ads and move it into MySQL.
1. Click Set Data Extract Source.
2. You can choose an Existing Data Source or a New Data Source. In this tutorial, we're going to connect to a New Data Source.
3. From the Data Connector List, select Facebook Ads.
*Note that you need to link your Facebook Ads account before getting started, as shown in this article. Once you do that, you’ll be able to see your Facebook Ads credentials in the credentials list.
4. Select your Facebook Ads credential.
5. Then select a Report and an Account.
6. Name your Data Source and click Submit.
7. Now click Set Data Destination.
8. From the Data Connector List, select a data warehouse of your choice and click Submit. In this tutorial, we'll choose MySQL.
9. Select your MySQL credential and a database, then click Submit.
10. You can choose an Existing table or create a New table. We’re going to create a new table and name it 'test July 2018.' Once you named it, click Submit.
11. Now click Set Schedule & Data Range.
12. We will set up a Recurring stream in this tutorial.
You can select the time of day when this stream should refresh, and also change the timezone, granularity and calendar. When setting up a recurring stream, it's mandatory to set the date range (Import data since and Run this report until).
13. Now you can add Filters & Segments if you want to. This is an optional field where you can choose a metric or dimension to filter or segment specific data..
14. Now select Metrics and Dimensions. In this section you will see three tabs:
- Source - Select a metric (mandatory) or dimension from the drop-down menu.
- Destination - This will be the column name in your table.
- Data Type - Select the appropriate description of your metric.
You can select more than one metric or dimension, by simply clicking Add Metric or Dimension. You can add as many metrics and dimensions you want for your data. (Any limitations in this regard would be from the cloud source).
15. Name your stream and click Save and Exit.
Now your stream appears in the streams list. The status of your stream will indicate 'Success', once your stream refreshes successfully.