Twitter Data Connector

Learn how Singular pulls data from Twitter and displays it in your reports.

 

Quick Details

Data Connector Technology API (Twitter API v 7.0 - see documentation)
Data breakdown (segmentation)

In addition to the basic breakdowns such as Campaign and Sub-Campaign, you can get your data in one of the following breakdowns:

  • Platform (default)
  • Country

Note: Twitter does not provide publisher breakdown.

How far back we pull data 30 days
Time zone Defined by the customer per account
Is data available on the creative level? Yes
Does Singular show your creative assets? Yes - including images, videos, and streaming videos.
Singular does not show Polls.
Known Limitations/ Issues
  • Twitter does not provide publisher breakdown.
  • Singular can't show Scheduled Tweets before the tweet is live. We pull them when/if they go live.
  • Metrics on the Creative level do not always match metrics pulled on the Sub-Campaign level (Twitter's Line Item).
  • There are no install statistics per creative.
  • There may be discrepancies between Twitter’s platform breakdown report and Twitter’s country breakdown report.

Data Mapping

Terminology Notes:

  • Sub-Campaign in Singular corresponds to Twitter's Line Item.
  • Creative in Singular can correspond to Twitter's Tweet, Promoted Tweet, Card, or Media Creative
  • Metrics are pulled from Twitter's Line Item, Promoted Tweet, and Media Creative objects.

  Field in Singular UI Field in Singular API Field in Twitter
Campaign Dimensions Account ID adn_account_id Account_object: id
Campaign Dimensions Account Name adn_account_name Account_object: name
Campaign Dimensions Agency agency Not pulled directly from Twitter, but Singular can set the agency per each account.
Campaign Dimensions App Site ID app_site_id Estimated based on any URLs available in creative-related objects (Tweets,  Promoted Tweets, Cards, Media Creatives, Account Medias). If not possible, we try to estimate based on campaign URLs and Line Item URLs.
Campaign Dimensions Campaign URL adn_campaign_url
  • Pulled from a Card object related to a Tweet related to a Line Item in the campaign.
  • The field is "website_dest_url" in Twitter API v. 6.0 but if that is not populated we look under old field names: “website_url", "website_shortened_url", "media_url". 
  • If there was no Card, we look for the "landing_url" field in a Media Creative object.
Campaign Dimensions Country country_field We query the Twitter API with segment_by=”LOCATIONS”, and take the segment name for each Line Item and Promoted Tweet.
Campaign Dimensions Date date_field Since the Singular data connector pulls daily reports, we add the date ourselves.
Campaign Dimensions Network Campaign ID adn_campaign_id "id" in the Campaign object
Campaign Dimensions Network Campaign Name adn_campaign_name "name" in the Campaign object
Campaign Dimensions Network Creative ID adn_creative_id Depends on the type of the creative.
  • If the creative is a Promoted Tweet: "tweet_id" in the Promoted Tweet object
  • If the creative is a Media Creative: "id" in the Account Media object.
Campaign Dimensions Network Creative Name adn_creative_name Take the "media id" from the Card object and query Twitter for the media "name".
Campaign Dimensions Network Sub Campaign ID adn_sub_campaign_id "id" in the Line Item object
Campaign Dimensions Network Sub Campaign Name adn_sub_campaign_name "name" in the Line item object
Campaign Dimensions Platform platform
  • This is only available if you have asked Singular to receive the Platform breakdown instead of the Country breakdown.
  • We query the Twitter API with segment_by=”PLATFORMS”, and take the segment name for each Line Item and Promoted Tweet.
Campaign Dimensions Public Id site_public_id "googleplay_app_id" or "iphone_app_id" in the Card object, if available.
Campaign Dimensions Sub Ad Network adn_subadnetwork
  • Set to "twitterfeed" if the data was queried from "ALL_ON_TWITTER"
  • Set to "twittertpn" if the data was queried from "PUBLISHER_NETWORK"
Campaign Dimensions Target Countries target_countries_str For each sub-campaign (line item), we pull "countries" from the /targeting_criteria endpoint. We concatenate the results into this field.
Campaign Dimensions Text creative_text Depending on the type of the creative, either "name" from the Card object, "text" from the Tweet object, or "media_name" from the Account Media.
Campaign Dimensions Timezone adn_timezone "timezone" in the Account object
Creative Dimensions Creative Reported URL creative_reported_url Same as Campaign URL
Metrics Network Clicks adn_clicks “clicks”
Metrics Network Impressions adn_impressions "impressions"
Metrics Network Installs adn_installs "mobile_conversion_installs"
Metrics Original Cost adn_original_cost "billed_charge_local_micro"
Metrics Original Currency adn_original_currency “currency” in the Campaign object
Metrics Video Views video_views “video_total_views”
Metrics Completed Video Views completed_video_views “video_views_100”
Metrics Video Views - 25% video_views_25pct “video_views_25”
Metrics Video Views - 50% video_views_50pct “video_views_50”
Metrics Video Views - 75% video_views_75pct “video_views_75”

 

Was this article helpful?