{"id":3355,"date":"2020-12-02T16:30:00","date_gmt":"2020-12-02T15:30:00","guid":{"rendered":"https:\/\/www.smsapi.com\/blog\/?p=3355"},"modified":"2023-02-07T12:41:09","modified_gmt":"2023-02-07T11:41:09","slug":"do-it-yourself-sms-campaigns-from-file","status":"publish","type":"post","link":"https:\/\/www.smsapi.com\/blog\/do-it-yourself-sms-campaigns-from-file\/","title":{"rendered":"Do it yourself #06 \u2013 SMS Campaigns from the File (video tutorial)"},"content":{"rendered":"\n<p><strong>Welcome to the next episode of&nbsp;SMSAPI&nbsp;\u201cDo it yourself\u201d&nbsp;Guide. This time we will show you how easy it is to&nbsp;send SMS campaigns directly from your files.<\/strong><\/p>\n\n\n\n<!--more-->\n\n\n\n<h2 class=\"wp-block-heading\">Watch the video tutorial on how to send text messages from files<\/h2>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"SMS Campaigns from the File | SMSAPI. Do It Yourself!\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/vZyjvKoDHto?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"import\">Importing a file<\/h2>\n\n\n\n<p>The process starts in the SMS gateway. The <a href=\"https:\/\/ssl.smsapi.com\/sms\/gate#tab_csv_no\" target=\"_blank\" rel=\"noreferrer noopener\">Numbers from file<\/a> tab allows you to send\u00a0bulk\u00a0messages to the contact database from CSV,\u00a0XLS,\u00a0XLSX,\u00a0ODS\u00a0files. It is worth remembering that the <strong>maximum number of\u00a0records\u00a0in one\u00a0campaign\u00a0is 800,000<\/strong>. <\/p>\n\n\n<div class=\"infobox infobox--attention post-content--full-width\">\n  <div class=\"infobox__icon\">\n    <img decoding=\"async\" src=\"https:\/\/www.smsapi.com\/blog\/wp-content\/themes\/smsapi-blog-2021\/assets\/icons\/exclamation.svg\">\n  <\/div>\n  <div class=\"infobox__title\">\n    <h4>Numbers from file \u2013 example CSV file<\/h4>\n  <\/div>\n  <div class=\"infobox__content\">\n    To ensure the correct import of data, we recommend <a href=\"https:\/\/ssl.smsapi.com\/examples\/sms_1.csv\">downloading a sample CSV file<\/a> and using it as a template.\n  <\/div>\n<\/div>\n\n\n\n<p>The condition of correct import is to upload the file only with phone numbers\u00a0and prefixes\u00a0in one column.\u00a0To\u00a0start the\u00a0campaign,\u00a0select or <a href=\"https:\/\/www.smsapi.com\/blog\/sender-id-how-to-send-branded-sms-company-name\/\" data-type=\"post\" data-id=\"3021\" target=\"_blank\" rel=\"noreferrer noopener\">choose a\u00a0sender\u00a0name<\/a>\u00a0and enter the\u00a0internal bulk name. Then add the file and create the content of the message with the addition of emoticons, <a href=\"https:\/\/www.smsapi.com\/en\/url-shortener\" target=\"_blank\" rel=\"noreferrer noopener\">shortened link<\/a>, file or <a href=\"https:\/\/www.smsapi.com\/en\/opt-out-sms\" target=\"_blank\" rel=\"noreferrer noopener\">opt-out link<\/a>.\u00a0<\/p>\n\n\n\n<p>Once the body of the message is ready, click &#8220;Next&#8221; and check the correctness of the settings in the summary. It is also possible to send a test message and save it as a draft.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"contentandphone\">Content and phone number from a file<\/h2>\n\n\n\n<p>The <a href=\"https:\/\/ssl.smsapi.com\/sms\/gate#tab_csv_content\" target=\"_blank\" rel=\"noreferrer noopener\">Numbers and content<\/a> tab allows you to send personalized messages\u00a0with various fields. The message content and recipient numbers are downloaded from the file. The <strong>maximum number of\u00a0records\u00a0in one\u00a0campaign\u00a0is 400,000<\/strong>. <\/p>\n\n\n<div class=\"infobox infobox--attention post-content--full-width\">\n  <div class=\"infobox__icon\">\n    <img decoding=\"async\" src=\"https:\/\/www.smsapi.com\/blog\/wp-content\/themes\/smsapi-blog-2021\/assets\/icons\/exclamation.svg\">\n  <\/div>\n  <div class=\"infobox__title\">\n    <h4>Numbers and content from file \u2013 example CSV file<\/h4>\n  <\/div>\n  <div class=\"infobox__content\">\n    To ensure the correct import of data, we recommend <a href=\"https:\/\/ssl.smsapi.com\/examples\/sms_cont_1.csv\">downloading a sample CSV file<\/a> and using it as a template. Here&#8217;s the <a href=\"https:\/\/ssl.smsapi.com\/examples\/sms_cont_2.csv\">example CSV file with parameters<\/a>.\n  <\/div>\n<\/div>\n\n\n\n<p>In the imported file, the <strong>first column&nbsp;should&nbsp;always&nbsp;be&nbsp;the recipient numbers, followed by the content<\/strong>. In this case, the file may contain personalized messages &#8211; individual for each number or&nbsp;the same&nbsp;for&nbsp;all numbers but with variables. It can be, e.g. a percentage of the discount granted, name, surname or any other value.&nbsp;Each of the <strong>variables must be&nbsp;entered in the third and subsequent columns<\/strong> of the CSV file. The number of columns with variables must correspond to the number of parameters in the text of the SMS. <\/p>\n\n\n\n<p>Sending and preparing messages is done in the same way as for numbers from a file &#8211; it consists&nbsp;of&nbsp;selecting the sender&nbsp;name, entering the&nbsp;bulk name, selecting the file with contents and launching the campaign after checking the settings.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-pullquote\"><blockquote><p>Next step: <a href=\"https:\/\/www.smsapi.com\/blog\/do-it-yourself-birthday-sms-periodic\/\" data-type=\"post\" data-id=\"3366\">Birthday SMS and Periodic SMS<\/a><\/p><\/blockquote><\/figure>\n\n\n<div class=\"infobox infobox--attention post-content--full-width\">\n  <div class=\"infobox__icon\">\n    <img decoding=\"async\" src=\"https:\/\/www.smsapi.com\/blog\/wp-content\/themes\/smsapi-blog-2021\/assets\/icons\/exclamation.svg\">\n  <\/div>\n  <div class=\"infobox__title\">\n    <h4>SMSAPI Do it yourself series:<\/h4>\n  <\/div>\n  <div class=\"infobox__content\">\n    <\/p>\n<ol>\n<li><a href=\"https:\/\/www.smsapi.com\/blog\/do-it-yourself-customer-portal-walkthrough\/\">Customer Portal Walkthrough<\/a><\/li>\n<li><a href=\"https:\/\/www.smsapi.com\/blog\/do-it-yourself-first-steps-customer-portal\/\">First Steps in the Customer Portal<\/a><\/li>\n<li><a href=\"https:\/\/www.smsapi.com\/blog\/do-it-yourself-sms-gateway\/\">SMS Gateway<\/a><\/li>\n<li><a href=\"https:\/\/www.smsapi.com\/blog\/do-it-yourself-contact-database\/\">Contact Database<\/a><\/li>\n<li><a href=\"https:\/\/www.smsapi.com\/blog\/do-it-yourself-building-customer-base-newsletter-sms\/\">Building Your Own Customer Base with Newsletter SMS<\/a><\/li>\n<li>SMS Campaigns from the File<\/li>\n<li><a href=\"https:\/\/www.smsapi.com\/blog\/do-it-yourself-birthday-sms-periodic\/\">Birthday SMS and Periodic SMS<\/a><\/li>\n<li><a href=\"https:\/\/www.smsapi.com\/blog\/do-it-yourself-history-reports\/\">History and Reports<\/a><\/li>\n<li><a href=\"https:\/\/www.smsapi.com\/blog\/do-it-yourself-shortened-links-cut-li\/\">Shortened Links cut.li<\/a><\/li>\n<li><a href=\"https:\/\/www.smsapi.com\/blog\/do-it-yourself-users-management\/\">Users Management<\/a><\/li>\n<\/ol>\n<p>\n  <\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Welcome to the next episode of&nbsp;SMSAPI&nbsp;\u201cDo it yourself\u201d&nbsp;Guide. This time we will show you how easy it is to&nbsp;send SMS campaigns directly from your files.<\/p>\n","protected":false},"author":21,"featured_media":3405,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[20,36],"class_list":["post-3355","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorial","tag-english","tag-do-it-yourself"],"_links":{"self":[{"href":"https:\/\/www.smsapi.com\/blog\/wp-json\/wp\/v2\/posts\/3355","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.smsapi.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.smsapi.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.smsapi.com\/blog\/wp-json\/wp\/v2\/users\/21"}],"replies":[{"embeddable":true,"href":"https:\/\/www.smsapi.com\/blog\/wp-json\/wp\/v2\/comments?post=3355"}],"version-history":[{"count":16,"href":"https:\/\/www.smsapi.com\/blog\/wp-json\/wp\/v2\/posts\/3355\/revisions"}],"predecessor-version":[{"id":5449,"href":"https:\/\/www.smsapi.com\/blog\/wp-json\/wp\/v2\/posts\/3355\/revisions\/5449"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.smsapi.com\/blog\/wp-json\/wp\/v2\/media\/3405"}],"wp:attachment":[{"href":"https:\/\/www.smsapi.com\/blog\/wp-json\/wp\/v2\/media?parent=3355"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.smsapi.com\/blog\/wp-json\/wp\/v2\/categories?post=3355"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.smsapi.com\/blog\/wp-json\/wp\/v2\/tags?post=3355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}