Invoca | Call Keyword Dataset
This article details the dataset structure that ChannelMix considers standard for the Call Keyword dataset from Invoca. Data is pulled daily for the last 30 days with a 1 day lag.
| Field | Type | Description |
| Report Date | Date | Start of the call in the API user’s time zone in date format. |
| Start Time Local | Timestamp | Start of the call in the API user’s time zone, followed by offset from GMT. |
| Start Time XML | Timestamp | Start of the call in Soap XML formatted time. |
| Start Time UTC | Timestamp | Start of the call in UTC. |
| Start Time Network Time Zone | Timestamp | Start of the call in the networks’s time zone, followed by offset from GMT. |
| Start Time Network Time Zone XML | Timestamp | Start of the call in the network’s time zone in Soap XML formatted time. |
| Transaction ID | Text | Globally unique identifier for this transaction. Up-to 32 character string, can contain alphanumeric characters (i.e. 0-9A-Z) and the -. This is the Primary Key of the results. |
| Corrects Transaction ID | Text | [Correction only] Id of the original transaction that this transaction updates. Values in this row are the corrected ones and should replace the original values. Same format as transaction_id. Up-to 32 character string, can contain alphanumeric characters (i.e. 0-9A-Z) and the -. |
| Transaction Type | Text | The type of transaction - Call, Post Call Event, Reported Conversion, or Signal. |
| Original Order ID | Text | [Sales reporting only] Id of the original transaction that this row is in reference to. Up-to 32 character string, can contain alphanumeric characters (i.e. 0-9A-Z) and the -. |
| Advertiser Campaign ID | Text | The Invoca identifier of the campaign. |
| Advertiser Campaign ID from Network | Text | The Campaign ID from the network as set on the advertiser campaign. |
| Advertiser Campaign Name | Text | Name of the campaign. |
| Promo Line Description | Text | Additional details about the transaction source. |
| Dynamic Number Pool ID | Text | The ID of the pool. |
| Dynamic Number Pool Type | Text | The type of pool: Search, SearchKeyword or Custom |
| Dynamic Number Pool Referrer Campaign | Text | Google Ads Campaign name, provided by Google. |
| Dynamic Number Pool Referrer Campaign ID | Text | Google Ads Campaign ID, provided by Google. |
| Dynamic Number Pool Referrer Ad Group | Text | Google Ads Ad Group name, provided by Google. |
| Dynamic Number Pool Referrer Ad Group ID | Text | Google Ads Ad Group ID, provided by Google. |
| Dynamic Number Pool Referrer Ad | Text | Google Ads Ad Headline copy, provided by Google. |
| Dynamic Number Pool Referrer Ad ID | Text | Google Ads Ad ID, provided by Google. |
| Dynamic Number Pool Referrer Search Keywords | Text | Search keywords used. |
| Dynamic Number Pool Referrer Search Keywords ID | Text | AdWords Keyword ID, provided by Google. |
| Dynamic Number Pool Referrer Keyword Match Type | Text | The match type for the Keyword. |
| Dynamic Number Pool Referrer Search Engine | Text | Search engine used. |
| Dynamic Number Pool Referrer Search Type | Text | Paid or Organic. |
| Affiliate ID | Text | The Invoca identifier of the affiliate. |
| Affiliate ID from Network | Text | Affiliate ID from the network as set on the Invoca affiliate. |
| Affiliate Name | Text | Name of the affiliate. |
| Affiliate Commissions Ranking | Whole Number | Network ranking of affiliate’s commissions (0 to 5, and -1 being ‘new’). Blank if no affiliate. |
| Affiliate Call Volume Ranking | Whole Number | Network ranking of affiliate’s call volume (0 to 5, and -1 being ‘new’). Blank if no affiliate. |
| Affiliate Conversion Rate Ranking | Whole Number | Network ranking of affiliate’s conversion rate (0 to 5, and -1 being ‘new’). Blank if no affiliate. |
| Media Type | Text | Media type of the transaction source. |
| Call Source Description | Text | Source of the transaction. |
| Syndicated Ident | Text | The syndicated id for this call. Uniquely identifies syndication sources for a campaign. |
| Virtual Line ID | Text | The Promo Number ID from the network. |
| Call Result Description Detail Managed Advertiser | Text | Status of the transaction (For the call for Signal Transactions Rollup). |
| Advertiser Pay-in Localized | Decimal | Amount paid in by advertiser (Summed total amount for the call for Signal Transactions Rollup). |
| Matching Advertiser Pay-in Policies | Text | List of advertiser policies that matched (base, bonus1, bonus2, etc.) to determine the advertiser payin, separated by +. For example, base+bonus1+bonus3. Note that if there was any advertiser payin, this field guaranteed to start with base. |
| Pay-in Conditions | Text | Base condition with highlighting around the term(s) that disqualified advertiser payin. For example: duration > 1 min and in_region. |
| City | Text | City where transaction originated. |
| Region | Text | Region (state, province or country) where transaction originated. |
| Qualified Regions | Text | The list of regions that that the caller matched. |
| Verified Zip | Text | Zip Code entered by callers when prompted during call treatment. |
| Destination Phone Number | Text | The phone number where the call was transferred to (useful if an IVR transfers to multiple destinations). Up-to 20 character string, can contain numeric characters (i.e. 0-9) and the following additional characters: ‘-’, ‘#’, ‘*’, ‘x’, and ‘,’. ‘ |
| Transfer From Type | Text | Where the call came from. |
| Calling Phone Number | Text | Caller ID. Formatted as 12 characters like 866-555-1234. |
| Repeat Calling Phone Number | Text | Whether the call was a repeat call. Repeat call detection is not applied to shared or unavailable caller ids. |
| Mobile | Text | Landline or Mobile or empty string if type is unknown. |
| Duration in Seconds | Decimal | Duration of the call in seconds. Includes any time spent in an IVR tree before transferring to the call center. |
| Connect Duration in Seconds | Decimal | Duration in seconds that the call that was connected to the call center. |
| IVR Duration in Seconds | Decimal | Duration in seconds that the call spent in the IVR tree. |
| Keypresses | Text | List of unique keynames that were pressed during the call. |
| Keypresses 1 | Text | Name of the first key that was pressed. |
| Keypresses 2 | Text | Name of the second key that was pressed. |
| Keypresses 3 | Text | Name of the third key that was pressed. |
| Keypresses 4 | Text | Name of the fourth key that was pressed. |
| Recording | Text | URL to the call recording, if available. |
| Opt-in SMS | Text | Whether the caller opted in to receive an SMS promotion. |
| Complete Call ID | Text | Globally unique identifier for the call this transaction is part of. Up-to 32 character string, can contain alphanumeric characters (i.e. 0-9A-Z) and the -. |
| Real Time Response | Text | Response information returned to Invoca when using the real-time routing webhook. |
| Notes | Text | Free-form notations on transaction. |
| Reason Code | Text | Call center-specific status code giving the disposition of the call. |
| SKU List | Text | Comma-separated list of order SKUs as reported by the call center. |
| Quantity List | Text | Comma-separated list of order quantities as reported by the call center. Each quantity in the list matches the sku_list entry in that same position. |
| Sale Amount | Decimal | Total order amount (not including shipping) as reported by the call center. |
| Advertiser Call Fee Localized | Decimal | Advertiser Telecommunications fee associated with transaction (Summed total amount for the call for Signal Transactions Rollup). |
| Margin Localized | Decimal | Difference between advertiser_payin_localized and affiliate_payout_localized |
| Insert Date | Timestamp | ChannelMix Field: when the row was inserted into the dataset. |
| ChannelMix Profile | Text | ChannelMix Field: the ChannelMix Profile associated with the data. |