Twitter Ads Connector

Intro

Twitter Ads is an advertising service that lets businesses reach potential customers by getting messages in front of people not yet following the business. You can use Domo's Twitter Ads connector to retrieve data about statistics for accounts, campaigns, funding instruments, line items, and tweets. For more information about the Twitter API, see their documentation (https://dev.twitter.com/ads/overview).

The Twitter Ads connector is a "Cloud App" connector, meaning it retrieves data stored in the cloud. In the Data Center, you can access the connector page for this and other Cloud App connectors by clicking Cloud App in the toolbar at the top of the window.

This topic discusses the fields and menus that are specific to the Twitter Ads connector user interface. For general information about adding DataSets, setting update schedules, and editing DataSet information, see Adding a DataSet Using a Data Connector.

Primary Use Cases	This connector lets you discover impressions, who is interacting with your Twitter ads, and the kind of reach you're getting.
Primary Metrics	Total number of engagements Total number of impressions Total number of retweets Total number of replies Total number of likes Total number of follows Total number of clicks, including favorites and other engagements Total number of qualified impressions
Primary Company Roles	All marketing roles
Average Implementation Time	10 minutes or less
Ease of Use (on a 1-to-10 scale with 1 being easiest)	2

Best Practices

Create DataSets that use Replace instead of Append, and only pull the last 3-7 days at a time.
Use a recursive DataFlow to deduplicate and append data. For more information, see Creating a Recursive/Snapshot Magic ETL DataFlow.

Prerequisites

To connect to your Twitter Ads account and create a Twitter Ads DataSet, you must have the following:

The Twitter account to use to log into your Twitter Ads account.
The password you use to log into your Twitter account.

Connecting to your Twitter Ads account

This section enumerates the options in the Credentials and Details panes in the Twitter Ads connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.

Credentials Pane

The Domo Twitter Ads connector uses OAuth to connect to Twitter Ads. Click Connect (or select Add Account if you have existing Twitter Ads accounts in Domo) to open the Twitter Ads OAuth screen where you can enter the credentials associated with your Twitter account. After you have entered valid Twitter credentials, you can use the same account in Domo any time you create a Twitter Ads DataSet.

You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Creating and Managing User Groups.

Details Pane

This pane includes a primary menu, Report, and other menus that appear depending on the report you select.

Menu

Description

Report

Select the Twitter Ads report. The following reports are available:

Account Statistics	Retrieves the summary of analytics about the campaigns executed by the specified account.
Campaign Statistics	Retrieves summary analytics about campaigns executed by the specified account.
Funding Instruments Statistics	Retrieves summary analytics about specific funding instruments with the specified account.
Line Item Statistics	Retrieves summary analytics about line items accessible by the current user.
Promoted Account Statistics	Retrieves summary analytics about Promoted Accounts accessible by the current user.
Promoted Tweet Statistics	Retrieves the summary analytics about Promoted Tweets accessible by the current user.

Account

Select the Twitter Ads account to query data from.

Duration

Select whether to pull data for a single date or a date range.

Report Date

Select whether to pull data for a specific date or a given number of days back (offset).

Specific Date

Select the date you want to pull data for.

Days Back

Enter the number of days back you want to pull data for.

Start Date

Specify whether the first date in your date range is a specific date or a given number of days back (offset).

Specific Start Date

Select the start date for your date range.

End Date

Specify whether the last date in your date range is a specific date or a given number of days back (offset).

Specific End Date

Select the end date for your date range.

Days Back to Start From

Enter the number of days back (offset) for the start date in your date range. For example, if you entered 10 for Days Back to Start From and 5 for Days Back to End At, each time the report ran it would pull data for the last 10 days up until the last 5 days.

Days Back to End At

Enter the number of days back (offset) for the end date in your date range. For example, if you entered 10 for Days Back to Start From and 5 for Days Back to End At, each time the report ran it would pull data for the last 10 days up until the last 5 days.

Granularity

Select the required granularity. For example, if the granularity is Hour, data is presented by hour between the Start Date and the End Date.

Segmentation Type

Select the required segmentation type.

Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.

Important: Twitter has recently changed the API that Domo uses to import data into your Domo account. The Domo Connections team has updated the Twitter Ads connector to use the new version of the API so you can continue to import data. All reports now include a deprecated version and an updated version (marked as "v.1"). Beginning June 30, 2016, all reports marked as deprecated will cease to work.

In the new version of the API Twitter has limited history to 45 days for segmented reports or 90 days for non-segmented reports. So the sooner you change the new reports, the more history you will be able to capture in Domo.

You will need to update the configuration for any DataSets in your account using the Twitter Ads Connector. You will also need to validate any cards powered by these DataSets to ensure they are still displaying correctly.

To update the DataSet configuration,

1. In the Data Center, locate and select the DataSet you want to update.
2. Click on the Details tab and select the new reports.
3. Save your changes.

To update cards powered by Twitter Ads DataSets,

1. In the Data Center, locate and select the DataSet powering the cards.
2. Click on the Cards tab to view the cards.
3. Confirm the cards are still functioning as expected.

If you have any concerns or need assistance, please contact Domo support.

Troubleshooting

Troubleshooting usually starts with making sure you don't have an issue with the credentials. If those are clear, next check that your request isn't timing out. If you select all Tweets and run for all time, you can expect to experience long run times. Adjust the number of Tweets you are pulling or the time frame if you are experiencing these issues.